Hi

I'd like to LOAD data into a local Database but the IXF-files I use are on a fileserver. (on drive G)

I use that command: LOAD FROM g:\filename.ixf OF IXF MESSAGES C:\temp\load.msg REPLACE INTO tablename

Then I receive the following error: SQL2036N The path for the file or device "g:\filename.ixf" is not valid
(the path is valid for shure!)

If I use IMPORT instead of LOAD, all work fine!
DB2 version is 7.1.1

How can I use LOAD in this case?

Thanks for your help
Reto

Check out the CLIENT option on the load command. It specifies that the data to be loaded resides on a remotely connected client. Command Reference manual.

I tried that before, there isn't a difference in this case. I want to load data to a local database, only the ixf files are remote!

I use the client option, when I have to load data to a remote database. But the files are then local, where I submit the load command.

Reto

Sorry about that.

From the Command Reference for Load command:

FROM filename/pipename/device/cursorname
Specifies the file, pipe, device, or cursor referring to an SQL statement
that contains the data being loaded. If the input source is a file, pipe,
or device, it must reside on the database partition where the database
resides, unless the CLIENT option is specified.