Hi
 
I am using Perl version 5.00503 on Solaris 8 with the DBI::Informix module (Informix V9.2).
 
I want to be able to create a new database if it doesn't already exist so I:
  1. Connect to sysmaster
  2. Query sysdatabases for my database name
  3. It's not there so I "create database x with buffered logging"
At which point it bombs with SQL: -759: Cannot use database commands in an explicit database connection.
 
The create doesn't work because I'm already connected to a database; but in order to use the database driver I need a database handle and to get a database handle I have to connect to a database (D'OH!).
 
Is there any way to do this??
 
Thanks in advance
 
David Hollingworth

Reply via email to