|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
October 28th, 2005, 11:05 AM
|
|||
|
|||
|
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
October 29th, 2005, 06:33 PM
|
||||
|
||||
|
Comment is a keywork like timestamp, date, select, etc so I'd think it isn't a valid column name.
|
|
#3
November 14th, 2005, 09:18 PM
|
|||
|
|||
|
I think a comment is not a normally selectable column, but goes along with all the meta data collected in the DB2 catalog. Were you querying catalog data for the table, you could get to.
fv
__________________
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > is 'comment' a valide column name in DB2 v7.2 ? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
