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.