Interested to Buy Any Domain ? << Click Here >> for more details...
How to define the a field which accepts value till 99999.99
in db2
- 3 Answers
- 8734 Views
- I also Faced
- E-Mail Answers
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 |
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is the difference between oracle and db2?
How to resolve -917 sql code in DB2?
What is the syntax required for the creation of a cursor?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is view db2?
What are the different types of base tables?
Explain about cursor stability?
What is the cascade rule and how does it relate to deletions made with a subselect?
What is a clustering index?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
COBOL 
