dbload syntax for delimited files
Stephen Roach wrote:
>
> Can anybody let me know what the syntax is for the dbload txt file for
> delimited field data files. I am OK on fixed length but I'm having
> trouble getting hold of the documentation. (tried a download from the
> Informix site - twice - but it arrived corrupted).
load_my_table.cmd:
FILE mytable.unl DELIMITER '|' 6; -- Number of fields in each file row
insert into mytable; -- Any valid insert
load_complex.cmd:
file first_part.unl delimiter '|' 4; -- First input file, some fields
insert into combined_table
values ( f01, f02, f04 ); -- some fields from file
Art S. Kagel
Can anybody let me know what the syntax is for the dbload txt file for
delimited field data files. I am OK on fixed length but I'm having
trouble getting hold of the documentation. (tried a download from the
Informix site - twice - but it arrived corrupted).
TIA
Steve
---------------------------------------------------------
Steve Roach: Remove NOSPAM from address to reply:
roach@NOSPAMportalinc.com
steve_roach@NOSPAMhotmail.com
dbload -d <database> -c <command file> -l <log file> -e <#errors> -n <block>
command file would contain:
FILE <data file> DELIMITER '|' <# of fields>;
INSERT INTO <table name>;
The '|' is specified here as the delimiter,
but you can chose any delimiter, '|' is most popular.
Frank Testa
In article <36b9936e.63413030@204.247.247.47>,
roach@NOSPAMportalinc.com wrote:
>
> Can anybody let me know what the syntax is for the dbload txt file for
> delimited field data files. I am OK on fixed length but I'm having
> trouble getting hold of the documentation. (tried a download from the
> Informix site - twice - but it arrived corrupted).
>
> TIA
>
> Steve
>
> ---------------------------------------------------------
> Steve Roach: Remove NOSPAM from address to reply:
> roach@NOSPAMportalinc.com
> steve_roach@NOSPAMhotmail.com
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
On Wed, 03 Feb 1999 18:42:25 -0500, "Art S. Kagel"
<kagel@bloomberg.net> wrote:
> Stephen Roach wrote:
> >
> > Can anybody let me know what the syntax is for the dbload txt file for
> > delimited field data files. I am OK on fixed length but I'm having
> > trouble getting hold of the documentation. (tried a download from the
> > Informix site - twice - but it arrived corrupted).
>
> load_my_table.cmd:
> FILE mytable.unl DELIMITER '|' 6; -- Number of fields in each file row
> insert into mytable; -- Any valid insert>
> load_complex.cmd:
> file first_part.unl delimiter '|' 4; -- First input file, some fields
>
> insert into combined_table
> values ( f01, f02, f04 ); -- some fields from file>
> Art S. Kagel
Thank you very much for this. I grumbled about the lost documentation
around the office yesterday and a rather sheepish team member
extracted it from the bottom of a drawer below, for all I know, a pile
of dirty mags.
Anyway, problem solved. Thanks.
---------------------------------------------------------
Steve Roach: Remove NOSPAM from address to reply:
roach@NOSPAMportalinc.com
steve_roach@NOSPAMhotmail.com