good chemistry is complicated,
and a little bit messy -LW
two connections to the same database with DBD::Sybaseby busunsl (Vicar)
|on Dec 10, 2002 at 10:59 UTC||Need Help??|
busunsl has asked for the wisdom of the Perl Monks concerning the following question:
I have the following problem:
I want to write a simple script that compares the contents of two tables for my Sybase DBA Perl Cookbook.
The script iterates over all rows from one table, select the corresponding row from the other table and print the primary keys if the rows are different.
But if I try to execute a statement with placeholders while another statement has results pending, the Sybase Client Library pukes:
Perl: 5.8.0 Linux DBI: 1.30 DBD::Sybase: 0.95 Perl: 5.6.1 NT DBI: 1.30 DBD::Sybase: 0.91Anyone came across this before?
Is this a serious limitation in the Sybase Client Library?
The workaround would be to use a selectrow in each iteration, which would be dead slow.
Would a bind_param help?