Adding, Replacing, and Dropping Data on SQL Tables › Updating SQL Columns of Type DATE

Updating SQL Columns of Type DATE

SQL Tables that contain columns of type DATE may be updated using the ADD or REPLACE functions. Data to be loaded into a DATE column should be stored in a 10 byte alphanumeric variable or literal. The format of the date value should be 'YYYY-MM-DD'. CA IDMS/DB is responsible for converting this date value into its own internal DATE format.

Existing Table Definition

CREATE TABLE STOCKS
((COMPANY_NAME    CHAR(20)  NOT NULL,
  COMPANY_ID      CHAR(5),
  TRADING_DATE    DATE,
  VOLUME          INTEGER,
  CLOSE_PRICE     DECIMAL(9,3));

Report Syntax

 col. 2
 ▼
 IN 80
 REC COMPANY_NAME  1 20
 REC COMPANY_ID   21  5
 REC VOLUME       26  8  2
 REC CLOSE_PRICE  34  9  2  DP=3
 010 TRADING_DATE 'yyyy-mm-dd'
 01OUT   SQLTABLE=STOCKS     TYPE=ADD
*        DICTIONARY=TSTDICT  SCHEMA=INV
 010  ZERO  0
 0151*010 COMPANY_NAME
 0151*020 COMPANY_ID
 0151*021 ZERO         FB   SZ=4
 0151*030 TRADING_DATE
 0151*031 ZERO         FB   SZ=4
 0151*040 VOLUME       FB   SZ=4
 0151*041 ZERO         FB   SZ=4
 0151*050 CLOSE_PRICE  FP   SZ=5  DP=3
 0151*051 ZERO         FB   SZ=4