473,500 Members | 1,686 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 SQL Stored Procedure Build problem

I am trying to build a simple SQL stored procedure in DB2 Stored
Procedure Builder V7.

It gives me the following message. Can someone help me to identify the
problem.

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Create stored procedure returns
-7032.

QCPI039.CREATE_DAILY_BENEF_XREF_DN:
-- LOG FILE P3530964.log FOR PROCEDURE QCPI039
..CREATE_DAILY_BENEF_XREF_DN

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sqc

LINE MESSAGES FOR P3530964.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

-- CONTENTS OF /udbprod/udbins40/sqllib/function/routine/sr_cpath

#!/bin/sh
PATH=$PATH:/usr/vacpp/bin
PATH=$PATH:/usr/ibmcxx/bin
PATH=$PATH:/usr/lpp/xlC/bin
export PATH

-- CONTENTS OF /udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sh

SQLROUTINE_FILENAME=P3530964
export SQLROUTINE_FILENAME
export SQLROUTINE_ENTRY=pgsjmp

-- COMPILATION COMMAND:

xlC_r -I/udbprod/udbins40/sqllib/include P3530964.c -bE:P3530964.exp
-e pgsjmp -o P3530964 -L/udbprod/udbins40/sqllib/lib -ldb2
-- CONTENTS OF /udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.exp

pgsjmp
-- COMPILATION MESSAGES FOR
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.c
xlC_r: 1501-224 fatal error in /usr/ibmcxx/exe/munch: signal 4
received

-- END OF LOG FILE (SQLCODE: -7032)
QCPI039.CREATE_DAILY_BENEF_XREF_DN - Changes rolled back.

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Build failed.
Nov 12 '05 #1
5 4279
dharmadam wrote:
I am trying to build a simple SQL stored procedure in DB2 Stored
Procedure Builder V7.

It gives me the following message. Can someone help me to identify the
problem.

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Create stored procedure returns
-7032.

QCPI039.CREATE_DAILY_BENEF_XREF_DN:
-- LOG FILE P3530964.log FOR PROCEDURE QCPI039
.CREATE_DAILY_BENEF_XREF_DN

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sqc

<SNIP>

Check the permissions on directory

/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp

DB2 is unable to write to that directory.

N. Shamsundar
University of Houston
Nov 12 '05 #2
Signal 4 is SIGILL on AIX, illegal instruction. Can you compile a
different SQL procedure on that system, or do they all fail? It might
be a problem with the C compiler that's installed.

Cheers
Serge
Nov 12 '05 #3
"N. Shamsundar" <sh******************@nospam.xyz> wrote in message news:<cl***********@masala.cc.uh.edu>...
dharmadam wrote:
I am trying to build a simple SQL stored procedure in DB2 Stored
Procedure Builder V7.

It gives me the following message. Can someone help me to identify the
problem.

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Create stored procedure returns
-7032.

QCPI039.CREATE_DAILY_BENEF_XREF_DN:
-- LOG FILE P3530964.log FOR PROCEDURE QCPI039
.CREATE_DAILY_BENEF_XREF_DN

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sqc

<SNIP>

Check the permissions on directory

/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp

DB2 is unable to write to that directory.

N. Shamsundar
University of Houston


I don't thinh that was the problem. I see the log, scm,sqc files are
created in the directory.
Nov 12 '05 #4
Serge Rielau <sr*****@ca.ibm.com> wrote in message news:<2u*************@uni-berlin.de>...
Signal 4 is SIGILL on AIX, illegal instruction. Can you compile a
different SQL procedure on that system, or do they all fail? It might
be a problem with the C compiler that's installed.

Cheers
Serge


I tied with very simple SQL statement and all fails with the same error.
Nov 12 '05 #5
dharmadam wrote:
"N. Shamsundar" <sh******************@nospam.xyz> wrote in message news:<cl***********@masala.cc.uh.edu>...
dharmadam wrote:
I am trying to build a simple SQL stored procedure in DB2 Stored
Procedure Builder V7.

It gives me the following message. Can someone help me to identify the
problem.

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Create stored procedure returns
-7032.

QCPI039.CREATE_DAILY_BENEF_XREF_DN:
-- LOG FILE P3530964.log FOR PROCEDURE QCPI039
.CREATE_DAILY_BENEF_XREF_DN

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sqc


<SNIP>

Check the permissions on directory

/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp

DB2 is unable to write to that directory.

N. Shamsundar
University of Houston

I don't thinh that was the problem. I see the log, scm,sqc files are
created in the directory.

Try, anyway:

chmod a+wx
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp

and then try to install the SP. This won't hurt and won't take much time
to do.

If this works, you may need to examine your umask settings.

N. Shamsundar
University of Houston
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
3233
by: Alex | last post by:
Hi all, I am trying to install a java stored procedure via the windows development centre. The linux box is running 8.1 FP4 as is the windoze platform. If I am on the linux box i can install...
3
2782
by: Rhino | last post by:
I've spent the last couple of hours trying to figure out how to debug a Java stored procedure and am just going in circles. The last straw came when I got "Cannot open input stream for default"...
2
9196
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
0
2003
by: Juan Carlos Huitzache | last post by:
Hi, I am trying to build a very simple Java stored procedure on DB2 V8.2 for AIX. I use the WSAD 5.1 or the DB2 Development Center with the same result: C:\Program Files\SQLLIB\java\jdk\bin\jar...
2
3130
by: Michael | last post by:
Running DB2 v7 UDB ("DB2 v7.1.0.93", "n031208" and "WR21333") on Windows XP, I am unable to find out why the "Build for Debug" option within Stored Procedure Builder is not enabled on Java stored...
1
7476
by: peaceburn | last post by:
Hi, I'm gonna pull my hair in the coming days with these DB2 stored procedures. So the issue, let's assume a simple stored procedure like this : CREATE PROCEDURE MYSCHEMA.PROCEDURE1 ( )...
1
4281
by: gregoryday | last post by:
I am battling to get a stored procedure to build: I have a stored procedure working in SQL Server 2000, and now need to port it to DB2. I will be accessing the stored procedure via VB.NET. The...
10
16402
by: PJackson | last post by:
Trying to declare a simple handler for SQLEXCEPTION. Simple stored proc (UDB 8.2) ---- CREATE PROCEDURE TFBUDB.SMACF_SM_DI (IN POL_NBR CHAR(10) , OUT ErrNo INTEGER , OUT ErrMsg CHAR(80) )...
3
4188
by: annoir | last post by:
I am trying to create a stored procedure using the DB2 Connect Development Center. I am able to create the project, connect to the remote database on the mainframe and create the stored procedure....
0
7134
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7014
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7180
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7229
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7395
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5485
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4609
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3103
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
667
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.