SQL SourcePublished by: Jellybean on 19 Apr 2011 view comments(1)
I'm getting more and more into SQL. I'm creating tables and materialized tables. My area of concern is where to keep the source code, so if I need to re-create something I can. And what would be the easiest means of doing so.
I creatred a QSQLSRC in my source library. I keep code to recreate the files is necessary. I change files in STRSQL, but keep the code just in case.
I have a lot of stored procedures in there too so I can recreate them as needed when I must make a change. I also keep some plain SQL in there as well that I run using RUNSQLSTM from CL as needed. Makes a good resource for figuring out what is what.