ADDRESS SQL
Syntax:
ADDRESS SQL [SQL-command]
Commands:
REXXTOOLS-supported SQL commands.
Module Name:
SWXASQL2 (dynamic SQL interface)
Service Description:
ADDRESS SQL is a host command environment. As with other host
command environments, you switch to the SQL host command
environment using the ADDRESS instruction. To send a command to
the host command environment you simply embed a command string
(or a REXX expression that resolves to a string) in your program.
Returned Information:
The SQL host command environment can return many variables
depending on the type of SQL command to be executed and the
success of the operation.
Examples:
-
Execute a COMMIT command:
address sql
"exec sql commit work;"
© Copyright 1998 by Open Software Technologies, Inc.