Accessing DB2 table with search key DATE field

NitinDwivedi — Tue, 24 Jun 2014 14:55:18 GMT

Hi ,

I am accessing DB2 table thru SAS program, I need to retrieve infomation based on DATE field of DB2 table, Please advise how it can be done

I need to extract data from DB2 table from execution date + 1 month from execution date

Type Column Name

DATE B

Getting exec_date in following format ddmmyyyy thru JCL.

Select A
      ,B
      ,C
From TABLE_Ax
      ,TABLE_Bx
Where B   + 1 Month > exec_date
   and B             <= exec_date

How can I change exec_date into DATE field of DB2 table(DD.MM.YYYY) and also add +1 month to database date field

Re: Accessing DB2 table with search key DATE field

NitinDwivedi — Wed, 25 Jun 2014 09:37:12 GMT

Hi,

I have got the solution , refer SAS format and informat reference document for that,

To convert date parameter received from jcl,

Execdate=put(input(substr(param),ddmmyy10.),ddmmyyp10.) ;

and in where clause need 's' in defining month.

Where B + 1 Months > exec_date

and B <= exec_date