IBM Mainframe Forum

H 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