I'm in the Oracle and SQL Server world. In those worlds, we use
SQL*Loader or DTS, respectively, to load large amounts of data from a
flat file to the database. I'm assuming that DB2 has something similar.
Can someone point me in the right direction? What tool do you use in
DB2?

Thanks,
Brian


--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

How about the DB2 Load Utility?

Larry Edelstein

Brian Peasland wrote:[color=blue]
> I'm in the Oracle and SQL Server world. In those worlds, we use
> SQL*Loader or DTS, respectively, to load large amounts of data from a
> flat file to the database. I'm assuming that DB2 has something similar.
> Can someone point me in the right direction? What tool do you use in
> DB2?
>
> Thanks,
> Brian
>
>[/color]

How about the DB2 Load Utility?

Larry Edelstein

Brian Peasland wrote:[color=blue]
> I'm in the Oracle and SQL Server world. In those worlds, we use
> SQL*Loader or DTS, respectively, to load large amounts of data from a
> flat file to the database. I'm assuming that DB2 has something similar.
> Can someone point me in the right direction? What tool do you use in
> DB2?
>
> Thanks,
> Brian
>
>[/color]

The name of the command is LOAD. It's documented in the Command
Reference manual.

Brian Peasland wrote:[color=blue]
> I'm in the Oracle and SQL Server world. In those worlds, we use
> SQL*Loader or DTS, respectively, to load large amounts of data from a
> flat file to the database. I'm assuming that DB2 has something similar.
> Can someone point me in the right direction? What tool do you use in
> DB2?
>
> Thanks,
> Brian
>
>[/color]

"Blair Adamache" <badamache@2muchspam.yahoo.com> wrote in message
news:c7to9i$qb8$1@hanover.torolab.ibm.com...[color=blue]
> The name of the command is LOAD. It's documented in the Command
> Reference manual.
>[/color]
Manual? You expect someone to read the manual?