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 - 4123 days ago
Last viewed on: 07 May 2024 (5781 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: 12 years 6 months 29 days 3 hours 20 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.