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
Where can you declare a cursor in a cobol-db2 program?
What is syscat in db2?
What is meant by union and union all?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is dbrm in db2 database?
Which components manage deadlocks in db2?
When the like statement is used?
What is query_cache_limit?
What is sqlca?
Explain correlated sub-queries.
What db2 400?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is multi row fetch in db2?
Mention data types used in db2 ?