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(*), :DFTDTTM, :DFTDTTM 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

Hello,

You told the code to use the content of DFTDTTM - and it did. . .

If you want some other value, you need to place the new value in DFTDTTM rather than the initial value.

The duplicates have been locked. Do not post the same question in multiple topics. . .