Re: ACS Run SQL Script - Using library names with periods

[K Crawford <kscx3ksc@xxxxxxxxx>]

True about the periods and save and other things.
Another gotcha.  A lot (all?) of S/36 used QS36F for the data library.
Note that BRMS will not encrypt any library that starts with Q.  Guess
what had to be saved to a save file before the backup then saved in BRMS to
encrypt.  Then make sure to omit QS36F from the save so unencrypted data is
not on the tape.  That was set up.  Years later I came across that
information.
Same thing, just rename it.  That project is still on my list, I can not
even count the number of places that are hardcoded.  Would love to get out
of the S/36 environment, but if it ain't broke...  (Not intending to open a
can of worms so...   Just venting a bit.  No reply needed).


On Tue, Jun 29, 2021 at 1:58 PM Rob Berendt <rob@xxxxxxxxx> wrote:

> Periods in the library name was a popular thing on the S/36.
> Granted the commands were different but you couldn't do a SAVLIB LIB(ERP*)
> unless the libraries began with ERPperiod.  That's the general gist of it
> anyway.
>
> If you don't like having to double quote the libraries, then rename them.
> No small task but not out of the realm of possibility.
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  7310 Innovation Blvd, Suite 104
>           Ft. Wayne, IN 46818
> Ship to:  7310 Innovation Blvd, Dock 9C
>           Ft. Wayne, IN 46818
> http://www.dekko.com
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Howie, Bill
> Sent: Tuesday, June 29, 2021 1:22 PM
> To: midrange-l@xxxxxxxxxxxxxxxxxx
> Subject: ACS Run SQL Script - Using library names with periods
>
> CAUTION: This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
>
> Hello all,
>
> I'm trying to use the ACS Run SQL Script function.  I have a library that
> I'm trying to query something in that has a period in the middle of the
> name, in the format "XXX.XXXXX".   For the life of me I can't get it to
> work properly, either by using the library name explicitly in my SELECT
> statement or even after going into the JDBC configuration and putting the
> library in the library list there.  Any suggestions?
>
> [Related image]<https://www.hc-companies.com/>Bill Howie
> Senior ERP Programmer/Analyst
> Direct: 330.487.3739 | Cell: 330.888.8085 | Toll Free: 800.225.7712
> 2450 Edison Blvd, Suite 3, Twinsburg OH 44087
> hc-companies.com<https://www.hc-companies.com/>
> Leader in Horticultural Containers
> [cid:image003.png@01D76CE9.C7472FB0]<
> https://www.linkedin.com/company/the-hc-companies>
>  [cid:image004.png@01D76CE9.C7472FB0] <
> https://www.facebook.com/HCCompanies/>
> [cid:image005.png@01D76CE9.C7472FB0] <
> https://www.instagram.com/hccompanies/>
> [cid:image006.png@01D76CE9.C7472FB0] <https://twitter.com/hc_companies>
>
> Disclaimer
>
> The information contained in this communication from the sender is
> confidential. It is intended solely for use by the recipient and others
> authorized to receive it. If you are not the recipient, you are hereby
> notified that any disclosure, copying, distribution or taking action in
> relation of the contents of this information is strictly prohibited and may
> be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
> automatically archived by Mimecast Ltd, an innovator in Software as a
> Service (SaaS) for business. Providing a safer and more useful place for
> your human generated data. Specializing in; Security, archiving and
> compliance. To find out more visit the Mimecast website.
> --
> 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@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.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@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com