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 - 1585 days ago
Last viewed on: 27 May 2017 (3269 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.

 

thanks

  

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

COMMENTS

(Sign in to Post a Comment)
Posted by: rgilsdor
Premium member *
Wayne, Michigan
Comment on: SQL Source
Posted: 5 years 7 months 17 days 9 hours 52 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.