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

Define db2 and its databases?

629


Explain about dbrm.

616


Mention the downsides of page level lock.

719


How to fetch the last row from the table in SQL (db2)?

1043


what is a corelated subquerry?

668






Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2693


How do we specify index to include or not during bind process.

1679


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

239


What is with ur in db2?

770


What do you mean by cursor?

593


What is lock escalation in db2?

582


What is db2 bind process?

765


What is difference between alias and synonym in db2?

652


What is the use of with ur in db2?

625


What is performance tuning db2?

629