SQL$HELP_OLD72.HLB  —  Dynamic SQL
    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 created
    while the program is running. Dynamic SQL is useful when you
    cannot predict the type of SQL statement your program will need
    to process.

    You cannot use dynamic SQL statements in interactive SQL, but
    interactive HELP includes quick reference information on these
    dynamic SQL statements:

    o  Dynamic DECLARE CURSOR (listed as DECLARE Dynamic_CURSOR)

    o  DESCRIBE

    o  EXECUTE

    o  EXECUTE IMMEDIATE (listed as EXECUTE_IMMEDIATE)

    o  Extended Dynamic DECLARE CURSOR (listed as DECLARE Extended_
       Dynamic_CURSOR)

    o  FETCH

    o  INCLUDE

    o  INSERT

    o  OPEN

    o  PREPARE

    o  RELEASE
Close Help