× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.


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.


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
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
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


stay connected


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
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

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2023 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.