You can use national decimal host variables in EXEC SQL statements when you use either the integrated DB2 coprocessor or the DB2 precompiler. You do not need to specify the CCSID in EXEC SQL DECLARE statements in either case. CCSID 1200 is used automatically.
Any national decimal host variable that you specify in an EXEC SQL statement must have the following characteristics:
related concepts
Formats for numeric data
related tasks
Defining national numeric data items
related references
Differences in how the DB2 precompiler and coprocessor behave