473,695 Members | 3,037 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

load failure - SQL0104N Db2 version 9

Excuted the statement through a SSH connection:

db2 import from <filename.ixf of ixf messages /database/stage/
acct_news_asc.t xt insert into userid.acct_new s_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.t xt" was found following
"MESSAGES". Expected tokens may include: "ON". SQLSTATE=42601
(-104)(42601)

Error while executing import on acct_news_asc.

Any suggestions would be helpful...

Nov 12 '07 #1
4 4386
Ian
Justin wrote:
Excuted the statement through a SSH connection:

db2 import from <filename.ixf of ixf messages /database/stage/
acct_news_asc.t xt insert into userid.acct_new s_asc

And it worked fine.

Ran the same command through perl and received an error:
How exactly did you run the command? Via DBD::DB2? By using the
system() function? What was the exact statement you tried to execute?

It would be helpful to see an excerpt of the code that is doing this.
Nov 13 '07 #2

Ian,

Thanks for responding so quickly.

Yes, the command is run through DBD::DB2 (perl).

We use the sysproc.admin_c md. A similar piece code works great for
the export.

Here is the perl code:

# setup import command
my $importcmd = "Load FROM " . $filename . " OF IXF MESSAGES " .
$messagefile . " INSERT INTO USERID." . $table ;

# Prepare import command
my $sths = $dbh->prepare("cal l sysproc.admin_c md(?)")
or return ($self->do_return($q , 0, $dbh->errstr, $dbh->err, $dbh-
>state,
"Error while preparing import on $table.", $dbh));

# Bind input parameters
$sths->bind_param( 1, $importcmd);

# Call the stored procedure
$sths->execute()
or return ($self->do_return($q , 0, $dbh->errstr, $dbh->err, $dbh-
>state,
"Error while executing import on $table.", $dbh));

$sths->finish();

On Nov 12, 11:15 pm, Ian <ianb...@mobile audio.comwrote:
>
How exactly did you run the command? Via DBD::DB2? By using the
system() function? What was the exact statement you tried to execute?

It would be helpful to see an excerpt of the code that is doing this.

Nov 13 '07 #3

Interesting enough... If I take out messages (and associate msg text
file) it works fine through perl

Not sure if that is helpful...
Nov 14 '07 #4

Message on server was the part that I was missing.

Thanks.

For those who run into similar - here is a little info:

my $importcmd = "LOAD FROM " . $filename . " OF IXF MESSAGES on
server INSERT INTO USERID." . $table ;
print "importcmd = $importcmd\n";

# Prepare import command
my $sths = $dbh->prepare("cal l sysproc.admin_c md(?)") #
sysproc.db2load
or return ($self->do_return($q , 0, $dbh->errstr, $dbh->err, $dbh-
>state,
"Error while preparing import on $table.", $dbh));

# Bind input parameters
$sths->bind_param( 1, $importcmd);

# Call the stored procedure
$sths->execute()
or return ($self->do_return($q , 0, $dbh->errstr, $dbh->err, $dbh-
>state,
"Error while executing import on $table.", $dbh));
# bind column 1 to variable
$sths->bind_col(1, \$outCol1);

# bind column 2 to variable
$sths->bind_col(2, \$outCol2);

# bind column 3 to variable
$sths->bind_col(3, \$outCol3);

# bind column 4 to variable
$sths->bind_col(4, \$outCol4);

# bind column 5 to variable
$sths->bind_col(5, \$outCol5);

# bind column 6 to variable
$sths->bind_col(6, \$outCol6);

# bind column 9 to variable
$sths->bind_col(9, \$msg_retrieval );

# bind column 10 to variable
$sths->bind_col(10, \$msg_removal);
Nov 16 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3563
by: ddelaney | last post by:
I've seen this posted before in many places, but have yet to find a real fix. I have a web application on dev server right now, and randomly, hours or days, it returns the expception posted below. If I copy the incHeader.ascx.vb over to the server again, it appears to recompile and works fine, again, for random period of times. Even precompiling is no help. Is there a fix or workaround so this can some stability? Any help at all is...
4
3979
by: Richard Bysouth | last post by:
Hi I am running a site built on asp.net 1.1 on a windows server 2003 (which is running asp.net 2.0 - shared hosting at my webhost). The site is low traffic and very simple (mostly static text apart from a couple of usercontrols that pull info from a sql db). The problem I'm getting is that it will run fine for a few days, then suddenly the following error will occur: --------------------------------------------------
1
18303
by: naimishranderi | last post by:
Hello friends I am using ASP.NET 2.0 and SQL Server 2000 for DB synchronization(replication) project. When I am running this web application on local machine it running fine, but when I deploy it using FTP s/w to hosting server I got error following. Click here to see web page www.aus-business.com/naimish/replication Parser Error Message: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0,...
1
2535
by: kfwolf | last post by:
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:
1
7265
by: Justin | last post by:
We had a load that failed. Now we have a pending load. When executing load terminate, we receive the following error: db2 load terminate SQL0104N An unexpected token "terminate" was found following "LOAD". Expected tokens may include: "QUERY". SQLSTATE=42601 db2 query load terminate DB21034E The command was processed as an SQL statement because it was
2
17691
by: rajendiran | last post by:
project is working fine in localhost. when i upload server i got the error Server Error in '/' Application. -------------------------------------------------------------------------------- Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not...
3
10773
by: pratikkagda | last post by:
Hi all, My system contains Framework 3.5 with visual studio 2008 as well as 2005; here I have developed an application with crystal report with framework 2.0. It is working great in my system but when I upload this project into our production server (Production server only contains Framework 2.0 and IIS) and deployed the site to the production server with necessary assemblies, but itís getting error as bellow. In my system I could not find...
0
3952
by: Andy | last post by:
Thanks Peter, I thought I'd give an update on this problem. My application had 2 assemblies that contained classed for the Data access and business logic layer. It was on one of them that I was getting the Access denied error. After checking different settings and googling I wasnt able to pinpoint the problem and as a temporary fix I decided to merge the two assemblies into one, my logic being no offending assembly no access denied...
1
8328
by: Steve Wofford | last post by:
I am recieving the following. This happens when I moved it from my development system to our production SBS 2003 w/ latest .net frameworks and service packs . I developed under XPSP2 and VS2008. The error is pointing to the Web.Config of my application. System.Data.Entity was missing from the server, but was on the dev system. I tried to add, but didnt help: C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5
0
8555
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9112
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8817
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5831
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4336
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4571
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2994
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2258
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1970
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.