|
View previous topic :: View next topic
|
| Author |
Message |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
| And any clients/users who are supposed to create ad-hoc queries. . . |
|
| Back to top |
|
 |
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
you can not insert null like this
| Code: |
| insert tab1(col1,col2,col3) values ('A',,'C') |
| Quote: |
| ILLEGAL SYMBOL ",". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: DEFAULT ( ? CURRENT_SCHEMA ROW CURRENT_LC_CTYPE XMLELEMENT. SQLCODE=-104, SQLSTATE=42601 |
but you can as follows
| Code: |
| insert tab1(col1,col2,col3) values ('A',null,'C') |
or
| Code: |
| insert tab1(col1,col3) values ('A','C') |
|
|
| Back to top |
|
|
soumen2255
New User
Joined: 25 Jun 2008
Posts: 24
Location: Pune
|
|
|
|
| GuyC wrote: |
you can not insert null like this
| Code: |
| insert tab1(col1,col2,col3) values ('A',,'C') |
| Quote: |
| ILLEGAL SYMBOL ",". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: DEFAULT ( ? CURRENT_SCHEMA ROW CURRENT_LC_CTYPE XMLELEMENT. SQLCODE=-104, SQLSTATE=42601 |
but you can as follows
| Code: |
| insert tab1(col1,col2,col3) values ('A',null,'C') |
or
| Code: |
| insert tab1(col1,col3) values ('A','C') |
|
Thank You GUYC, I investigated and found that it is exactly what you have pointed is the issue.
Thanks everyone for this help and sorry once again for the confusion. |
|
| Back to top |
|
|
|
|
|
