Application Development Guide


Programming Considerations for REXX

Special host-language programming considerations are discussed in the following pages. Included is information on embedding SQL statements, language restrictions, and supported data types for host variables.
Note:REXX support stabilized in DB2 Version 5, and no enhancements for REXX support are planned for the future. For example, REXX cannot handle SQL object identifiers, such as table names, that are longer than 18 bytes. To use features introduced to DB2 after Version 5, such as table names from 19 to 128 bytes long, you must write your applications in a language other than REXX.

Because REXX is an interpreted language, no precompiler, compiler, or linker is used. Instead, three DB2 APIs are used to create DB2 applications in REXX. Use these APIs to access different elements of DB2.

SQLEXEC
Supports the SQL language

SQLDBS
Supports command-like versions of DB2 APIs.

SQLDB2
Supports a REXX specific interface to the command-line processor. See API Syntax for REXX for details and restrictions on how this interface can be used.


[ Top of Page | Previous Page | Next Page ]