Re: SQL Question

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Evan

There's a special register - CURRENT SERVER - that would gives the 
identity of the server where the statement is running - at least, that's 
what I think it does - give that a try.

Using the view or UDTF will cost more than using one of the many special 
registers.

HTH
Vern

On 7/22/2018 5:41 PM, Evan Harris wrote:
> 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 ?