db2 create/load via IXF generates error SQL0104N & SQLSTATE=42601

The following example:

db2 -v load from tab14.ixf of ixf modified by noheader create into STATHIST_TABLES


Generates the following message:

load from tab14.ixf of ixf modified by noheader create into STATHIST_TABLES
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following
"<identifier>".  Expected tokens may include:  "REMOTE".  SQLSTATE=42601

can anyone tell me why?
I do know the files were generated on a UNIX box and I am now loading into w2k machine.
need answer ASAP thus the 500 points
LVL 1
strongs120Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ghp7000Connect With a Mentor Commented:
create into wont work, you can use insert or replace
0
 
bondtraderConnect With a Mentor Commented:
hmmm, why won't create into work, ghp7000?  I think I do this all of the time!

strongs120:  put your load statement into a file, put a semi-colon at the end of the statement and invoke it from a db2 command window like this:  db2 -tvf yourfilename...you'll need to be connected to the database before you run it though...

Hope this helps

0
 
ghp7000Commented:
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
bondtraderCommented:
ahhh, I didn't see any reference to using 7.2 >> v8...I must not be awake today  ;-)
0
 
strongs120Author Commented:
There wasn't any reference to any version... sorry about that.
It is version 8.1.6 UDB / windows.
I will try bondtrader's suggestion and follow-up.
0
 
ratna1251Commented:
what file i want to send them
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.