Re: Embedded SQL to a DDM file

[Evan Harris <auctionitis@xxxxxxxxx>]

Hi Tom

I'm a bit unclear on the specifics here, but you could perhaps create a
user profile on the remote system with the required authority
then do an ADDSVRAUTE for each of your local users and point them all to
that same user on the remote system.
ADDSVRAUTE   USRPRF(LOCALUSER)  SERVER('RMT_SVR')
 USRID('NEW_RMTPRF') PASSWORD('xxxxx')


On Sat, Mar 13, 2021 at 4:26 AM Tom Deskevich <TDeskevich@xxxxxxxxxxxxxxxxxx>
wrote:

> Thank you to everyone for your input.
>
> I can run an SQL manually that points to the DDM file as long as it is
> setup with RDB. It does not work using embedded SQL.
>
> The users all sign on under a group profile,  but I cannot do an
> ADDSVRAUTE because I do not know the password of the group profile.
> With turnover here, nobody else would know the password either, I hesitate
> to change it.
> I have to qualify the SQL with the name of the local DDM library. But when
> I do that, it fails with an authorization error.
> The other DDM files open with no problem, just when I attempt the SQL it
> fails.
>
> I guess I am Sorta Outa Luck.
>
> DDM object XXXPY80P in CLNPYLIB uses remote object IC1PYLIB/XXXPY80P.
> Database connection started over TCP/IP.
> Database connection ended over TCP/IP.
> Authorization failure on DRDA/DDM TCP/IP connection attempt.
> Authorization failure on distributed database connection attempt.
> Authorization failure on distributed database connection attempt.
> Cursor C1 not open.
> Cursor C1 not open.
>
>
>
>
>
> Harriscomputer
>
> Tom Deskevich
> Programmer/Analyst
>
> P: 814-472-6066 x201134
> F: 814-472-5019
> E: TDeskevich@xxxxxxxxxxxxxxxxxx
>
>
> [cid:HLG_logo_14bd0fcf-3182-4b52-9120-a2e250d74b09.jpg]
>
>
> 172 Gateway Road PO Box 568
> Ebensburg, Pennsylvania
> 15931
> www.harrislocalgov.com<http://www.harrislocalgov.com>
>
>
> This message has been sent on behalf of a company that is part of the
> Harris Operating Group of Constellation Software Inc.
>
> If you prefer not to be contacted by Harris Operating Group please notify
> us<http://subscribe.harriscomputer.com/>.
>
>
>
> This message is intended exclusively for the individual or entity to which
> it is addressed. This communication may contain information that is
> proprietary, privileged or confidential or otherwise legally exempt from
> disclosure. If you are not the named addressee, you are not authorized to
> read, print, retain, copy or disseminate this message or any part of it. If
> you have received this message in error, please notify the sender
> immediately by e-mail and delete all copies of the message.
>
>
>
>
> --
> 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.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com