Accessing DB2 table with search key DATE field

[NitinDwivedi]

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

[NitinDwivedi · Accepted solution]

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