Common table expression in a stored procedure

[ramcorind]

Are you able to use a recursive common table expression in a stored procedure? I have tried to create a stored procedure which uses a recursive common table expresion and I receive an error specifying that "an unexpected token WITH was found".

I have also tried to use a recursive common table expression in a trigger and I receive a similar message.

I have read that declared temporary tables cannot be used in triggers. Are common table expressions considered the same as declared temporary tables?

Any input would be greatly appreciated.

 

[leveyp]

Not all implementations of DB2 support temporary tables.
What environment are you using?

 

[ramcorind]

We are using DB2 UDB V8.1 on Linux Redhat V.8.