Author |
Message |
Topic: Calculate the difference between 2 dates in years |
omswarup
Replies: 5
Views: 2465
|
Forum: Database Posted: Wed Jun 16, 2010 4:12 am Subject: Calculate the difference between 2 dates in years |
Thanks a lot Kolusu and papadi for the inputs.
Regards,
Omswarup
omswarup,
As papadi pointed you can use date arithmetic to get validate the age. The result of date arithmetic is DECIMAL(8,0 ... |
Topic: Calculate the difference between 2 dates in years |
omswarup
Replies: 5
Views: 2465
|
Forum: Database Posted: Mon Jun 14, 2010 10:50 pm Subject: Calculate the difference between 2 dates in years |
I have a situation in which i have a column in a Db2 tabel which gives me Date of Birth, is there anyways of writing a query which would get me the details of the person whose age is greater than 18 y ... |
Topic: S0C6 abend |
omswarup
Replies: 2
Views: 2348
|
Forum: Application Programming Posted: Mon Mar 23, 2009 4:34 am Subject: S0C6 abend |
Temujin,
Here is the reasons one could get a S0C6 for
1) A data, instruction, or control-word address does not
specify the proper storage boundary alignment.
... |
Topic: Cursor handling in Easytrieve |
omswarup
Replies: 4
Views: 5422
|
Forum: Application Programming Posted: Mon Mar 23, 2009 4:27 am Subject: Cursor handling in Easytrieve |
Thanks a lot Kolusu for the reply , Apologies for posting the same question in two forums.
I had one more clarification , cant we open the cursor only once and then fetch the table for all the p ... |
Topic: Cursor handling in Easytrieve |
omswarup
Replies: 4
Views: 5422
|
Forum: Application Programming Posted: Thu Mar 19, 2009 11:33 pm Subject: Cursor handling in Easytrieve |
Thanks a lot Kolusu for the reply , Apologies for posting the same question in two forums.
I had one more clarification , cant we open the cursor only once and then fetch the table for all the p ... |
Topic: Cursor handling in Easytrieve |
omswarup
Replies: 4
Views: 5422
|
Forum: Application Programming Posted: Thu Mar 19, 2009 3:31 am Subject: Cursor handling in Easytrieve |
i am stuck with a weird problem in eastrieve. Could you please help me out in this.
I have a eaasytrieve program which uses a input file to get a particular value like policy number and fetches the ... |
|