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

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

book

Article ID: 55085

calendar_today

Updated On:

Products

PanAudit Plus Easytrieve Report Generator PAN/SQL Endevor Endevor Natural Integration Endevor - ECLIPSE Plugin Endevor - Enterprise Workbench

Issue/Introduction

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

Environment

Release: PSQLOR00200-2.4-Pan/SQL-for Oracle
Component: