Here it is...
-- Generate SQL
-- Version: V5R4M0 060210
-- Generated on: 09/14/09 11:19:23
-- Relational Database: PRVQAS2A
-- Standards Option: DB2 UDB iSeries
SET PATH *LIBL ;
CREATE PROCEDURE COHPGMS.SP_GETEQUIP1 (
IN I_SQL CHAR(500) )
DYNAMIC RESULT SETS 1
LANGUAGE SQL
SPECIFIC COHPGMS.SP_GETEQUIP1
NOT DETERMINISTIC
READS SQL DATA
CALLED ON NULL INPUT
SET OPTION ALWBLK = *ALLREAD ,
ALWCPYDTA = *OPTIMIZE ,
COMMIT = *NONE ,
DECRESULT = (31, 31, 00) ,
DFTRDBCOL = *NONE ,
DLYPRP = *NO ,
DYNDFTCOL = *NO ,
DYNUSRPRF = *USER ,
RDBCNNMTH = *RUW ,
SRTSEQ = *HEX
BEGIN DECLARE C1 CURSOR FOR S1 ; PREPARE S1 FROM I_SQL ; OPEN C1 ; END ;
COMMENT ON SPECIFIC PROCEDURE COHPGMS.SP_GETEQUIP1
IS 'Retrieve a list of equipment' ;
Thank you,
Antonio Mira
Application Developer - Mid-Ohio Division
Time Warner Cable
1015 Olentangy River Road - 2nd Floor
Columbus, OH 43212
http://www.timewarnercable.com
phone: 614 827 7949
-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of ibm
Sent: Monday, September 14, 2009 11:13 AM
To: .net use with the System i
Subject: Re: [SystemiDotNet] Qualified names...
Can you show us the stored procedure? Especially the part that deals with the cursors...
-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Mira, Antonio
Sent: Monday, September 14, 2009 9:27 AM
To: .net use with the System i
Subject: Re: [SystemiDotNet] Qualified names...
Hi...
Thanks for the reply. Was out sick and did not have access to email...
Here's the sql statement before the call to the procedure...
"SELECT CEITM , CESER , CESTC , CESDT , CEHED FROM OHILIVFILE.convrpf WHERE CENROV = 2 and CEITM in ('MT2000') and CESTC = 'L' and CESDT between 1090801 and 1090831 order by ceitm, ceser"
I had originally built the sql statement as shown above (with the dot notation). When looking at the job log, I find this message:
Qualified object name CONVRPF not valid.
I also changed the dot with a forward slash and got the same error.
Any help would be greatly appreciated. I verified that the object does exist in library OHILIVFILE.
Thank you,
Antonio Mira
Application Developer - Mid-Ohio Division
Time Warner Cable
1015 Olentangy River Road - 2nd Floor
Columbus, OH 43212
http://www.timewarnercable.com
phone: 614 827 7949
-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Sent: Thursday, September 10, 2009 9:28 AM
To: .net use with the System i
Subject: Re: [SystemiDotNet] Qualified names...
Could you send the SQL statement? Perhaps that would help.
midrange.com
