Determine statement information at run time

Consider a dynamic-management structure when you execute an SQL statement under the following conditions:

• Something is not known about the structure of an SQL statement:
  • The type of statement to execute is unknown.
  • The table name is unknown and therefore the columns to be accessed are unknown.
  • The WHERE clause is missing.
• Something is not known about the number or type of values that passes between the program and the database server:
  • The number and data types of columns in the select list of a SELECT or in a column list of an INSERT
  • The number and data types of input parameters in the statement are unknown
  • The number and data types of return values of a user-defined function (executed with the EXECUTE FUNCTION statement) are unknown