Re: TR 11 updates for V7R1

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.