SQL$HELP_OLD72.HLB  —  EXECUTE_IMMEDIATE
    Dynamically prepares, executes, and releases an SQL statement.

    The EXECUTE IMMEDIATE statement is a dynamic SQL statement.
    Dynamic SQL lets programs accept or generate SQL statements at
    run time, in contrast to precompiled statements, which must be
    embedded in the program before it is compiled. Unlike embedded
    statements, such dynamically executed SQL statements are not
    necessarily part of the 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.

    The EXECUTE IMMEDIATE statement cannot contain parameter markers.
    However, if the statement meets those restrictions and will
    be dynamically executed only once, use the EXECUTE IMMEDIATE
    statement instead of PREPARE and EXECUTE statements.
Additional Information: explode extract
Environment Format Arguments Example
Close Help