SQL$HELP_OLD72.HLB  —  SQLDA
    An SQL Descriptor Area (SQLDA) is a collection of parameters used
    only in dynamic SQL programs. SQL provides two descriptor areas:
    SQLDA and SQLDA2.

    Dynamic SQL lets programs accept or generate SQL statements at
    run time, in contrast to SQL statements that are part of the
    source code for precompiled programs or SQL module language
    procedures. Unlike precompiled SQL or SQL module language
    statements, such dynamically executed SQL statements are not
    necessarily part of a program's source code, but can be generated
    while the program is running. Dynamic SQL is useful when you
    cannot predict the type of SQL statement your program will need
    to process.

    To use an SQLDA, host languages must support pointer variables
    that provide indirect access to storage by storing the address
    of data instead of directly storing data in the variable. The
    languages supported by the SQL precompiler that also support
    pointer variables are PL/I, C, BASIC, and Ada. Any other language
    that supports pointer variables can use an SQLDA, but must
    call SQL module procedures containing SQL statements instead
    of embedding the SQL statements directly in source code.

    See the Oracle Rdb SQL Reference Manual for more detailed
    information.
Close Help