Getting Started › Dynamic SQL › Dynamic SQL in CA Datacom/DB

Dynamic SQL in CA Datacom/DB

Dynamic SQL in CA Datacom/DB is compatible with IBM DB2's dynamic SQL. Application programs that have been using DB2's dynamic SQL can precompile successfully and execute equivalently under the DB2 mode of CA Datacom/DB.

Five statements in CA Datacom/DB support dynamic SQL:

• DECLARE STATEMENT (see DECLARE STATEMENT)

  For syntax compatibility with other SQL implementations, the DECLARE STATEMENT is accepted by the CA Datacom/DB Preprocessor for SQL, but CA Datacom/DB ignores everything after the keyword STATEMENT up to the end-of-statement delimiter. CA Datacom/DB functionality is not affected.

• DESCRIBE (see DESCRIBE)

  This statement obtains information about a specified table or view, or about a statement that has been prepared for execution by the PREPARE statement.

• EXECUTE (see EXECUTE)

  This statement executes an SQL statement that has previously been prepared for execution by the PREPARE statement.

• EXECUTE IMMEDIATE (see EXECUTE IMMEDIATE)

  This statement prepares an executable form of an SQL statement from a character string form, executes the SQL statement, and then destroys the executable form.

• PREPARE (see PREPARE)

  This statement creates an executable SQL statement from a character string form of the statement. The executable form is called a prepared statement.

Three other CA Datacom/DB SQL statements also support dynamic SQL:

• DECLARE CURSOR (see DECLARE CURSOR)
• FETCH (see FETCH)
• OPEN (see OPEN)