var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: LOAD data with remote files into al local DB
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
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.
Sorry about that.
From the Command Reference for Load command:
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.