generate context of funtions
*/
SELECT FUNCSCHEMA,FUNCNAME,SPECIFICNAME,FUNCID,TYPE,METHOD,VARCHAR(BODY)
FROM SYSCAT.FUNCTIONS
WHERE FUNCSCHEMA = 'DB2ADMIN'
AND TYPE = 'S'
/*
generate context of views
*/
SELECT VIEWSCHEMA,VIEWNAME,VALID,VARCHAR(TEXT)
FROM SYSCAT.VIEWS
WHERE VIEWSCHEMA = 'DB2ADMIN'
/*
generate context of stored procedures
*/
SELECT ROUTINENAME,VARCHAR(TEXT)
FROM SYSIBM.SYSROUTINES
WHERE ROUTINESCHEMA='DB2ADMIN'
/*
using export to generate procedure code when context is very large
check SPBODY.001 and procedures are in it
*/
EXPORT TO C:\SP.SQL OF DEL LOBS TO C:\ LOBFILE SPBODY MODIFIED BY NOCHARDEL LOBSINFILE
"SELECT TEXT FROM SYSIBM.SYSROUTINES WHERE ROUTINESCHEMA='DB2ADMIN'"
