SQL$HELP72.HLB  —  PREPARE
    Prepares an SQL statement dynamically generated by a program for
    execution, and assigns a name to that statement.

    Dynamic SQL lets programs accept or generate SQL statements
    at run time, in contrast to 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.

    The PREPARE . . . INTO statement stores in the SQLDA the number
    and data types of any select list items of a prepared statement.
    The SQLDA provides information about dynamic SQL statements to
    the program and information about memory allocated by the program
    to SQL.

    The Oracle Rdb SQL Reference Manual describes in more detail
    the specific fields of the SQLDA, and how programs use it to
    communicate about select list items in prepared statements.
Additional Information: explode extract
Environment Format Arguments Examples
Close Help