RE: Storing SQL script options

Rob's article does a great job of explaining it.

I know the team in Rochester is working on some additional ways as well.


--
Jim Oberholtzer
Agile Technology Architects

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Paul
Therrien
Sent: Tuesday, March 26, 2019 10:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Storing SQL script options

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-ow
n-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/

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com