Help using Base SAS procedures

Accessing DB2 table with search key DATE field

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

Accessing DB2 table with search key DATE field


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


Accepted Solutions
Solution
‎06-25-2014 05:37 AM
Occasional Contributor
Posts: 17

Re: Accessing DB2 table with search key DATE field

Posted in reply to NitinDwivedi

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

View solution in original post


All Replies
Solution
‎06-25-2014 05:37 AM
Occasional Contributor
Posts: 17

Re: Accessing DB2 table with search key DATE field

Posted in reply to NitinDwivedi

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 586 views
  • 0 likes
  • 1 in conversation