Re: TR 11 updates for V7R1

Oops, I saw your URL for ACTIVE_JOB_INFO and completely glossed over your
actual query.


If your query was actually meant to be this

SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(RESET_STATISTICS=>'YES')) X

and not

SELECT * FROM TABLE(QSYS2.SYSTEM_STATUS(RESET_STATISTICS=>'YES')) X

your query on 7.1 would actually be:

SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO('YES', NULL, NULL, NULL)) X



For SYSTEM_STATUS, it only takes one parameter, so if the query in you did
mean SYSTEM_STATUS, on 7.1 your query would be this:

SELECT * FROM TABLE(QSYS2.SYSTEM_STATUS('YES')) X


"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 10/24/2016
04:30:51 PM:

From: Kevin Adler/Rochester/IBM@IBMUS
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/24/2016 04:31 PM
Subject: Re: TR 11 updates for V7R1
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

IBM i 7.1 does not support named or default parameters for functions.

You

must code them as positional arguments and fill in all the parameters.

You

can find the default values from the documentation.

See
https://www.ibm.com/developerworks/ibmi/library/i-sql-parameter-
name-default-value/
for more information.

For your example, the equivalent 7.1 call would be:

SELECT * FROM TABLE(QSYS2.SYSTEM_STATUS('YES', NULL, NULL, NULL)) X


"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 10/24/2016
04:18:12 PM:

From: Jack Tucky <jacktucky@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/24/2016 04:18 PM
Subject: TR 11 updates for V7R1
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

I'm supposed to be able to use this @ 7.1

SELECT * FROM TABLE(QSYS2.SYSTEM_STATUS(RESET_STATISTICS=>'YES')) X

But I get this message. "Token => was not valid. Valid tokens: ) ,."

I read here ...
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/

wiki/IBM%20i%20Technology%20Updates/page/QSYS2.ACTIVE_JOB_INFO()%20-%20UDTF

that I have to specify all of the filters at 7.1 but I'm not sure how

to

specify them.

Thanks from a SQL/DB2 for I services

Art
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.