Professional Web Applications Themes

DB2 Load from Unix CLient to NT DB2 Server - IBM DB2

Hi All, I've been trying to load from my Unix Client (7.2) to a Windows DB2 Server 7.2. Has anyone been able to achieve this? The error I get is "SQL3025N A parameter specifying a filename or path is not valid." even though the filename and paths are valid. Thanks in advance. Louise...

  1. #1

    Default DB2 Load from Unix CLient to NT DB2 Server

    Hi All,

    I've been trying to load from my Unix Client (7.2) to a Windows DB2
    Server 7.2. Has anyone been able to achieve this? The error I get is
    "SQL3025N A parameter specifying a filename or path is not valid."
    even though the filename and paths are valid.

    Thanks in advance.

    Louise
    Louise Guest

  2. #2

    Default Re: DB2 Load from Unix CLient to NT DB2 Server

    "Louise" <com> wrote in message
    news:google.com... 

    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.

    CLIENT
    Specifies that the data to be loaded resides on a remotely connected client.
    This option is ignored if the load operation is not being invoked from a
    remote client.


    Mark Guest

  3. #3

    Default Re: DB2 Load from Unix CLient to NT DB2 Server

    On 9 Oct 2003, Louise wrote:
     

    What's the exact load statement you're executing?

    I have found that when using LOAD CLIENT one needs to specify a full
    pathname to the data file -- using relative paths will not work.


    Good luck,





    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian Guest

  4. #4

    Default Re: DB2 Load from Unix CLient to NT DB2 Server

    Hmmm - wonder if it's confusion over path delmiters from Unix to NT (\
    vs. /).

    Mark A wrote:
     
    >
    >
    > 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.
    >
    > CLIENT
    > Specifies that the data to be loaded resides on a remotely connected client.
    > This option is ignored if the load operation is not being invoked from a
    > remote client.
    >
    >[/ref]

    Blair Guest

Similar Threads

  1. Flash Webcam client <-> client (not client <-> server<-> client)
    By bivald in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: April 24th, 10:33 PM
  2. Replies: 3
    Last Post: April 18th, 06:24 PM
  3. Replies: 3
    Last Post: February 13th, 06:28 AM
  4. Replies: 0
    Last Post: July 29th, 11:24 AM
  5. text based news client for unix
    By Thomas Dickey in forum Sun Solaris
    Replies: 0
    Last Post: July 10th, 12:39 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139