MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 6 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Calculate the difference between 2 dates in years
omswarup

Replies: 5
Views: 2465

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group