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:

  1. Execute a COMMIT command:
    address sql
    "exec sql commit work;"
    

© Copyright 1998 by Open Software Technologies, Inc.