By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,130 Members | 2,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,130 IT Pros & Developers. It's quick & easy.

Problems creating stored procedure

P: n/a
I am running DB2 Express V 8.1 on Windows XP
I have installed the Visual C/C++ compiler the command to invoke the
compiler is cl

I am attempting to install the stored procedure defined below

CREATE PROCEDURE TESTQC.ECMP2000

(INOUT str VARCHAR(32) for bit data)

RESULT SETS 0

LANGUAGE SQL

BEGIN

SET str = 'STRING';

END

@

with the following command in the command line prompt

db2 -v -td@ -f testproc.sql

I obtain the following error message

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL7032N SQL procedure "ECMP2000" not created. Diagnostic file is
"P4080374.log". SQLSTATE=42904

Where is the file P4080374.log located? Could it be a problem the the the c
compiler. I have ensured that it is within the path of the command processor
window I am using.

On another note when I to use the development center obtain an error
concerning nmake not being found

Is there a document that comprehensively describes how t o use these
products

Thanks

Solomon


Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
See
Retaining Intermediate Files for SQL Procedures
http://publib.boulder.ibm.com/infoce...69%6c%65%22%20

SQLSTATE 42904: The SQL procedure was not created because of a compile
error.

PM

"Solomon Obi" <so******@yahoo.com> a écrit dans le message de
news:5Q******************@nwrdny01.gnilink.net...
I am running DB2 Express V 8.1 on Windows XP
I have installed the Visual C/C++ compiler the command to invoke the
compiler is cl

I am attempting to install the stored procedure defined below

CREATE PROCEDURE TESTQC.ECMP2000

(INOUT str VARCHAR(32) for bit data)

RESULT SETS 0

LANGUAGE SQL

BEGIN

SET str = 'STRING';

END

@

with the following command in the command line prompt

db2 -v -td@ -f testproc.sql

I obtain the following error message

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL7032N SQL procedure "ECMP2000" not created. Diagnostic file is
"P4080374.log". SQLSTATE=42904

Where is the file P4080374.log located? Could it be a problem the the the c compiler. I have ensured that it is within the path of the command processor window I am using.

On another note when I to use the development center obtain an error
concerning nmake not being found

Is there a document that comprehensively describes how t o use these
products

Thanks

Solomon

Nov 12 '05 #2

P: n/a
See
Retaining Intermediate Files for SQL Procedures
http://publib.boulder.ibm.com/infoce...69%6c%65%22%20

SQLSTATE 42904: The SQL procedure was not created because of a compile
error.

PM

"Solomon Obi" <so******@yahoo.com> a écrit dans le message de
news:5Q******************@nwrdny01.gnilink.net...
I am running DB2 Express V 8.1 on Windows XP
I have installed the Visual C/C++ compiler the command to invoke the
compiler is cl

I am attempting to install the stored procedure defined below

CREATE PROCEDURE TESTQC.ECMP2000

(INOUT str VARCHAR(32) for bit data)

RESULT SETS 0

LANGUAGE SQL

BEGIN

SET str = 'STRING';

END

@

with the following command in the command line prompt

db2 -v -td@ -f testproc.sql

I obtain the following error message

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL7032N SQL procedure "ECMP2000" not created. Diagnostic file is
"P4080374.log". SQLSTATE=42904

Where is the file P4080374.log located? Could it be a problem the the the c compiler. I have ensured that it is within the path of the command processor window I am using.

On another note when I to use the development center obtain an error
concerning nmake not being found

Is there a document that comprehensively describes how t o use these
products

Thanks

Solomon

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.