What is the COBOL picture clause for a DB2 column defined
as DECIMAL(11,2)?
Answers were Sorted based on User's Feedback
Answer / pradeep
it is s9(m-n)v9(n) comp-3 in this case m=11, n=2
ie s9(9)v9(2) comp-3
Is This Answer Correct ? | 30 Yes | 4 No |
PIC S9(9)V99 COMP-3.
In DECIMAl(11,2), 11 indicates the size of data type and 2
indicates the precision.
Is This Answer Correct ? | 1 Yes | 0 No |
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is the result of open cursor statement?
What's the difference between DB2 active log and archive log? Thanks a lot...
What is the purpose of using commit?
Can we update view in db2?
What is a correlated sub query?
What is an instance in db2?
what is the input to PLAN? what is the input to DBRM?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?