Re: TR 11 updates for V7R1

[Jack Tucky <jacktucky@xxxxxxxxx>]

Thanks All.  I was able to get it to work using the examples Kevin posted.

On Tue, Oct 25, 2016 at 8:11 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> It was recently covered in this list that some of the services, when they
> first came out in 7.1 had one syntax but later had a different syntax. The
> old syntax should be compatible but is probably undocumented in the newer
> documentation.
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Jack Tucky <jacktucky@xxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   10/24/2016 05: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.