RE: FW: Informix SE
RTAWFM @ http://www.informix.com/answers/ :-)
You specifically want the Migration Guide, page 11-28.
1. You can't use onload. (Maybe you meant onpload?)
2. You can use HPL (onpload), but since this is e-mail and HPL must be
configured under X-windows...
3. Setting up dbload command files is very specific. The manuals will
give you pointers.
>can you please kindly give me a sample code how to use dbload/onload
to
>upload below files to a particular table in the database.
>thank you very much in advance.
>
>-----Original Message-----
>From: Obnoxio The Clown [mailto:obnoxio@hotmail.com]
>Sent: Tuesday, March 23, 1999 6:29 PM
>To: HwaYingLee@pg.SLR.com; informix-list@iiug.org
>Subject: Re: FW: Informix SE
>
>
>>can some one please teach me how to upload a text file
>> 1)with tab delimeter
>> 2)with fixed field length?
>
>The DBLOAD command can do both of these, as can the HPL (if it's
>supported on your platform)
HTH.
Get Your Private, Free Email at http://www.hotmail.com
> >can you please kindly give me a sample code how to use dbload/onload
> to
> >upload below files to a particular table in the database.
> >thank you very much in advance.
Don't forget the simple approach -- if your data isn't huge, there's
always 'LOAD FROM file INSERT INTO table'. This, combined with a little
creative cut/paste/sed/split work, can load most any data, and it can be
faster than trying to learn new tools if this is a one-time deal.
-Richard