p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

db2 thread: db2 sqlcode -805


Message #1 by "King You. Lee" <kinglee@m...> on Thu, 27 Dec 2001 03:34:51
Hi,

Make a trace with truss, so you see where he looks for the scrpts.

Good luck, Jan

On Thu, 27 Dec 2001, King You. Lee wrote:

> ---
> Need a present for your favorite programmer?
> E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp
> ---
> Hi db2 experts,
> Let me explain my setup. I have a Unix box (SUN Solaris 8) DB2 V7.1, which 
> hosting all my application written in Embeded C/C++. I have another box 
> AS/400 DB2 4.5, which hosting the data only.
> 
> Unix connect to AS/400 using DB2Connect.
> 
> Now, I have an Embeded C/C++ program (only one sqc) compile in UNix, which 
> will be executed in Unix environment and manipulate data in AS/400 thru 
> DB2connect. I managed to compile the program, bind it to AS/400 library 
> and it's executed perfectly.
> 
> But, if I have an Application which consists of a lot of programs (*.sqc), 
> which will be executed in Unix environment and manipulate data in AS/400 
> thru DB2connect. I managed to compile those programs, bind them to AS/400 
> library (I can see the packages from DDS environment). But when I executed 
> the Application, when one of the program issue SQL command, the 
> Application return SQLCODE -805, which means couldn't find the package.
> 
> So, what's wrong? Any parameters missing during the PREP (precompile) 
> compilation? Or any configuration need to be changed for AS/400 DB2?
> 
> Please help.
> 
> Thanks.
> 


  Return to Index