Re^6: Writing Multiple Recordsets into a CSV file

Searching our home grown Module Documentation this is what I get:
DBI FUNCTIONS

dbidata

Returns connection data for initializing a DBI connection.

opendbi

Returns a DBI object. Se the DBI documentation for what to to with it.

Usage: my $dbi = KAP::opendbi( 'SYBASE.eq_script_user' ); $dbi->do(``SELECT * FROM people WHERE nice = 'very''');

For this example to work, a configuration file called dbi.SYBASE would have to be created, and it needs to contain values for 'data_source', 'username' and 'password'

data_source=SYBASE
username=eq_script_user
password=secret

or full data_source:

data_source=dbi:ODBC:ms_servosl12
username=eq_script_user
password=secret

or

data_source=dbi:Sybase:server=SYBASE
username=eq_script_user
password=secret

Comment on Re^6: Writing Multiple Recordsets into a CSV file

Replies are listed 'Best First'.
Re^7: Writing Multiple Recordsets into a CSV file by derby (Abbot) on Apr 11, 2008 at 15:43 UTC
Well ... that's interesting ... so the dbd object can be either DBD::Sybase or DBD::ODBC ... so which is yours? The way to handle multiple resultsets is DBD driver dependant. -derby	[reply]
Re^8: Writing Multiple Recordsets into a CSV file by sudip_dg77 (Novice) on Apr 11, 2008 at 15:59 UTC
Our KAP Module uses DBD::ODBC	[reply]
Re^9: Writing Multiple Recordsets into a CSV file by derby (Abbot) on Apr 11, 2008 at 17:24 UTC
Well ... then looking at the DBD::ODBC docs, you should be using `$sth->{odbc_more_results}` not `$sth->{syb_more_results}` -derby	[reply] [d/l] [select]