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


Please Help Members By Posting Answers For Below Questions

What is universal database?

608


What is the maximum No of rows per page?

622


How to execute stored procedures?

615


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?

7478


How can we read records for specific member in CL? AND rpg?

227






What are the benefits of using the db2 database?

656


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1645


What is the picture clause of null indicator variable?

685


How do you select a row using indexes in db2?

637


What is the maximum size of varchar data type in db2?

638


What is the difference between plan and package in db2?

565


Why select is not preferred in embedded sql programs?

704


What are the full forms of spufi and dclgen and why are they used?

646


How to compare data between two tables in db2?

654


What is db2 purescale?

538