How to define the a field which accepts value till 99999.99
in db2
Answers were Sorted based on User's Feedback
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 |
What is the advantage in De-normalizing tables in DB2?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is the function of logging in the db2 database?
How can you count the number of rows from a table tab?
what is the difference between join and union?
What is explain in db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What types of tables are there in the db2 database?
what is static sql? what is dynamic sql? Give me details
What is the maximum number of columns in a db2 table?
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.
What do you do to keep the cursor from closing after a commit?