How to define the a field which accepts value till 99999.99
in db2
Answer Posted / ram prajapati
in db2 decimal(7,2) & application cobol pgm 9(5).99
because 9(5)v99 will print 9999999 and not 99999.99.
9(5).99 is an edited pic variable so it will show the
desired output while the previous one will not.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the reason behind not using select * in embedded sql programs?
What is bind package and plan in db2?
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
What is collection in db2 bind?
What is a collection in db2?
How to take backup of table in db2?
How and when does the db2 enforces the unique key?
What is universal database?
Outputs of explain are with matchcols = 0. What does this signify?
What is ibm db2 client?
How can you find out the # of rows updated after an update statement?
Define db2 and its databases?
How to check sequence on a table in db2?
Can we delete records from view?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?