load from.. insert into
Posted in 2000
Topics: General Discussion
Andreas Lommel — — source: Informix-list mailing list archive (1991-1998)
Hi there ! Iwant to load ASCII-data into a table. The problem: The Ascii-File has many rows. Can I separate the loading ?
↪ replying to Andreas Lommel
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Andreas Lommel wrote:
>
> Hi there ! Iwant to load ASCII-data into a table. The problem: The
> Ascii-File has many rows. Can I separate the loading ?
Sure, break up the file into several and run multiple dbaccess>load
sessions or use dbload or Jonathan Leffler's sqlreload from his sqlcmd
package.
Art S. Kagel