467,887 Members | 1,550 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,887 developers. It's quick & easy.

load/import in db2


I am trying to load the data from flat file to temp table in different ways.

import from 'c:\OCT SC REPORT TAKE 2.csv' into session.kfs_file;
load from 'c:\OCT SC REPORT TAKE 2.csv' of ASC insert into session.kfs_file;

But i am getting the error like this.
SQL1325N The remote database environment does not support the command or one of the command options.

can anybody help me on this...

Thanks in advance
Aug 20 '07 #1
  • viewed: 3153
1 Reply
If you are running the LOAD utility from a client machine then you need to specify the keyword CLIENT.
You can build your LOAD command around the following example:

Load CLIENT From /home/Data/datafile.dat of del Modified by COLDEL, UseDefaults Messages /home/log/datafile.err insert into koes.orders NONRECOVERABLE;

del - delimited
COLDEL specifies the column delimiter, the (,) comma following it is the delimiter. You can also specify hex values for delimiters.
insert - to append data. to replace use option 'replace'

Refer DB2 documentation (Data Movement Utilities) for more details on the LOAD command and its options.

Aug 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by kk | last post: by
6 posts views Thread by davvid | last post: by
13 posts views Thread by usenet | last post: by
4 posts views Thread by db2admin | last post: by
2 posts views Thread by Shivakumar | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.