Switching between 2 different databases in perl

Switching between 2 different databases in perl

 

  

Hey everyone,
I want to connect and simultaneouly query two databases one db2 and
other sybase. I need to switch betwwen two databases.ie based on
parameter I get from db2 I query sybse. Problem is I m using dbh1 and
dbh2 handles but while preparing the next query I get the following
error "Can't call method "prepare" on an undefined value".=20
How can I switch between two connections in perl script using DBI
Thanks in advance.
Mayank


DB2 & UDB email list listserv db2-l LazyDBA home page