Hello to all,

I would like to join two mainframe DB2 tables and use a Where statement to select rows based on a timestamp (HYYMDm) value.

For example:
Join fielda in tablea to fieldb in tableb WHERE TIMESTAMP GT XXXXX;

XXXXX is the selection value I will provide in my focexec.

My question is: What Data Format Do I Use For XXXXX And How Do I Convert A Alpha Value To That Format?

Thanks to All!
Ken

Z/OS FOCUS 7.2.5

This message has been edited. Last edited by: Kerry,

Ken-
Research the followwing construct
WHERE TIMESTAMP GT DT ( date/time variable)

Note the DT

Thank you. We will use DT().
Problem resolved.