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
