Midrange News for the IBM i Community

Posted by: Jellybean
Memphis, TN
SQL Source
has no ratings.
Published: 19 Apr 2011
Revised: 23 Jan 2013 - 4051 days ago
Last viewed on: 25 Feb 2024 (5700 views) 

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.

SQL Source Published 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.




Return to midrangenews.com home page.
Sort Ascend | Descend


(Sign in to Post a Comment)
Posted by: rgilsdor
Premium member *
Wayne, Michigan
Comment on: SQL Source
Posted: 12 years 4 months 17 days 22 hours 40 minutes ago

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.