Re: Multiple connections?

[David Smith <davesmit@US.IBM.COM>]

Phillippe,

You can create a new connection with a named user for your temp table
inserts, you just need to get the syntax correct for the database.  It
might also be different if you are using SQR-Oracle or SQR-ODBC for the
connection? Oracle uses the user/pwd@tnsname syntax you quoted.

Use the -DBconnectionstring
Here is one for ODBC:
begin-SQL -DB=EPCYCLE2;DSN=EPCYCLE2;UID=PSADMIN;PWD=PSADMIN

DSN=data_source_name[;keyword=value[;keyword=value[;...]]]
where DSN, UID, and PWD are keywords common to all drivers (representing
data source name, user ID, and password, respectively).

I think you will have a problem with the Maximo password, how are you going
to know this?  You will need to have the administrator place it in your
source code, then compile the report, and use the compiled version to run
in Maximo to keep the password secure.  You could use an #include file for
this to make if a little easier.  This also defeats your goal of having an
easy drop in solution without using DBA or Sysadm.

I think you need a solution that avoids temp tables.  I have never had to
use them for a Maximo report, there are always solutions in coding or db
indexes to improve performance of a report.


David L Smith
IBM Global Services