• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2065
  • Last Modified:

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
0
strongs120
Asked:
strongs120
2 Solutions
 
ghp7000Commented:
create into wont work, you can use insert or replace
0
 
bondtraderCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now