Dave - could you be more specific? What is rtfm? And could you give me a
brief eg.?
Or Anybody - could you give me a hint on how to invoke stored procedure from
Perl?
Thanks.
Ed.
----- Original Message -----
From: "dave keefer" <[EMAIL PROTECTED]>
To: "Ed Ricci" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 6:31 PM
Subject: Re: How to call stored procedure?
> how about rtfm
>
>
>
> Ed Ricci wrote:
>
> > ########################################
> > use DBI;
> > use DBD::DB2::Constants;
> > use DBD::DB2;
> >
> > $dbh = DBI->connect("dbi:DB2:TEST", "admin", "admin");
> >
> > #$sql = "CALL TEST.WRITEFILESTATUS ('test','missing')";
> > $sql = "INSERT INTO TEST.FILE_TABLE (FILE, STATUS) VALUES ('Tone',
> > 'Missing')";
> >
> > $sth = $dbh->prepare($sql);
> > $sth->execute();
> > ....
> > #######################################
> >
> > It works for the 2nd $sql (a normal insert statement) but it fails for
> > the 1st $sql (call a stored procedure instead).
> >
> > The error:
> > DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/NT] SQL1109N The
> > specified DLL "TEST.WRITEFILESTATUS" could not be loaded.
> >
> > When I paste and run the 1st $sql: "CALL TEST.WRITEFILESTATUS
> > ('test','missing')" in the DB2 command centre and it works.
> >
> > Please let me know how I should invoke stored procedures within Perl.
> >
> > Many Thanks.
> >
> > Ed
> >
> >
> >
> >
> >
> >
> > _________________________________________________________________
> > Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
>
>
