Hi,

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.

Kind regards

Lionel

NB : Excuse-me for the translation, I'm not used to write in English.

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 needed