Pro c precomplier issue [message #93894] |
Fri, 07 March 2003 03:00 |
robert collett
Messages: 1 Registered: March 2003
|
Junior Member |
|
|
I am currently writting a program that connects to two different databases in a unix enviroment
With in the code i have two procs that connect to the different databases.
using the
EXEC SQL DECLARE db1 DATABASE
EXEC SQL DECLARE db2 DATABASE
Then through out the program i use the AT command to reference which database i am using at any given time.
My problem comes when i go to compile this program.
The make file is set to do SQLCHECK=SEMANTICS, it then sets USRID for one of the db's, the trouble i am having is i get PCC-S-02331, undefined SQL identifier for the statements that use the other database. I can find nothing on the net to help me rewrite the make file to handle the fact i am connecting to multiple databases. Even tho i am using the techniques that oracle themselves recommend
Can anyone help please.
|
|
|