By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

Load failure; SQL0104N

P: 1
Excuted the statement through a SSH connection:

db2 load from <filename.ixf> of ixf messages /database/stage/
acct_news_asc.txt insert into userid.acct_news_asc

And it worked fine.

Ran the same command through perl and received an error:
SQLErr: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected
token "/database/stage/acct_news_asc.txt" was found following
"MESSAGES". Expected tokens may include: "ON". SQLSTATE=42601

Error while executing import on acct_news_asc.

Any suggestions would be helpful...
Nov 14 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 297

could you post the lines of your perl script which prepare and then do the db2 command? That would help.

Anyway, my first guess is that perl is interpreting something in the db2 command string before giving it to the shell and therefore mixes it up - assuming that you are using something like

Expand|Select|Wrap|Line Numbers
  1. $output = ` db2 load from ... ` ;
In situations like these I usually do a print " whatever cmd I try to do" instead to see what's left over of my command string after perl ate it.

Regards, Bernd

P.S.: Once you find it and whatever the solution looks like, please post it here. ThanX!!
Nov 14 '07 #2

Post your reply

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