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.
On Mon, Jul 11, 2022 at 10:22 AM Stephen Landess <
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
*JACK WOEHR, IBM Champion 2021-2022
*SENIOR IBM i ENGINEER*
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.