Results 1 to 2 of 2

Thread: is 'comment' a valide column name in DB2 v7.2 ?

  1. #1
    Join Date
    Jun 2005
    Posts
    28

    is 'comment' a valide column name in DB2 v7.2 ?

    Hi,

    is 'comment' a valide column name in DB2 v7.2 ?

    CREATE TABLE AUDIT_ADJUSTMENTCO(
    EMPLOYEE_ID CHAR(9) NOT NULL,
    AUDIT_TS TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP,
    AUDIT_TYPE CHAR(1) NOT NULL,
    LOCATION CHAR(3) NOT NULL,
    DEPARTMENT CHAR(5) NOT NULL,
    PERIOD_ENDING DATE NOT NULL,
    COMMENT VARCHAR(2000),
    ADDED_BY CHAR(9) NOT NULL,
    ADDED_TS TIMESTAMP NOT NULL,
    MODIFIED_BY CHAR(9) NOT NULL,
    MODIFIED_TS TIMESTAMP NOT NULL,
    CONSTRAINT PK_TSADJUSTMENTCOM PRIMARY KEY (EMPLOYEE_ID, AUDIT_TS, AUDIT_TYPE, LOCATION, DEPARTMENT, PERIOD_ENDING)
    )IN TIMESHEETS
    ;

  2. #2
    Join Date
    Nov 2005
    Posts
    2
    should not be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •