Re: IBM SQL to find Groups failing on HTTP 403

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

What error are you getting?  Are you trying the Run SQL Scripts example in
STRSQL?
I copied your example into Run SQL Scripts and it works.


On Fri, Mar 8, 2024 at 10:41 AM Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
wrote:

> I’m seeing a 403 failure on the call to :
>
> https://www.ibm.com/support/pages/sites/default/files/inline-files/xmldoc.xml
>
> I’ve tried it on multiple systems and seem to be getting the same thing.
> Is IBM having issues or do I need to look further?
>
> For reference here is the sql I’m using (straight from the examples)
>
>
> With iLevel(iVersion, iRelease) AS
> (
> select OS_VERSION, OS_RELEASE from sysibmadm.env_sys_info
> )
>   SELECT P.*
>      FROM iLevel, systools.group_ptf_currency P
>      WHERE ptf_group_release =
>            'R' CONCAT iVersion CONCAT iRelease concat '0'
>      ORDER BY ptf_group_level_available -
>         ptf_group_level_installed DESC;
>
> We are at V7R4, with reasonably recent groups.
>
> --
> Jim Oberholtzer
> Agile Technology Architects
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.