Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SharadMishra88
SharadMishra88
1 Post
ACCEPTED ANSWER

Pinned topic CobolQuery

‏2012-02-20T18:38:07Z |
Hi All,

can any one sugest me how we covert minutes in to timestamp in cobol.

THE ACTUAL SENARIO IS GIVEN BELOW I HAVE RUN THIS QUERY IF WRITE LIKE THIS AS GIVEN BELOW THIS GIVES ME AN ERROR BUT IF WE WRITE 30 INSTEAD OF WS-VAR THEN THIS IS WORKING FINE BUT I DO NOT WANT HARD CODE HERE CAN ANY ONE SUGGEST ME THE RIGHT CODE.

EXEC SQL
SELECT POLNBR
FROM TABLE
WHERE TAB1 = VAL
AND TIMESTAMP > CURRENTTIMESTAMP - (:WS-VAR MINUTE)

END-EXEC.
please mail me on sm.net88@gmail.com'

Thanks in advance