Question & Answer
Question
Db2 function CURRENT TIMESTAMP does not work when using Db2 Virtual tables
Answer
Question/Problem Description
Db2 function CURRENT TIMESTAMP gives errors when inserting rows in a Db2 Virtual table for TIMESTAMP type column
Clarifying Information
The standard Db2 function CURRENT TIMESTAMP gives an error "Invalid column reference CURRENT in SQL" when inserting a row in a Db2 Virtual table for TIMESTAMP type column
Error Message
Invalid column reference CURRENT in SQL
Resolution
CURRENT_TIMESTAMP should be used instead of the CURRENT TIMESTAMP
e.g.
INSERT INTO DB2 Virtual Table (KEY, TIMESTAMP_TEST) VALUES (6, CURRENT_TIMESTAMP);
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"Component":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
07 June 2020
UID
ibm16220867