Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 18927 Views
- IBM, I also Faced
- E-Mail Answers
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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is explain in db2?
How can the duplicate values be eliminated from db2 select?
What is a plan and package in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Why do we need reorg in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What does sqlcabc has?
What is a collection in db2?
What do you mean by cursor?
What is a db2 tablespace?
Outputs of explain are with matchcols = 0. What does this signify?
Where do you specify them?
How do you select a row using indexes in db2?
Can we delete records from view?
