JR54612: UNABLE TO SPECIFY DEFAULT VALUE FOR TIMESTAMP COLUMNS FOR TERADATA

APAR status

• Closed as program error.

Error description

• Unable to assign a default value to a Timestamp column with the
  TIMESTAMP keyword.
  The value set is enclosed with single quotes in the  generated
  DDL and the generated DDL is invalid.
  
  Observed for Teradata Physical Data Models.
  
  
  
  Use case:
  
  The generated DDL:
  
  
  
  CREATE SET TABLE PDM.test_dflt_ts (
  
  RECORD_DELETED_FLAG BYTEINT TITLE 'Record Deleted Flag' NOT NULL
  DEFAULT 0 COMPRESS (0,1),
  
  START_TS TIMESTAMP WITH TIME ZONE TITLE 'Start Timestamp' NOT
  NULL   DEFAULT CURRENT_TIMESTAMP,
  
  END_TS TIMESTAMP WITH TIME ZONE TITLE 'End Timestamp' NOT NULL
  DEFAULT  'TIMESTAMP ''9999-12-31 23:59:59+10:00''',
  
  BANK_ID VARCHAR(20) TITLE 'Bank Id' NOT NULL,
  
  BRANCH_ID VARCHAR(20) TITLE 'Branch Id' NOT NULL
  
  )
  
  PRIMARY INDEX (BRANCH_ID);
  
  
  
  Teradata Error:
  
  Executed as Single statement.    Failed [3630 : 22018] Default
  value
  incompatible with type of column END_TS.
  
  Elapsed time = 00:00:00.032
  
  
  
  STATEMENT 1: Create Table failed.
  

Local fix

Problem summary

• Unable to specify default value for timestamp columns for
  teradata physical data model.
  

Problem conclusion

• This problem was fixed in InfoSphere Data Architect v9.1.3 APAR
  1.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFO DATA ARCHI

• Fixed component ID

  5724V1500

Applicable component levels

• R913 PSN

     UP