On Fri, 26 Apr 2002 21:24:36 +0000 Ed Ricci <[EMAIL PROTECTED]> 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.
You'll have a better chance of getting an answer if you post to the right
list.
This belongs in [EMAIL PROTECTED]; I've sent my reply there.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
