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
- 8548 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 |
What else is there in the PLAN apart from the access path?
what's the error code for Unique Index Violation?
What is buffer pool and list some of them?
what is difference between Plan and Package
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How does db2 sample database connect?
Why do we bind in db2?
what is difference between Static call and Dynamic call? How does it function?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is nvl in db2?
COBOL 
