Re^3: DBD::Sybase prepare statement returns empty query hash but no errstr

DBI is pretty firmly in the "prepare one statement at a time" camp. I am not familiar with DBD::Sybase; are you sure that that entire statement group is not being parsed as "declare @skiprows int, @getrows int; <unparsed leftovers>" which does nothing and returns nothing?

Comment on Re^3: DBD::Sybase prepare statement returns empty query hash but no errstr Download Code

Replies are listed 'Best First'.
Re^4: DBD::Sybase prepare statement returns empty query hash but no errstr by soonix (Chancellor) on Oct 31, 2019 at 07:19 UTC
At least the doc claims "DBD::Sybase has the ability to handle multi-statement SQL commands in a single batch." OTOH, "ability" alone doesn't say it will work under all circumstances...	[reply]
Re^5: DBD::Sybase prepare statement returns empty query hash but no errstr by jcb (Parson) on Nov 01, 2019 at 03:44 UTC
DBD::SQLite also has that ability, but will only do so if you ask for it. Could there be a flag you must set on the database or statement handle to enable the feature?	[reply]