Buck Calabro is all of it. His way is exactly how I output my results.
Depending on what our users what, they can output as a text file or
an Excel SS. If my systems were up, I'd take a closer look at the options.
My systems are down this morning. Moving from a Power 8 S814
with 2 partitions to 2 Power 10 S1014's with 4 partitions and NVMe
storage.
Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
IBM i Personal Blog:
https://ibmireference.blogspot.com<
https://ibmireference.blogspot.com/>
"Success is not final. Failure is not fatal. It is the courage to continue that counts".
From: Michael Mayer
Sent: Saturday, May 20, 2023 12:31 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: RE: STRSQL command question
Buck Calabro is all of it. His way is exactly how I output my results.
Depending on what our users what, they can output as a text file or
an Excel SS. If my systems were up, I'd take a closer look at the options.
My systems are down this morning. Moving from a Power 8 S814
with 2 partitions to 2 Power 10 S1014's with 4 partitions and NVMe
storage.
Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
IBM i Personal Blog:
https://ibmireference.blogspot.com<
https://ibmireference.blogspot.com/>
"Success is not final. Failure is not fatal. It is the courage to continue that counts".
Today's Topics:
1. STRSQL command question (DEnglander--- via MIDRANGE-L)
2. Re: STRSQL command question (Buck Calabro)
3. Re: STRSQL command question (VERNON HAMBERG Owner via MIDRANGE-L)
----------------------------------------------------------------------
message: 1
date: Fri, 19 May 2023 14:53:50 -0500
from: DEnglander--- via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
subject: STRSQL command question
When you use the STRSQL green screen command, you can press F13 and use
option #1 to change session attributes. The second Attribute that can be
changed is sending output to Display, Printer, or File.
Does anyone know if Run SQL Scripts window has the same feature? We were
looking to have the results of a SQL statement be sent to an Outfile this
way, instead of adding an Insert into before the Select. From what I am
told the select is quite large.
Thank you,
Doug
------------------------------
message: 2
date: Fri, 19 May 2023 16:13:40 -0400
from: Buck Calabro <kc2hiz@xxxxxxxxx<mailto:kc2hiz@xxxxxxxxx>>
subject: Re: STRSQL command question
On 5/19/2023 3:53 PM, DEnglander--- via MIDRANGE-L wrote:
When you use the STRSQL green screen command, you can press F13 and use
option #1 to change session attributes. The second Attribute that can be
changed is sending output to Display, Printer, or File.
Does anyone know if Run SQL Scripts window has the same feature? We were
looking to have the results of a SQL statement be sent to an Outfile this
way, instead of adding an Insert into before the Select. From what I am
told the select is quite large.
I'm using the ACS Run SQL Scripts program on Windows.
I have mine set to open a new window with the results.
That window has File > Save as (Ctrl-S) which lets me save results to
Excel, etc.
Settings that affect this are in Edit > Preferences > General - Enable
saving of results (at the bottom), and also Edit > Preferences > Results
--
--buck
http://wiki.midrange.com<
http://wiki.midrange.com>
Your updates make it better!
------------------------------
message: 3
date: Fri, 19 May 2023 15:56:04 -0700
from: VERNON HAMBERG Owner via MIDRANGE-L
<midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
subject: Re: STRSQL command question
Hi Doug
We don't have those options in RSS. The closest I know of is to enable saving results - that's a setting on the General page of Preferences. This saves to a file on the PC, or various types, XLSX, CSV, TXT, and a few more.
Maybe for output to an outfile you can use the Create Table using the SELECT as the source of the data - not the most direct way, I suppose.
Cheers
Vern
On Fri, 19 May, 2023 at 2:53 PM, DEnglander--- via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: DEnglander@xxxxxxxxxxxxxxx<mailto:DEnglander@xxxxxxxxxxxxxxx>
When you use the STRSQL green screen command, you can press F13 and use
option #1 to change session attributes. The second Attribute that can be
changed is sending output to Display, Printer, or File.
Does anyone know if Run SQL Scripts window has the same feature? We were
looking to have the results of a SQL statement be sent to an Outfile this
way, instead of adding an Insert into before the Select. From what I am
told the select is quite large.
Thank you,
Doug
The information in this email may be confidential. It is intended only for the person(s) named above. If you are not the intended recipient, please notify the sender and do not review, distribute, or duplicate this email.
midrange.com
