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
- 8873 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 |
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
Define check constraint.
What do you need to do before you do EXPLAIN ?
What is host variable in db2 cobol?
What does the RUNSTATS Utility do?
how do we solve soc 7 and soc4 ?
What is the usage of open cursor command?
What happens to the PLAN if index used by it is dropped?
How can we read records for specific member in CL? AND rpg?
Outputs of explain are with matchcols = 0. What does this signify?
What is the function of buffer manager?
What are the disadvantages of PAGE level lock?
COBOL 
