CTE in PROC?

["Ryan Hunt" <ryan.hunt@xxxxxxxxxxxxx>]

I have been trying to use a CTE in a stored proc but can't seem to get my 
syntax right.  I've checked the SQL redbook and the stored proc redbook (and 
of course google) but I haven't seen an example of where to put it.

I've tried:
CREATE PROCEDRE...
blah
blah

BEGIN

DECLARE CURSOR C1 WITH RETURN FOR

WITH Q1 (col1, col2)
AS
(SELECT....)

SELECT blah, blah
FROM Q1

OPEN C1
CLOSE C1
END

Anyway, I can't seem to put the CTE in there (anyware) without causing an 
error.

Can CTE's be used on DB2/400 V5R4?