Hy,

with the stored procedure builder i made the follwing SP:

CREATE PROCEDURE test.Proc1 ( IN var0 date )
RESULT SETS 1
modifies SQL DATA
LANGUAGE SQL
------------------------------------------------------------------------
-- Gespeicherte SQL-Prozedur
------------------------------------------------------------------------

P1: BEGIN

-- Cursor deklarieren

DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT PROCSCHEMA, PROCNAME FROM SYSCAT.PROCEDURES;

-- Cursor wurde für die Client-Anwendung geöffnet gelassen

OPEN cursor1;

END P1


The SP have one "dummy" IN-parameterm (type date). It works fine when i call it out of the SP-Builder.
But i havn't found a way to call it from MS ACCESS or MS QUERY:

The Pass-trough ODBC-Query:

{call test.proc1 ( {d '2002-12-31' } ) }

or

{call burgdi.proc1 ('2002-12-31') }

cause this error: SQL 0171N: ...Data type problem.....

Can someone help me?

Thanks Atti