Syntax |
Example |
Description/ Remarks |
Q_EXECUTE
connection_number, |
Q_EXECUTE 1, |
This command will execute an SQL statement but will not return a result set. It returns 1 if a command is successfully executed and 0 if an error occurs. Connection_number : 1-10. A template may have up to 10 distinct connections to external data sources. A separate data buffer is maintained for each connection. Note: The only difference between Q_START and Q_EXECUTE is that the latter doesn’ t expect a result set back. To execute a stored procedure that does not return a result set, simply run the stored procedure. Depending on the database, the syntax may be different. For example, to run a stored procedure in Pervasive.SQL you type CALL <stored procedure name>. In Oracle, type EXEC <stored procedure name>. In Microsoft SQL Server, type EXEC <stored procedure name> or simply the name or the stored procedure with no keyword. |