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 universal database?
What is the maximum No of rows per page?
How to execute stored procedures?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How can we read records for specific member in CL? AND rpg?
What are the benefits of using the db2 database?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the picture clause of null indicator variable?
How do you select a row using indexes in db2?
What is the maximum size of varchar data type in db2?
What is the difference between plan and package in db2?
Why select is not preferred in embedded sql programs?
What are the full forms of spufi and dclgen and why are they used?
How to compare data between two tables in db2?
What is db2 purescale?