Created
October 24, 2016 22:41
-
-
Save jonbartlett/dab4513f4f58af0baaf55d86ad707899 to your computer and use it in GitHub Desktop.
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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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