MVSFORUMS.com

[jayram99]

Hi,

The Below query executed in SPUFI, The result is

2008-06-04-13.29.59.999999
Code:

***************************************************
SELECT
COALESCE(MAX(CHAR(DT_PROCSS_END)),CURRENT TIMESTAMP - 1 DAY)
AS DTPRCEND
FROM EN19M1.PROCSS_CYCL WHERE NAME_PROCSS = 'PCWD5706' WITH UR;
****************************************************


The Same query if used in SAS Code as belowCode:

CREATE TABLE MAX_DATE AS
SELECT
DTPRCEND
FROM CONNECTION TO DEVODS3R(
SELECT
COALESCE(MAX(CHAR(DT_PROCSS_END)),CURRENT TIMESTAMP - 1 DAY)
AS DTPRCEND
FROM EN19M1.PROCSS_CYCL
FOR FETCH ONLY
);

%PUT &SQLXMSG;

DISCONNECT FROM DEVODS3R;
/QUIT;
PROC PRINT DATA=MAX_DATE;
RUN;

The Output is as Below.
Output :
Code:

04JUN2008:13:29:59.999999
***************************************************

After execting the above SAS code, need to write to Output File in DB2 Format as below.

2008-06-04-13.29.59.999999


Appreciate your Help.

Jayaram

[dbzTHEdinosauer]

are you sure that sas will only deliver that type of timestamp?
_________________
Dick Brenholtz
American living in Varel, Germany

[expat]

It is possible, as I have done this or something similar in the past.

Hopefully have my libraries uploaded on Monday to see if I have an example.
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?