How to define the a field which accepts value till 99999.99
in db2

Answers were Sorted based on User's Feedback



How to define the a field which accepts value till 99999.99 in db2..

Answer / kk

in db2 decimal(7,2) & application cobol pgm 9(5)v99.

Is This Answer Correct ?    33 Yes 1 No

How to define the a field which accepts value till 99999.99 in db2..

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

How to define the a field which accepts value till 99999.99 in db2..

Answer / keshireddy

PIC S9(5)V99

Is This Answer Correct ?    2 Yes 19 No

Post New Answer

More DB2 Interview Questions

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

0 Answers  


List out the buffer pools in db2

0 Answers  


What is an asychronous write?

1 Answers  


i want to maintain uniqueness on pdf without make lf??????????

0 Answers  


COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  






What is a composite index and how does it differ from a multiple index?

1 Answers  


What do you need to do before you do EXPLAIN?

1 Answers  


Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  


What is lock contention?

1 Answers  


Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What is db2 plan table?

0 Answers  


Categories