SQLEXEC Verb - Execute SQL Command

Syntax

SQLEXEC(sqlchan{,ERR=lineref}){expr{,expr...}}

Description

The SQLEXEC verb executes the command set up using the SQLPREP and, optionally, the SQLSET commands. If arguments are given following the SQLEXEC, they are passed to the SQL command as argument #1, #2, and so on. The arguments are used in replacing the SQL "?" parameters in the order they are encountered in the SQLPREP command.

Examples

16000 SQLPREP (SQL1)"select * from CUSTOMERS where
16000:LAST_NAME > ?"
16010 SQLEXEC (SQL1)LAST$

See Also

Verbs - Alphabetical Listing