SQL$HELP_OLD72.HLB  —  SET_SQLDA, Arguments

1  –  Literal|Host-Variable

    Parameter passed to the statement. Must be a literal or a host
    variable containing one or more SQLDA options (see sqlda_
    options syntax diagram for details). If more than one option
    is specified, they must be separated by commas.

2  –  sqlda_options

    One or more keyword clauses. If more than one clause is
    specified, they must be separated by commas.

3  –  ENABLE

    The ENABLE clause activates one of the following behaviors for
    Dynamic SQL.

    -  INSERT RETURNING - The default behavior of INSERT ...
       RETURNING when executed by dynamic SQL is to place parameters
       from the RETURNING INTO clause in to the INPUT SQLDA. This
       behavior is maintained for backward compatibility. This option
       allows the programmer to force different (and corrected)
       behavior for the non-compound use of this statement.

                                      NOTE

          If the INSERT RETURNING statement is included in a
          compound statement then the parameters are handled
          correctly.

    -  NAMED MARKERS - as well as traditional parameters markers
       (?). Dynamic SQL will now accept named, host-variable style
       parameter markers. See the Usage Notes for further details and
       examples.

    -  ROWID TYPE - returns DBKEY values as a special type (SQLDA_
       ROWID, 455) to make processing of the DBKEY values easier.
       For instance, in prior releases the SQLDA name field (SQLNAME)
       for DBKEY entries in the SQLDA was the only way to distinguish
       these values from other CHAR or VARCHAR columns - it would be
       either DBKEY or ROWID. If a query renamed the DBKEY column,
       then the application had no information in the SQLDA to
       indicate that the CHAR or VARCHAR value was binary data. In
       all respects, the SQLDA_ROWID type appears as a fixed length
       string of octets (possibly containing octets of zero which the
       C language would treat as a NULL terminator for a string).

4  –  DISABLE

    The DISABLE clause deactivates one of the specified behaviors for
    Dynamic SQL. See ENABLE clause for a list of options.

5  –  ORACLE_LEVEL1|ORACLE_LEVEL2

    Either of these options will set the SQLDA to supply enhanced
    semantics. These options are currently reserved for the use
    of the OCI Services for Rdb product that is part of Oracle Rdb
    SQL/Services component. This setting also implicitly enables
    NAMED MARKERS.

6  –  PADDING n CHARACTERS

    This option directs SQL to configure the SQLDA with larger
    CHARACTER VARYING strings than would normally be seen. The value
    of n is an unsigned numeric literal that specifies the number of
    characters that are added to the estimated length. Any CHARACTER
    (CHAR) types are converted to CHARACTER VARYING (VARCHAR). This
    rule is applied to comparison operators <, <=, >, >=, =, <>, and
    string functions (STARTING WITH, CONTAINING).

7  –  NOPADDING

    This option sets the number of padding characters to 0. This also
    implies that derived CHARACTER (CHAR) types are not converted to
    CHARACTER VARYING (VARCHAR) when PADDING CHARACTERS is used. This
    is the default setting.

                                   NOTE

       Oracle recommends that applications always check for SQLDA_
       CHAR and SQLDA_VARCHAR so that the correctly formatted data
       is made available to SQL.

8  –  SQL99|SQL92|MIA|SQL89|SQLV40

    Any of these options will revert to the default semantic for the
    SQLDA which includes disabling NAMED MARKERS.
Close Help