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 / rajesh
u can declare in application program(cobol)
01 dec pic 9(5)v9(2) comp-3. is equal to dec(7,2)
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
How do you select a row using indexes in db2?
What does db2 plan contain?
Explain about cursor stability?
What is meant by union and union all?
Explain the contents that are a part of dclgen.
Define db2 and its databases?
How does db2 sample database connect?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How is the value function used?
What is the difference between cursor stability and repeatable read isolation levels?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the difference between nvl and coalesce?
What is a db2 tablespace?
When do you specify the isolation level?
Is db2 a programming language?