# 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.