Jeff Zucker wrote:
$dbh->ad_import('fruit_name' ,'DBI',DBI->connect( $dsn{odbc} ));
$dbh->ad_import('fruit_color','DBI',DBI->connect( $dsn{sqlite} ));
I forgot to mention that if you pass SQL queries to the ad_import() calls, you can import only the rows and columns you are interested in, rather than having to import the entire tables, which is the default.
$dbh->ad_import( $ram_table_name
, 'DBI'
, DBI->connect( $dsn )
, { sql => $sql }
);The $sql can be anything acceptable to the driver/RDBMS specified in the $dsn.
-- Jeff
