Re: Storing SQL script options

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

I save my SQL sessions to a file in a folder. They are saved with the
.sql extension. 

I have also saved useful scripts to the examples folder for access via
'Insert From Examples...'  

There was a good article on this recently published. 

http://ibmsystemsmag.com/ibmi/administrator/systemsmanagement/create-your-own-templates/


Paul 

On 2019-03-26 11:53, Steinmetz, Paul via MIDRANGE-L wrote:

> I've just recently started using the ACS "Run SQL Scripts".
> I'm looking at the various options available for storing SQL statements, some  for  IBM i catalog tables and views.
> My initial option was to create a source member in our source library for each SQL script.
> With the 10 character limit, I'm finding it difficult to have meaning names for these scripts.
>
> What methods are others in the group using to store SQL scripts?
>
> Thank You
> _____
> Paul Steinmetz 
> IBM i Systems Administrator 
>
> Pencor Services, Inc. 
> 462 Delaware Ave 
> Palmerton Pa 18071 
>
> 610-826-9117 work 
> 610-826-9188 fax 
> 610-349-0913 cell 
> 610-377-6012 home 
>
> psteinmetz@xxxxxxxxxx 
> http://www.pencor.com/