|
View previous topic :: View next topic
|
| Author |
Message |
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
Hi all,
I tried to alter a null column of a table into a not null column in the local server using an alter statement. The table is empty. But the query I executed is not giving the actual result.
The query I tried
| Code: |
| ALTER TABLE DEPT1 ALTER COLUMN DEPTNO SET NOT NULL WITH DEFAULT; |
the result i got is
| Code: |
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "NOT". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: CYCLE, NOCYCLE, ORDER, NOCACHE, NOORDER, NOMINVALUE,
NOMAXVALUE |
The version I used is DB2 v8.1
Can any one help me..
Thanks in advance
Raghunathan |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| I think your DB2 is out of service. Anyway, the manuals are still there. What did you try to resolve this? There's a big clue in the message about what is the SQL processor thinks is wrong with that line, but you need some research. |
|
| Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
Thanks Bill for your comments
Regards
Raghunathan |
|
| Back to top |
|
|
|
|
