in reply to Re^4: Writing Multiple Recordsets into a CSV file
in thread Writing Multiple Recordsets into a CSV file

You still haven't told us about KAP? Does it return a DBD object? If so, which one - DBD::Sybase, DBD::Oracle or something else? Or is it a wrapper around a DBD object? If so, does KAP expose the necessary methods/members to traverse multiple result sets. Until you can tell us more about KAP, every answer here is just MJD 11900 or (my favorite) 11901.

-derby
  • Comment on Re^5: Writing Multiple Recordsets into a CSV file

Replies are listed 'Best First'.
Re^6: Writing Multiple Recordsets into a CSV file
by sudip_dg77 (Novice) on Apr 11, 2008 at 15:31 UTC
    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
[reply]

      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]
        Our KAP Module uses DBD::ODBC
[reply]

In Section Seekers of Perl Wisdom