Skip to content

Instantly share code, notes, and snippets.

@jonbartlett

jonbartlett/db2-proc-export.sql

Created October 24, 2016 22:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jonbartlett/dab4513f4f58af0baaf55d86ad707899 to your computer and use it in GitHub Desktop.
Save jonbartlett/dab4513f4f58af0baaf55d86ad707899 to your computer and use it in GitHub Desktop.
Download ZIP
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.
Raw
db2-proc-export.sql
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