Library /sys$common/syshlp/SQL$HELP72.HLB  —  EXECUTE
    Dynamically executes a previously prepared statement.

    The EXECUTE statement is a dynamic SQL statement. 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.

    If a program needs to dynamically execute a statement more than
    once, the statement should be prepared first with the PREPARE
    statement and executed each time with the EXECUTE statement.
    SQL does not parse and compile prepared statements every time it
    dynamically executes them with the EXECUTE statement.
Additional Information: explode extract
Environment Format Arguments Example
Close Help