Re: IBM ACS, SQL0204 error when trying to work with schemas

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Rob,


Found the problem: DELIMIT_NAME is a SQL UDF that appeared (for 7.1) with
SF99701 Level 28. Guess what? Their system *really* is not up to date.


I sent them the IBM link with the Release life cycle info. Hope they take
the hint :-)


Thanks,

Luis

On Tue, May 16, 2017 at 5:04 PM Rob Berendt <rob@xxxxxxxxx> wrote:

> The raw form of SQL0204 is
> Message . . . . :   &1 in &2 type *&3 not found.
>
> You're showing
> “DELIMIT NAME in QSYS2, TYPE *N not found”
>
> To my naked eye it looks like &1 has been replaced with
> DELIMIT NAME
> which implies a special character or some such thing between DELIMIT and
> NAME that your situation is not handling well.
>
> 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:   Luis Rodriguez <luisro58@xxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   05/16/2017 04:23 PM
> Subject:        IBM ACS, SQL0204 error when trying to work with schemas
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> Hi all,
>
>
> A friend of mine, when trying to work with a schema using ACS (latest
> version), is getting a (loosely translated from Spanish) SQL0204 error:
> “DELIMIT NAME in QSYS2, TYPE *N not found”. Their system’s release is 7.1.
> He can see his server name and schemas. It is when he tries to select the
> Schema that he gets the message.
>
>
> Any ideas?
>
>
>
> Thanks in advance,
>
> Luis
>
>
> --
>
> Luis Rodriguez
> --
> 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.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
>
>
> --
> 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.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD