Toad World® Forums

Compile zos Stored Procedure using latest beta drop 4.6.0.493


#1

Good day,

I am trying to re-compile a ZOS language SQL SP and getting an error caused by
some clauses being repeated twice:

Thanks

Yvan

att1.dat (25.5 KB)
att1.dat (21.4 KB)


#2

Hi Yvan,

This is similar to a problem we’ve seen before. Will you please give me
the full text of this SP?

Thanks,

Adam


#3

Hi Yvan,

This is similar to a problem we’ve seen before. Will you please give me
the full text of this SP?

Thanks,

Adam
image002.gif (21.4 KB)


#4

Hi Adam,

as requested,

CREATE PROCEDURE “SODDB”.“DB$PSQL1” ( )
LANGUAGE SQL
EXTERNAL NAME ‘DB$PSQL1’
DYNAMIC RESULT SETS 1
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV
ASUTIME NO LIMIT
PROGRAM TYPE MAIN
SECURITY DB2
NOT DETERMINISTIC
FENCED
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
STAY RESIDENT NO
COMMIT ON RETURN NO
STOP AFTER SYSTEM DEFAULT FAILURES
RUN OPTIONS ‘NOTEST(NONE, ,,*)’
EXTERNAL NAME “DB$PSQL1”
FENCED
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV


– SQL Stored Procedure


P1: BEGIN
– Declare cursor
DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT SCHEMA, NAME FROM SYSIBM.SYSROUTINES
WHERE SCHEMA = ‘SODDB’;

– Cursor left open for client application
OPEN cursor1;
END P1;

Thanks

Yvan

Adam Ririe
Sent by:

28/01/2010 12:10 PM

Please respond to
toaddb2beta@ yahoogroups. com

To

“toaddb2beta@ yahoogroups. com”

cc

Subject

RE: [toaddb2beta] Compile zos Stored Procedure using latest beta drop 4.6.0.493

Classification

Hi Yvan,

This is similar to a problem we’ve seen before. Will you please give me
the full text of this SP?

Thanks,

Adam
att1.dat (43 Bytes)


#5

Hi Adam,

as requested,

CREATE PROCEDURE “SODDB”.“DB$PSQL1” ( )
LANGUAGE SQL
EXTERNAL NAME ‘DB$PSQL1’
DYNAMIC RESULT SETS 1
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV
ASUTIME NO LIMIT
PROGRAM TYPE MAIN
SECURITY DB2
NOT DETERMINISTIC
FENCED
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
STAY RESIDENT NO
COMMIT ON RETURN NO
STOP AFTER SYSTEM DEFAULT FAILURES
RUN OPTIONS ‘NOTEST(NONE, ,,*)’
EXTERNAL NAME “DB$PSQL1”
FENCED
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV


– SQL Stored Procedure


P1: BEGIN
– Declare cursor
DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT SCHEMA, NAME FROM SYSIBM.SYSROUTINES
WHERE SCHEMA = ‘SODDB’;

– Cursor left open for client application
OPEN cursor1;
END P1;

Thanks

Yvan

Adam Ririe
Sent by:

28/01/2010 12:10 PM

Please respond to
toaddb2beta@ yahoogroups. com

To

“toaddb2beta@ yahoogroups. com”

cc

Subject

RE: [toaddb2beta] Compile zos Stored Procedure using latest beta drop 4.6.0.493

Classification

Hi Yvan,

This is similar to a problem we’ve seen before. Will you please give me
the full text of this SP?

Thanks,

Adam
image004.gif


#6

Hi Adam,

as requested,

CREATE PROCEDURE “SODDB”.“DB$PSQL1” ( )
LANGUAGE SQL
EXTERNAL NAME ‘DB$PSQL1’
DYNAMIC RESULT SETS 1
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV
ASUTIME NO LIMIT
PROGRAM TYPE MAIN
SECURITY DB2
NOT DETERMINISTIC
FENCED
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
STAY RESIDENT NO
COMMIT ON RETURN NO
STOP AFTER SYSTEM DEFAULT FAILURES
RUN OPTIONS ‘NOTEST(NONE, ,,*)’
EXTERNAL NAME “DB$PSQL1”
FENCED
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV


– SQL Stored Procedure


P1: BEGIN
– Declare cursor
DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT SCHEMA, NAME FROM SYSIBM.SYSROUTINES
WHERE SCHEMA = ‘SODDB’;

– Cursor left open for client application
OPEN cursor1;
END P1;

Thanks

Yvan

Adam Ririe
Sent by:

28/01/2010 12:10 PM

Please respond to
toaddb2beta@ yahoogroups. com

To

“toaddb2beta@ yahoogroups. com”

cc

Subject

RE: [toaddb2beta] Compile zos Stored Procedure using latest beta drop 4.6.0.493

Classification

Hi Yvan,

This is similar to a problem we’ve seen before. Will you please give me
the full text of this SP?

Thanks,

Adam
att1.dat (21.4 KB)


#7

Hi Adam,

as requested,

CREATE PROCEDURE “SODDB”.“DB$PSQL1” ( )
LANGUAGE SQL
EXTERNAL NAME ‘DB$PSQL1’
DYNAMIC RESULT SETS 1
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV
ASUTIME NO LIMIT
PROGRAM TYPE MAIN
SECURITY DB2
NOT DETERMINISTIC
FENCED
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
STAY RESIDENT NO
COMMIT ON RETURN NO
STOP AFTER SYSTEM DEFAULT FAILURES
RUN OPTIONS ‘NOTEST(NONE, ,,*)’
EXTERNAL NAME “DB$PSQL1”
FENCED
COLLID DBGDSP00
WLM ENVIRONMENT WLMDEV


– SQL Stored Procedure


P1: BEGIN
– Declare cursor
DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT SCHEMA, NAME FROM SYSIBM.SYSROUTINES
WHERE SCHEMA = ‘SODDB’;

– Cursor left open for client application
OPEN cursor1;
END P1;

Thanks

Yvan

Adam Ririe
Sent by:

28/01/2010 12:10 PM

Please respond to
toaddb2beta@ yahoogroups. com

To

“toaddb2beta@ yahoogroups. com”

cc

Subject

RE: [toaddb2beta] Compile zos Stored Procedure using latest beta drop 4.6.0.493

Classification

Hi Yvan,

This is similar to a problem we’ve seen before. Will you please give me
the full text of this SP?

Thanks,

Adam


#8

Hi Yvan,

It appears the ‘$’ in the external name is causing the problem.
CR 70,728 has been created to track this issue.

Thanks,

Adam


#9

Hi Yvan,

It appears the ‘$’ in the external name is causing the problem.
CR 70,728 has been created to track this issue.

Thanks,

Adam
image002.gif (21.4 KB)