Embedded SQL Programming Guide

DRDA Server SQL Statements Rejected by DB2 Connect

The following SQL statements are not supported by DB2 Connect and not supported by the command line processor:

COMMIT WORK RELEASE
DECLARE state_name, statement_name STATEMENT
DESCRIBE statement_name INTO descriptor_name USING xxxx (where xxxx is ANY, BOTH, or LABELS)
PREPARE statement_name INTO descriptor_name USING xxxx FROM :host_variable (where xxxx is ANY, BOTH, or LABELS)
PUT ...
ROLLBACK WORK RELEASE
SET :host_variable = CURRENT ...

DB2 for VSE & VM extended dynamic SQL statements are rejected with -104 and syntax error SQLCODEs.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]