Time stamp Error
Posted: Thu Sep 30, 2010 10:48 amH ALWNULL(*USRCTL)
H CVTOPT(*VARCHAR)
H DATEDIT(*YMD)
H FIXNBR(*ZONED : *INPUTPACKED)
H OPTION(*NODEBUGIO)
H SRTSEQ(*LANGIDSHR)
D********************************************************************
D* Work Fields
D* -----------
D DFTDTTM S Z INZ(Z'0001-01-01-00.00.00.000000')
D********************************************************************
C DFTDTTM DSPLY
C/EXEC SQL
C+ INSERT INTO MULTITMP1 (ORG,LOGO,TOTAL,STARTTIME,ENDTIME)
C+ SELECT ORG,LOGO,count(*),
FTDTTM, FTDTTM FROM ATRF
C+ GROUP BY ORG,LOGO
C+ ORDER BY ORG,LOGO
C+ WITH NC
C/END-EXEC
C Seton LR
In this code wat value STARTTIME,ENDTIME will give coa m getting only intialize value while i should get system date/timestamp value.
Kindly let me know wat vto do for this..
H CVTOPT(*VARCHAR)
H DATEDIT(*YMD)
H FIXNBR(*ZONED : *INPUTPACKED)
H OPTION(*NODEBUGIO)
H SRTSEQ(*LANGIDSHR)
D********************************************************************
D* Work Fields
D* -----------
D DFTDTTM S Z INZ(Z'0001-01-01-00.00.00.000000')
D********************************************************************
C DFTDTTM DSPLY
C/EXEC SQL
C+ INSERT INTO MULTITMP1 (ORG,LOGO,TOTAL,STARTTIME,ENDTIME)
C+ SELECT ORG,LOGO,count(*),
FTDTTM, FTDTTM FROM ATRF C+ GROUP BY ORG,LOGO
C+ ORDER BY ORG,LOGO
C+ WITH NC
C/END-EXEC
C Seton LR
In this code wat value STARTTIME,ENDTIME will give coa m getting only intialize value while i should get system date/timestamp value.
Kindly let me know wat vto do for this..