Re: DDM file between v7r3 and v5r4

[Steve McKay <samckay1@xxxxxxxxx>]

Do the DDM attributes match between both systems?

Is the DDM server stated on both?

On Mon, Dec 23, 2019 at 5:09 PM Peter Dow <petercdow@xxxxxxxxx> wrote:

> This involves two machines, one running v7r3, the other v5r4.
>
> I was trying to determine if I can have an RPGLE program on v7r3 read a
> SQL ALIAS table that points to a remote table.
>
> On v5r4 there's a multi-member file of which I only want a particular
> member.  So on that machine, I created an alias:
>
>   CREATE ALIAS mylib/myAlias for mylib/myFile (myMbr)
>
> On v7r3,
>
>   CREATE ALIAS mylib/myFile FOR rmtv5r4/mylib/myAlias
>
> So far so good.  On v7r3, a "SELECT * FROM mylib/myFile" returns the
> records from myMbr on the remote v5r4 machine.
>
> I wrote RPGLE program TESTALIAS on v7r3 which reads the first record
> from myFile, displays the key fields, then ends. The first issue was it
> wouldn't compile because it couldn't get the external field definitions
> from myFile.  So I copied the file definition from v5r4 to v7r3 as
> myDefn and used that in the EXTDESC key field on the file spec.  That
> got it compiled.
>
> Here's the fun part.  When I ran it I got some errors:
>
> CALL TESTALIAS
>   [CPI9160] Database connection started over TCP/IP.
>   [CPI9200] DDM object SYSCDEP1 in UTLIB uses remote object UTLIB/SYSCDEM1.
>   [CPF9162] Cannot establish DDM connection with remote system.
>      Cause . . . . . :   An error occurred during distributed data
> management (DDM)
>        initialization while attempting to establish a connection at the
> remote
>        location OCAL 0000.
>      Recovery  . . . :   See previously listed message CPF4364. Correct
> the errors
>        and then try the request again.  If message CPD3E34 is listed,
> see the
>        message listed before it for meaning of error code.
>
> The "Recovery" is interesting because there is no "previously listed
> message CPF4364". However,
>   the "Cause" hints at the problem with "remote location OCAL  0000."
>
> Has anyone seenanything like this?
>
> --
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
> pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /
> --
> 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@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com