A Table feild is declared as Decimal(7,2). I want to insert
the decimal in to this column thru cobol-db2 program.
How should I declare my local input file variable
or any suggestion?
Answer Posted / nitin
Hello Sumanath and Rajesh
No declaring 9(5)V99 / 9(5)v9(2) comp-3 this way was
not working. I tried this also.
For Example: if the input is 123.45 from flat file
and 1. If I declare 01 W-var pic 9(5)V99
then value of W-var will be 123 45 (It assumed space at
place of decimal) and the same value 123 45 it tried to
moved in the db2 table host varible. which in turn throw
SOC7.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is bind package and plan in db2?
What is nvl in db2?
What is a system catalog table in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is db2 purescale?
What is the syntax for creating a table in the db2 database?
What does db2 plan contain?
How to find the maximum value in a column in the db2 database?
How is a typical db2 batch pgm executed?
How do I import a csv file into db2?
What is runstats utility in db2?
What is db2 stogroup?
How can the duplicate values be eliminated from db2 select?
What is ibm db2 connect?
What is precompiler in db2?