Problems creating stored procedure

[Solomon Obi]

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

[PM \(pm3iinc-nospam\) CGO]

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

[PM \(pm3iinc-nospam\) CGO]

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