Re: Using REGEXP_REPLACE (and new weird question)

I just saw the manual on SQL messages and codes. No, a column or global
variable not found is vendor code -206. Code -204 means:
SQLSTATE 42704 An undefined object or constraint name was detected .
So this either means that there is a missing SQL function or another needed
object in some service program on that particular partition or box.
Better see your job log and tell what you find related to the above.

Javier

El lun, 11 jul 2022 a las 11:29, Javier Sanchez (<
javiersanchezbarquero@xxxxxxxxx>) escribió:

SQL vendor code -204 is "Column XXXX not found" I think or remember.
See your job log and confirm. There may be a subtle mistake there.

Javiers


El lun, 11 jul 2022 a las 11:25, Jack Woehr via MIDRANGE-L (<
midrange-l@xxxxxxxxxxxxxxxxxx>) escribió:

Okay, the REGEXP_REPLACE question was interesting and I played with that
but that led to a WEIRD QUESTION:

I have two LPARs, A & B.
On A, the query works.
On B, it yields
SQL State: 42704
Vendor Code: -204
Message: [SQL0204] QQQSVREG in QSYS type *SRVPGM not found. Cause . . . .
.
: QQQSVREG in QSYS type *SRVPGM was not found.

The service program on the QSYS/QQQSVREG and its authorities are
apparently
identical on both 7.3 systems.

WT*?

On Mon, Jul 11, 2022 at 10:22 AM Stephen Landess <
steve_landess@xxxxxxxxxxx>
wrote:

Our system is running IBM i 7.3 with the latest PTF's and TR's (PTF's

and

TR's installed in the last 2 weeks).

Jerry Ven recently asked questions about extracting the numeric values
from a character field to use as a key for joining the file to another
file which has a numeric key.

I believe that someone had suggested using the SQL REGEXP_REPLACE scalar
function.

--

*JACK WOEHR, IBM Champion 2021-2022
<https://www.credly.com/users/jack-woehr/badges>*

*SENIOR IBM i ENGINEER*

303.847.8442
jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx
stay connected
<https://www.linkedin.com/company/absolute-performance-inc./>

<https://www.absolute-performance.com/>
www.absolute-performance.com

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain

confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further

distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and

delete/destroy all copies of this communication immediately.
--
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.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com