Re: SQL Question

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 ?