User Profile

Collapse

Profile Sidebar

Collapse
Vivek Kulkarni
Vivek Kulkarni
Last Activity: Aug 22 '11, 06:47 PM
Joined: Jun 28 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Null Indicator in DB2 Load utility for pipe Delimited files

    Hi ,

    I have got a pipe delimited file which I am loading into the DB using the DB2 Load utility.
    Now some of the rows in the pipe delimited file don't have the data for the respective columns , and therefore they get rejected by the Load utility.

    I am aware of the Null indicator , but that is available only for ASCII files
    Can anybody please guide me the Null Indicator equivalent to be used incase of delimited...
    See more | Go to post
    Last edited by Vivek Kulkarni; Aug 22 '11, 06:31 PM. Reason: edited

  • SQL3126N : Remote client requires absolute file path or directories

    Hi,

    I am using the DB2 Load utility to load a particular table with records from a delimited file.
    When i execute the load command it throws the following error
    <b>SQL3126N Remote client requires absolute path for files and directories.</b>

    Now I understand that since the file is present on the local machine and the database is a remote one , this error is being thrown.
    But can anybody...
    See more | Go to post
No activity results to display
Show More
Working...