Re: Using REGEXP_REPLACE (and new weird question) -- MIDRANGE-L

Subject: Re: Using REGEXP_REPLACE (and new weird question)
From: David Gibbs <david@xxxxxxxxxxxx>
Date: Mon, 11 Jul 2022 13:47:53 -0500
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

On Mon, Jul 11, 2022 at 12:48 PM Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

The error seems to indicate the *service program* QSYS/QQQSVREG does not
exist, whereas it certainly does exist on both systems.

SQL State: 42704
Vendor Code: -204
Message: [SQL0204] QQQSVREG in QSYS type *SRVPGM not found. Cause . . . .
. : QQQSVREG in QSYS type *SRVPGM was not found.

Check the joblog for the db2 server job ... the message may not be that the
service program couldn't be found but that the function couldn't be
invoked. I think it's looking for another service program in the QICU
library.

david

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2025 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.