How to define the a field which accepts value till 99999.99
in db2
- 3 Answers
- 8001 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What is copy pending status in db2?
Mention the downsides of page level lock.
Which component is responsible for processing sql statements and selecting access paths?
What is a view? Why use it?
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
Explain the benefits you can get from mainframe connect?
What does sqlcabc has?
What does the sqlcode of -818 pertain to?
What do you need to do before you do EXPLAIN?
My SQL is not performing well. Describe how will you fine tune it?
How to rename a table in DB2 ?
What is a Cartesian product?
COBOL 
