Re: Change DELIMITER in dbload command file
www.iiug.org
Paul
>>> Bernhard Gramberg <mail@gramberg.de> 11/01/99 12:10AM >>>
where do I find the IUUG-Archiv ?
Jonathan Leffler schrieb:
> It appears that DB-Load won't allow you to use a control character.
> I've not tested it formally in the last 3 weeks or so, but I'm pretty sure
> that SQLCMD from the IIUG archives allows you to use control characters
> OK.
> Since your load command is equivalent to:
> LOAD FROM "aaa.unl" DELIMITER "^A" INSERT INTO aaa;> you should be able to use SQLCMD instead. If you had a fixed format file,
>
> then you'd need to work a good deal harder. There's a program DBLDFMT
> which does do fixed to delimited conversions, including adding explicit
> decimal points where the data has only implicit decimal points. I'm not
> sure if its in the
> IIUG archive -- if it isn't, I'll send it...
>
> jingker cheng wrote:
>
> > We use "^A" as our DBDELIMITER. Now I want to use 'dbload' command to
> > load my file in order to avoid the long transaction problem. I use the
> > following command file :
> >
> > FILE aaa.unl DELIMITER "^A" 57 ;
> > INSERT INTO aaa ;> > !
> >
> > But I always get the "Illegal Character" error message. For some
> > reasons, I cannot change the DBDELIMITER. How can I use
> > "^A" as the delimiter instead of the "|".
> >
> > Thanks
> >
> > Jung-Hui Cheng
> > cheng@dbtel.com.tw
>
> --
> Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
> Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN
> #include <disclaimer.h>
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************