Re: SQL Question

[Bryan Dietz <bdietz400@xxxxxxxxx>]

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 ?