SQL Reference Guide > SQL Reference Guide > Working with Embedded SQL > Data Handlers for Large Objects > Restrictions on Data Handlers
Was this helpful?
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
Last modified date: 04/03/2024