Re: Embedded SQL to a DDM file

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