Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    5

    Unanswered: Error -805 when i execute my program on multiple databases

    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.

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    bind

    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
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •