PROCEDURE with one-character name, not returning RESULT SET

[Brian Tkatch]

DB2/SUN 8.1.6

Using the client and CREATEing a PROCEDURE with a one-character name
and DECLAREing a CURSOR using WITH RETURN TO CLIENT, does not result in
a RESULT SET being shown.

CREATE PROCEDURE A() BEGIN \
DECLARE List CURSOR \
WITH RETURN TO CLIENT FOR VALUES(1); \
OPEN List; \
END

CREATE PROCEDURE AA() BEGIN \
DECLARE List CURSOR \
WITH RETURN TO CLIENT FOR VALUES(1); \
OPEN List; \
END

db2 => CALL A

Return Status = 0

db2 => CALL AA
Result set 1
--------------

1
-----------
1

1 record(s) selected.

Return Status = 0

DROP PROCEDURE A
DROP PROCEDURE AA

Is there a reason for this?

B.

[Serge Rielau]

Brian Tkatch wrote:

DB2/SUN 8.1.6

Using the client and CREATEing a PROCEDURE with a one-character name
and DECLAREing a CURSOR using WITH RETURN TO CLIENT, does not result in
a RESULT SET being shown.

CREATE PROCEDURE A() BEGIN \
DECLARE List CURSOR \
WITH RETURN TO CLIENT FOR VALUES(1); \
OPEN List; \
END

CREATE PROCEDURE AA() BEGIN \
DECLARE List CURSOR \
WITH RETURN TO CLIENT FOR VALUES(1); \
OPEN List; \
END

db2 => CALL A

Return Status = 0

db2 => CALL AA
Result set 1
--------------

1
-----------
1

1 record(s) selected.

Return Status = 0

DROP PROCEDURE A
DROP PROCEDURE AA

Is there a reason for this?

B.

What happens when you do a CALL A()?
I get a -480 when I ommit the braces....with braces it works(?)
I suspect a CLP bug in the shorthand allowing calls to procs without
braces...

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Brian Tkatch]

CALL A() does work.

I suspect a CLP bug in the shorthand

Sounds plausable.

B.