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.
About this task
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 SEPARATEclause. USAGE NATIONALmust be in effect implicitly or explicitly.