Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    11

    Question Unanswered: Using the LOAD Utility

    Hi,
    I cannot load data from a remote client to the DB2. This is the command I used.

    LOAD CLIENT FROM 'C:\xxx\PA Batch Project\Sample application\data\sampledata1.dat' OF DAT INSERT INTO table1

    In the above dat file the columns are delimited by using blankspace.
    The process is not showing an end.

    Please give me details regarding LOAD UTILITY for loading from a flat file.

    I am very new to DB2
    Please help me
    Last edited by nivin; 09-05-07 at 02:24.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    the format can be
    OF filetype
    Specifies the format of the data:
    * ASC (non-delimited ASCII format)
    * DEL (delimited ASCII format)
    * IXF (integrated exchange format, PC version), exported from the same or from another DB2 table
    * CURSOR (a cursor declared against a SELECT or VALUES statement).
    if space if separator that can lead to problems if character fields contain a space in the field
    method l could be a solution
    check info center for detailed options on load command
    http://publib.boulder.ibm.com/infoce.../v8//index.jsp
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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