SQL$HELP72.HLB  —  SET_SQLDA, Example
    Example 1: Using the NAMED MARKERS feature

    This example shows that enabling the NAMED MARKERS feature will
    allow SQL to promp tfor one value and the displayed Rdb strategy
    shows that only one variable is used.

    -> SET SQLDA 'ENABLE NAMED MARKERS';
    -> SELECT LAST_NAME FROM EMPLOYEES WHERE FIRST_NAME = :F_NAME AND LAST_NAME <>
    :F_NAME;
    in:  [0] typ=449 len=46
    out: [0] typ=453 len=14
    [SQLDA - reading 1 fields]
    -> Alvin
    Tables:
      0 = EMPLOYEES
    Conjunct: (0.FIRST_NAME = <var0>) AND (0.LAST_NAME <> <var0>)
    Get     Retrieval sequentially of relation 0:EMPLOYEES
     0/FIRST_NAME/Varchar(42/46): Alvin
    [SQLDA - displaying 1 fields]
     0/LAST_NAME: Toliver
    [SQLDA - displaying 1 fields]
     0/LAST_NAME: Dement

    Example 2: Using the PADDING feature

    The following example shows that the derived type for the named
    parameter MI is a SQLDA_CHAR (453) of length 1. The input data
    ('AA') is truncated on assignment and the incorrect results are
    returned. By adding a small padding the type is changed to SQLDA_
    VARCHAR (449) of length 3 and a correct comparison is performed.

    -> ATTACH 'filename sql$database';
    -> SET SQLDA 'enable named markers, nopadding';
    -> SELECT LAST_NAME FROM EMPLOYEES WHERE MIDDLE_INITIAL = :MI;
    in:  [0] typ=453 len=1
    out: [0] typ=449 len=18
    [SQLDA - reading 1 fields]
    -> AA
    [SQLDA - displaying 1 fields]
     0/LAST_NAME: Toliver
    [SQLDA - displaying 1 fields]
     0/LAST_NAME: Lengyel
    [SQLDA - displaying 1 fields]
     0/LAST_NAME: Robinson
    [SQLDA - displaying 1 fields]
     0/LAST_NAME: Ames
    -> SET SQLDA 'padding 2 characters';
    -> SELECT LAST_NAME FROM EMPLOYEES WHERE MIDDLE_INITIAL = :MI;
    in:  [0] typ=449 len=7
    out: [0] typ=449 len=18
    [SQLDA - reading 1 fields]
    -> AA
    -> EXIT;
    Enter statement:

    Note that the VARCHAR requires an extra 4 bytes for the length
    information in the SQLDA2 used by the Dynamic SQL testing
    program.
Close Help