10-30-06, 05:40 #1Registered User
- Join Date
- Oct 2006
Unanswered: Error -805 when i execute my program on multiple databases
I want to migrate in DB2 some programs with sql embedded.
These programs are .sqc files that i pre-compile with the db2 script "embprep" to obtain .c files which are finally compiled with gcc.
I have to take the database name in parameter for the pre-compilation.
But if i want to launch my .exe file on another database, i have the following error :
-805 : DBRM OR PACKAGE NAME NOT FOUND IN PLAN
The solution consists of recompile my program with the other database name, but i cannot use this solution for my multi-database application.
Is it possible to generate unique executable files which work on any database ?
Thanks in advance.
NB : Excuse-me for the translation, I'm not used to write in English.
10-30-06, 13:42 #2Registered User
- Join Date
- Jun 2006
you should execute another command first to create a bind file (will look this up)
use the bind-file to bind against each db that is involved in the program.
db2 connect to x
db2 bind xxx.bnd ..
and repeat as neededBest Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8