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

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