Example of SQL code to set a working storage field to CURRENT TIMESTAMP

Document ID : KB000055085
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Below is an example of how to code SQL statements to set a working storage field to CURRENT TIMESTAMP in a CA Easytrieve program.

Solution:

PARM SSID(DB00) SQLID('MFL') SQLSYNTAX FULL

DEFINE WS-TIMESTAMP W 0026 A

JOB INPUT NULL

SQL SET :WS-TIMESTAMP = CURRENT TIMESTAMP

DISPLAY 'WS-TIMESTAMP = ' WS-TIMESTAMP

STOP