Using national decimal data in SQL statements

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:

  • It must be signed.
  • It must be specified with the SIGN LEADING SEPARATE clause.
  • USAGE NATIONAL must be in effect implicitly or explicitly.

related concepts  
Formats for numeric data