Using host variables in RPG/400 applications that use SQL

All host variables used in SQL statements must be explicitly declared. LOB, XML, ROWID, result set locator, and binary host variables are not supported in RPG/400®.

SQL embedded in RPG/400 does not use the SQL BEGIN DECLARE SECTION and END DECLARE SECTION statements to identify host variables. Do not put these statements in the source program.

All host variables within an SQL statement must be preceded by a colon (:).

The names of host variables must be unique within the program.