Kbase P16940: DataServers: What is a send-sql-statement?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/9/2003 |
|
Status: Verified
GOAL:
What is a send-sql-statement ?
FACT(s) (Environment):
MS SQL DataServer
FACT(s) (Environment):
ODBC DataServer
FACT(s) (Environment):
Oracle DataServer
FIX:
Send-sql-statement is a special STORED-PROCEDURE that allows you pass SQL statements to the data source. The following code is a sample that uses a SELECT statement to obtain cust-num and name fields from customer table.
DEFINE VAR h1 AS INTEGER.
RUN STORED-PROC send-sql-statement h1 = PROC-HANDLE
("SELECT cust_num, name
FROM customer WHERE name like 'A_'")
FOR EACH proc-text-buffer WHERE PROC-HANDLE = h1:
DISPLAY proc-text-buffer.
END.
CLOSE STORED-PROC send-sql-statement WHERE PROC-HANDLE = h1.