I printed out $dbh->{Statement}, and I can see my query now. When I have the trace set to 6, these are the messages I get:

    -> prepare for DBD::Sybase::db (DBI::db=HASH(0x80a2254)~0x80a21c4 
+'declare @skiprows int, @getrows int; select @skiprows = 0; select @g
+etrows = 10000; set rowcount @skiprows; select * into #debt from debt
+ order by debt_id, debt_no asc; set rowcount @getrows;select * from d
+ebt where (debt_id NOT IN ( select * from #debt ) ) ORDER BY debt_id,
+ debt_no ASC') thr#804d1a0
    New 'DBI::st' (for DBD::Sybase::st, parent=DBI::db=HASH(0x80a21c4)
+, id=undef)
    dbih_setup_handle(DBI::st=HASH(0x80ab054)=>DBI::st=HASH(0x80a2304)
+, DBD::Sybase::st, 80ab014, Null!)
    dbih_make_com(DBI::db=HASH(0x80a21c4), 80a9804, DBD::Sybase::st, 4
+20, 0) thr#804d1a0
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), Err, DBI::db=HASH(0x80a
+21c4)) SCALAR(0x81d0754) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), State, DBI::db=HASH(0x8
+0a21c4)) SCALAR(0x81d07b4) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), Errstr, DBI::db=HASH(0x
+80a21c4)) SCALAR(0x81d0784) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), TraceLevel, DBI::db=HAS
+H(0x80a21c4)) 6 (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), FetchHashKeyName, DBI::
+db=HASH(0x80a21c4)) 'NAME_lc' (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), HandleSetErr, DBI::db=H
+ASH(0x80a21c4)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), HandleError, DBI::db=HA
+SH(0x80a21c4)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), ReadOnly, DBI::db=HASH(
+0x80a21c4)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x80a2304), Profile, DBI::db=HASH(0
+x80a21c4)) undef (not defined)
    syb_st_prepare() -> inUse = 0
    syb_st_prepare() -> set inUse
    <- prepare= ( DBI::st=HASH(0x80ab054) ) [1 items] at export_debt.p
+l line 62
    <> FETCH= ( 'declare @skiprows int, @getrows int; select @skiprows
+ = 0; select @getrows = 10000; set rowcount @skiprows; select * into 
+#debt from debt order by debt_id, debt_no asc; set rowcount @getrows;
+select * from debt where (debt_id NOT IN ( select * from #debt ) ) OR
+DER BY debt_id, debt_no ASC' ) [1 items] ('Statement' from cache) at 
+/usr/lib/perl5/site_perl/5.28.2/i686-linux-thread-multi/Data/Dumper.p
+m line 604 via  at export_debt.pl line 78

[download]

It then sits there, not doing the query. Is there something wrong with trying to do multiple statements thru dbd::Sybase? Or, is there something wrong with my query?

In reply to Re^2: DBD::Sybase prepare statement returns empty query hash but no errstr by rhysshadow
in thread DBD::Sybase prepare statement returns empty query hash but no errstr by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.