$ /apps/gnu/bin/perl use Sybase::DBlib; $dbh = new Sybase::DBlib (SERVER,USER,PASS); $dbh->dbcmd('select ser=@@servername'); $dbh->dbsqlexec; $dbh->dbresults; $a = $dbh->dbnextrow(1,1); $dbh->dbcmd('select dt=getdate()'); $dbh->dbsqlexec; $dbh->dbresults; $b = $dbh->dbnextrow(1,1); print " a-ser: $a->{'ser'} \n\n"; # this becomes non-existant print " a-dt: $a->{'dt'} \n\n"; # this value suddenly appears, which was not even present in the original query print " b-ser: $b->{'ser'} \n\n"; print " b-dt: $b->{'dt'} \n\n"; __END__ OUTPUT : -------- a-ser: a-dt: Mar 30 2011 8:37:50:646PM b-ser: b-dt: Mar 30 2011 8:37:50:646PM