SQL LOAD
Posted in 1995
Joseph Arcieri — — source: Informix-list mailing list archive (1991-1998)
I'm having some difficulty using LOAD or DBLOAD. Here's my problem.
I have a data file with 2 columns, | delimited, that I want to load/update
into the database.
My statement reads...
load from "data.file" insert into database (column#1, column#2) wherecolumnX = columnX
It's the "where columnX = columnX" that's giving me the trouble. I just
can't add the data to the end of the file, I need to update the database
with the "data.file" columns. Any help or suggestions would be
GREEATTLY appreciated!