Re: What causes "Database connection started" (CPF9160)

A STRSQL cmd from green screen command line opens with
"Current connection is to relational database S786C5B0".message
(message id is SQL7971) and it identifies how it made the connection.

I think the OP's issue is when a normally working job with a SQLRPGLE
program sometimes fails with the CPF9160 and it is that msg id text
mentions DDM (when OP indicates this is not a DDM job).

Message ID . . . . . . . . . : CPF9160
Message file . . . . . . . . : QCPFMSG
Message . . . . : Value not allowed for &2, macro &1.
Cause . . . . . : The value for keyword &2 is not allowed for the
distributed data management (DDM) internal macro &1, resulting in an
internal DDM error.

Hopefully i quoted the OP correctly..

Jim Franz


On Mon, Nov 11, 2024 at 11:15 AM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

I haven't been following this thread very closely, but something occured
to me when it first began:

In most SQL implementations (e.g., MySQL) there is (if memory serves me
correctly) *always* a client-server relationship, and a "connection,"
even if the client and the server are running on the same machine. In
fact, I think even on a small database I have in LibreOffice Base, on my
personal desktop Linux system, that uses a single file in a ZIP archive
to store a full SQL-based relational database, still has a "connection,"
because LibreOffice Base can also "connect" to a number of other
database servers (maybe even DB2/400?).

Could *that* be what the OP is seeing? A "connection" that only exists
as an SQL connection?

Or am I sucking antimatter?

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