sybperl-l Archive

From: Matthew dot Persico at Lazard dot com
Subject: AutoCommit effects query?
Date: Apr 5 2002 9:07PM

I am trying to get replication information out of our rep server. It doesn't
work if AutoCommit is off. Any clues why? See the transcript below

## Previously connected to sybase rep server. Omitted for security...

## Auto commit is off
  DB<46> x $ldbh->{AutoCommit}
0  1

## Run the query
  DB<47> $xxx = $ldbh->selectall_arrayref('admin who,sqm');

## I got results. Snipped in the interests of bandwidth
  DB<48> x $xxx
0  ARRAY(0x47f2e0)
   0  ARRAY(0x526dd0)
      0  '   8'
      1  'Awaiting Message    '
      2  '101:0 REPPROD.REPP_RSSD                 '
      3  0
      4  0
      5  0
      6  0
      7  0
      8  0
      9  0
      10  0
      11  '0:0'
      12  0.1
      13  0.0
      14  '0.1.0'
      15  1
      16  1
   1  ARRAY(0x526f08)
      0  '   9'
      1  'Awaiting Message    '
      2  '101:1 REPPROD.REPP_RSSD                 '
      3  811
      4  1590374
      5  1590559
      6  517497029
      7  254555
      8  4118
      9  254572
      10  253935
      11  '0:131456'
      12  131456.44
      13  131456.44
      14  '131456.45.0'
      15  1
      16  1

## Reset
  DB<49> $xxx = 0

## and show it's been blanked
  DB<50> x $xxx
0  0

## $ldbh->{AutoCommit} = 0;
  DB<51> n

## Prove it
  DB<51> x $ldbh->{AutoCommit}
0  0

## Now watch
  DB<52> $xxx = $ldbh->selectall_arrayref('admin who,sqm');
no statement executing at /sa/perl/lib/site_perl/5.6.1/sun4-solaris/DBI.pm line
1400.

Huh? What does autocommit have to do with running 'admin who,sqm'

Thanks.


--
Matthew Persico
Vice President
Lazard
30 Rockefeller Plaza
New York, NY 10020, USA
Phone Number: 212 632 8255
Fax Number: 212 332 5904
Email: matthew.persico@lazard.com