Re: How do I insert values from text file into informax?

From: "'豤''" <starzan@hanmail.net> > >Is there any one to help me with this problem? Yes. >I want some values from pure text file, that distinguished by a seperator >(|), >to put into informix. this is much like the dump command of mysql, I think >:) >Please show me the way in detail. edit a file called loadx.sql: load from "dumpfile.xxx" insert into mytable (col1, col2, col3,...,colN); then on the command line, say: dbaccess mydatabase loadx HTH ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

"Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > >From: "'豤''" <starzan@hanmail.net> >> >>Is there any one to help me with this problem? > >Yes. > >>I want some values from pure text file, that distinguished by a seperator >>(|), >>to put into informix. this is much like the dump command of mysql, I think >>:) >>Please show me the way in detail. > >edit a file called loadx.sql: > >load from "dumpfile.xxx" >insert into mytable (col1, col2, col3,...,colN);> >then on the command line, say: > >dbaccess mydatabase loadx > >HTH >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > Remember to set the delimiter first! I would use DBDELIMITER="|" dbaccess ....... so as not to change it for any other programs as well. In this case it should be ok to omit though as | is the standard delimiter as far as I remember, unless that for some reason has been redefined. //F.E.Theodorsen Finn E. Theodorsen///theodor@inet.uni2.dk///AtCbM///Legend#219605 TEN: Durax. Homepage: http://www.theodor.suite.dk/index.htm All advertisments sent to the above address will be treated as requests for computer support, and charged accordingly. Sending these kind of messages equals an acceptance of these terms. The minimum fee is $500.