SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 12:11 PM
| ||||
| ||||
 dbcopy problem Dear Art: I migrate a table by your shareware dbcopy, This table 't1' has a column 'colx' datatype is varchar(8,1), It been migrated successfully , but If I run a SQL statement " select length(colx) from t1 " , It response that" 202: An illegal character has been found in the statement". I tried other ways to migrate , unload ,load or insert .. select , It is OK! Is that dbcopy's bug?      |
|
04-20-2008, 12:15 PM
| ||||
| ||||
| Re: dbcopy problem roger@star2000.com.tw wrote: > Dear Art: > I migrate a table by your shareware dbcopy, > This table 't1' has a column 'colx' datatype is varchar(8,1), > It been migrated successfully , but If I run a SQL statement > " select length(colx) from t1 " , > It response that" 202: An illegal character has been found in the > statement". > I tried other ways to migrate , unload ,load or insert .. select , It > is OK! > Is that dbcopy's bug? > Doesn't sound like it has anything to do with dbcopy. The data's already in the target table and dbaccess and/or the engine is complaining about your SELECT statement not the data contained in the table. I don't SEE anything wrong, but I'm only seeing a copy of the statement after all. For example, one of the spaces may not be a space or one of the parenthesis may in fact be a brace, I just don't know. Try creating the SQL in a text editor like emacs that will let you examine each character individually so you know it's clean before you pass it to dbaccess in a saved .sql file. Art S. Kagel |
 |
« how to configure this?
|
RE: Insider #75: Highlights: IBM Information On Demand 2006,The NextInformix IDS Release... »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 07:36 PM.
