you know what: i had the name of my table wrong! my clever little query
works quite nicely now...
thanks
steve
----- Original Message -----
From: "Paul Van Deursen" <[EMAIL PROTECTED]>
To: "Steve Shapero" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 3:47 AM
Subject: Re: DB2 parameters
> Steve,
>
> The placeholders already have the values bound
>
> $sth->bind_param(1,$id, { TYPE => SQL_VARCHAR })
> $sth->bind_param(2,$passwd, { TYPE => SQL_VARCHAR })
>
> Just do:
> $sth->execute();
>
> Regards,
> Paul.
>
>
> Steve Shapero wrote:
>
> > howdy--
> >
> > i am using DB2 7.2.3 on RH linux 7.2. i am trying to bind some
parameters
> > to an INSERT statement and getting the following errors:
> >
> > CLI0125E Function sequence error.
> > Explanation: This function was called in an invalid sequence.
> >
> > SQLSTATE=HY010 (which has the following *3* possible meanings):
> > 1. The function was called while in a data-at-execute (SQLParamData(),
> > SQLPutData()) operation.
> >
> > 2. The function was called while within a BEGIN COMPOUND and END
COMPOUND
> > SQL operation.
> >
> > 3. An asynchronously executing function (not this one) was called for
the
> > StatementHandle and was still executing when this function was called.
> >
> > personally i find the first one to be the most likely explanation.
> >
> > here's my code ( i know the die is redundant, just trying to get all
> > possible errors):
> >
> > my $dbh = DBI->connect("dbi:DB2:$DB_NAME", "satdb", "satdb", {RaiseError
=>
> > 1, AutoCommit => 1}) || die "Unable to connect to db: $!\n";
> > my $sth = $dbh->prepare("insert into dbsat001.user_info (username,
passwd)
> > values (?, ?) ") or die "Failed to prepare statement: " . $dbh->errstr;
> >
> > for(...) {
> > my $rc = $sth->bind_param(1,$id, { TYPE => SQL_VARCHAR }) or die
> > $sth->errstr;
> > $sth->bind_param(2,$passwd, { TYPE => SQL_VARCHAR }) or die
$sth->errstr;
> > $sth->execute($id, $passwd) or die "Died here: " . $dbh->errstr;
> > }
> >
> > the program craps out on the $sth->execute, not the actual bind_param.
i've
> > tried fooling with the type to no avail. is there some magic
incantation
> > that i have to utter for DB2 to deal with this?
> >
> > thanks
> > steve
>
