Re: SQL Question

if you can run multiple SQL statements, I wonder if the following would
run better:

CREATE or replace VARIABLE sysname VARCHAR(8);
SET sysname=(SELECT varchar(gdes)
FROM QPFRDATA.QAPMCONF where GKEY = (' S'));
SELECT sysname, i.* FROM qiws.qcustcdt i;

Bryan





Evan Harris wrote on 7/22/2018 6:41 PM:

Hi all

I am running some SQL queries to extract data and thought that adding a
"system" column to the extracted would be a good idea, rather than trying
to keep track of it in the file name, or having it hardcoded in the query.

So, for example, I have an SQL Statement as follows:

SELECT INTNUM,
(SELECT HOST_NAME FROM QSYS2.SYSTEM_STATUS_INFO) as SYSNAME
FROM QPFRDATA.QAPMSYSTEM

Which returns a bunch of SYSNAM and INTNUM columns.

My question is, is this the most efficient/best practise way of doing this
? I am wondering if running it this way will cause the query to be
executed
for every row that gets returned.

What other ways are there that might be preferable or more efficient ?

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
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: http://amzn.to/2dEadiD