Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
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.
thanks
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.