Skip to content

Instantly share code, notes, and snippets.

@jonbartlett
Created October 24, 2016 22:41
Embed
What would you like to do?
Export DB2 Stored Procedures to a file. Useful for comparing stored procs in the DB and those in source control as IDE's tend to try and format the code.
EXPORT TO proc_export.txt OF DEL
MODIFIED BY NOCHARDEL lobsinfile lobsinsepfiles
SELECT TEXT
FROM SYSCAT.ROUTINES
WHERE TRIM(ROUTINESCHEMA) ='RDS'
AND ROUTINENAME ='IU_RDS_CLASS';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment