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 is the advantage in De-normalizing tables in DB2?

0 Answers  


Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,


What is the function of logging in the db2 database?

0 Answers  


How can you count the number of rows from a table tab?

0 Answers  


what is the difference between join and union?

4 Answers   IBM,






What is explain in db2?

0 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


What types of tables are there in the db2 database?

0 Answers  


what is static sql? what is dynamic sql? Give me details

3 Answers  


What is the maximum number of columns in a db2 table?

0 Answers   IBM,


what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,


What do you do to keep the cursor from closing after a commit?

1 Answers  


Categories