RE: DDM over TCP/IP password problem.

Thanks for the reply.  I tried what you suggested and it worked (just had to 
put apostrophe's around
the password).

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527


-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of pytel@us.ibm.com
Sent: Monday, November 15, 1999 8:48 PM
To: MIDRANGE-L@midrange.com
Subject: RE: DDM over TCP/IP password problem.


AS/400 as TCP/IP DDM client does not currently support sending password to
TCP/IP DDM server.
However, DB2/400 does support sending  passwords to remote SQL database.
Since they use the same underlying connection you may do the following:
- ADDRDBDIRE on a target system to define *LOCAL database
- ADDRDBDIRE on a client system to define remote database with *IP protocol
- Issue SQL statement from a client job:
     CONNECT TO <remote database name> USER <user> USING <password>
- connection will be authenticated and scoped to activation group
- now you may use record level DDM access (DDM file) to remote system - you
may also use SQL, they will use the same already authenticated connection
- connection will be closed when activation group ends, or is reclaimed, or
you may use RCLDDMCNV to end it.

There is also another way to do it - more information is in AS/400
Information Center:
http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/db2/rbal1mst55.htm
    Alexei Pytel

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---