Not surprising that SAS functions won't work on DB2. When you execute a
pass-through query, the query is executing completely outside of SAS.
Two alternatives, the first preferable, the second possibly inconveivable if
either of the two joined tables are of any size.
1) Does DB2 have a function that'll replicate what you're doing with INTNX?
2) Create a SAS/Access DB2 libname and execute the query in SAS.
See OnlineDocs for the "SAS/ACCESS LIBNAME Statement: DB2 Specifics"
libname mylib db2 ssid=db2 authid=testuser server=testserver;
select a.*, b.*
from mylib.table1 a,
HOWEVER!!! SAS will pull every row from both tables through the pipe and
weed out the non-conformists on the machine running SAS.
From: Chandu [mailto:mailrajuv@YAHOO.COM]
Sent: January 22, 2004 3:25 PM
Subject: DB2 date and SAS date
I am comparing two dates from different tables both are in DB2.But I
am using sas function on one date.
but this is not working.I am doing this in pass through sql in db2.Can
anyone suggest me a way to do this.
Thanks in advance