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...
User Profile
Collapse
Profile Sidebar
Collapse
Vivek Kulkarni
Last Activity: Aug 22 '11, 06:47 PM
Joined: Jun 28 '11
Location:
-
Null Indicator in DB2 Load utility for pipe Delimited files
-
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...
No activity results to display
Show More