Db2 native Stored Procedures that need to be retrieved from the catalog may need to be reformatted to 72 chars per line.This REXX extracts and reformats such Stored Procedures.Also attached the JCL to run the REXX.The REXX has a few values to be changed as site dependent.Value is aa.bb which is the high level qualifiers of the dataset to store the output.This must match the JCL aa.bb value.
JCL also tweaked to remove any internal org info.
You will also need to change the PROCLIB & JCLLIB info as required.
JOB(dddd) is the accounting info
Sss = Db2 subsystem id, aka ssid
aa.bb = dataset qualifiers, must match REXX aa.bb values
Xxxx = last 4 chars of the schema, e.g. p001 for PROD
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504