Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Question Unanswered: LOAD data with remote files into al local DB

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.

  3. #3
    Join Date
    Sep 2003
    Posts
    8
    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

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •