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 - 2185 days ago
Last viewed on: 16 Jan 2019 (4111 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)

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: 7 years 3 months 7 days 15 hours 28 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.