ASA Programming Guide
  Embedded SQL Programming

Embedded SQL command summary

There are two groups of embedded SQL commands. Standard SQL commands are used by simply placing them in a C program enclosed with EXEC SQL and a semi-colon (;). CONNECT, DELETE, SELECT, SET, and UPDATE have additional formats only available in embedded SQL. The additional formats fall into the second category of embedded SQL specific commands.

For descriptions of the standard SQL commands, see SQL Statements.

Several SQL commands are specific to embedded SQL and can only be used in a C program.

For more information about these embedded SQL commands, see SQL Language Elements.

Standard data manipulation and data definition statements can be used from embedded SQL applications. In addition the following statements are specifically for embedded SQL programming:

• ALLOCATE DESCRIPTOR    allocate memory for a descriptor

  See ALLOCATE DESCRIPTOR statement [ESQL]

• CLOSE    close a cursor

  See CLOSE statement [ESQL] [SP]

• CONNECT    connect to the database

  See CONNECT statement [ESQL] [Interactive SQL]

• DEALLOCATE DESCRIPTOR    reclaim memory for a descriptor

  See DEALLOCATE DESCRIPTOR statement [ESQL]

• Declaration Section    declare host variables for database communication

  See Declaration section [ESQL]

• DECLARE CURSOR    declare a cursor

  See DECLARE CURSOR statement [ESQL] [SP]

• DELETE (positioned)    delete the row at the current position in a cursor

  See DELETE (positioned) statement [ESQL] [SP]

• DESCRIBE    describe the host variables for a particular SQL statement

  See DESCRIBE statement [ESQL]

• DISCONNECT    disconnect from database server

  See DISCONNECT statement [ESQL] [Interactive SQL]

• DROP STATEMENT    free resources used by a prepared statement

  See DROP STATEMENT statement [ESQL]

• EXECUTE    execute a particular SQL statement

  See EXECUTE statement [ESQL]

• EXPLAIN    explain the optimization strategy for a particular cursor

  See EXPLAIN statement [ESQL]

• FETCH    fetch a row from a cursor

  See FETCH statement [ESQL] [SP]

• GET DATA    fetch long values from a cursor

  See GET DATA statement [ESQL]

• GET DESCRIPTOR    retrieve information about a variable in a SQLDA.

  See GET DESCRIPTOR statement [ESQL]

• GET OPTION    get the setting for a particular database option

  See GET OPTION statement [ESQL]

• INCLUDE    include a file for SQL preprocessing

  See INCLUDE statement [ESQL]

• OPEN    open a cursor

  See OPEN statement [ESQL] [SP]

• PREPARE    prepare a particular SQL statement

  See PREPARE statement [ESQL]

• PUT    insert a row into a cursor

  See PUT statement [ESQL]

• SET CONNECTION    change active connection

  See SET CONNECTION statement [Interactive SQL] [ESQL]

• SET DESCRIPTOR    describe the variables in a SQLDA and place data into the SQLDA

  See SET DESCRIPTOR statement [ESQL]

• SET SQLCA    use an SQLCA other than the default global one

  See SET SQLCA statement [ESQL]

• UPDATE (positioned)    update the row at the current location of a cursor

  See UPDATE (positioned) statement [ESQL] [SP]

• WHENEVER    specify actions to occur on errors in SQL statements

  See WHENEVER statement [ESQL]