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.