Application Development Guide

Host or AS/400 Server SQL Statements Supported by DB2 Connect

The following statements compile successfully for host or AS/400 server processing but not for processing with DB2 Universal Database systems:

• ACQUIRE
• DECLARE (modifier.(qualifier.)table_name TABLE ...
• LABEL ON

These statements are also supported by the command line processor.

The following statements are supported for host or AS/400 server processing but are not added to the bind file or the package and are not supported by the command line processor:

• DESCRIBE statement_name INTO descriptor_name USING NAMES
• PREPARE statement_name INTO descriptor_name USING NAMES FROM ...

The precompiler makes the following assumptions:

• Host variables are input variables
• The statement is assigned a unique section number.