Syntax

Example

Description/ Remarks

Q_EXECUTE connection_number,
"SQL Statement"

Q_EXECUTE 1,
"CREATE OR REPLACE
VIEW SPCTEST ( PARTNO) AS
SELECT PARTNO FROM VSTDS"

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.