Re: mSQL >> Informix

Jason Bodnar wrote: > > Does anybody have any experience with going from mSQL to Informix? > mSQL will give me a dump of SQL statements (CREATE TABLE ...., INSET > INTO TABLE ...). > > I'm using that as a shell script to feed the data into my Informix DB: > > dbaccess mydb - >>END > > CREATE TABLE ... > > INSERT ... > INSERT ... > > END > > But when I try to put all the data in, I get line overflow and bad > character errors. What characters need to be escaped for Informix? > What's the max line length of an INSERT? Is there a better way to do > this? > > -- > Jason C. Bodnar > jasonb@onr.com > Internet Programmer > Cox Interactive Media I suspect that your mSQL and Informix are running on different platforms and that the Informix platform doesn't understand the mSQL end of line character - probably your EOL is carriage return and the Informix platform needs line feed. The better way to get your data in is to use LOAD. See your Informix documentation or, if you don't have any, check Deja News for previous discussions of this. Ian