Delimit SQL statements with EXEC SQL and END-EXEC. The EXEC SQL and END-EXEC delimiters must each be complete on one line. You cannot continue them across multiple lines.
You also need to do these special steps:
Restriction: You cannot use SQL statements in object-oriented classes or methods.
You can use SQL statements even for large objects (such as BLOB and CLOB) and compound SQL. The size of large objects is limited to 2 GB for a group or elementary data item.
related tasks
Using SQL INCLUDE with the DB2 coprocessor
Using binary items in SQL statements
Determining the success of SQL statements
DB2 UDB Application Development Guide: Programming Client Applications