Restrictions on Data Handlers
Data handlers are subject to the following restrictions:
• The DATAHANDLER clause is not valid in interactive SQL.
• The DATAHANDLER clause cannot be specified in a dynamic SQL statement.
• The DATAHANDLER clause cannot be specified in an execute procedure statement.
• The DATAHANDLER clause cannot be specified in a declare section.
• A data handler routine must not issue a database query. The following statements are valid in data handlers:
– PUT DATA and GET DATA
– ENDDATA (for read data handlers only)
– INQUIRE_SQL and SET_SQL
– Host language statements