In db2 NT UDB V8.1, by this sql as follow :
select text from syscat.procedures where procname='PROC1';
we can get the sp's script text .
But I can't find the similar table in as400 as syscat.procedures in NT UDB V8.1
which table dose include the information of stored procedure in as400 ?

Could you help me ?

thank you !

db2 UDB NT v 8.1，
select text from syscat.procedures where procname='PROC1';
we can get PROC1's define script .

in as400 , there is any table or view with the similar function ?

Have you tried manuals? I've heard it helps sometimes...

http://publib.boulder.ibm.com/iserie...bafzmst183.htm