RE: DDM and SQL

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

Vern:

Don't pull too much hair out yet. Matt's situation doesn't seem fully stated 
yet. In this last statement that you replied to, he said "The system that is my 
target is also the system we use DDM files from. The DDM files are using *SNA, 
however."

Okay, target and source are maybe the same. And we're maybe currently speaking 
about "DDM file" and "*SNA". So, we don't care much about RDBEs except maybe 
for rmtlocname(*LOCAL). And if the access is against an actual DDMF rather than 
a 'remote database', we probably aren't talking SQL.

However, if we do mean SQL and *IP and remote, then an RDBE must be entered on 
the source system to determine the route to the remote database (i.e., the IP 
address or host.domain name) _as well as_ on the target system for *LOCAL. 
Then, it must be determined whether DDM security matches between the two 
systems (i.e., what does a prompted CHGDDMTCPA show on both systems?) And if 
passwords are required, has a proper server authentication entry been  added on 
the source system (i.e., does it specify the correct server name in the correct 
format and reference a valid profile and password on the target system?) Then, 
maybe check items such as exit programs to see if any are active and what might 
be allowed/rejected. Then...

IOW, we probably need to know exactly what's been set up and what error 
messages are generated from what operations.

There's probably an answer in there somewhere.

Maybe Matt can comment...

Tom Liotta

midrange-l-request@midrange.com wrote:

>  14. RE: DDM and SQL (Vernon Hamberg)
>
>I'm fizzling out, but here's another stab at this - there ought to be some
>kind of job on the remote system - IIRC - that is the other end of a DDM
>conversation. might be a job log, might be messages in QSYSOPR on the other
>end.
>
>And, to be really crazy, how about trying an *SNA type for the RDBDIRE?
>Shoule (there's that word again) work between 400s.
>
>Vern
>
>At 08:10 AM 10/14/02 -0600, you wrote:
>>Vernon,
>>
>> > Is this the setting on the source, or the target? The machine from which
>> > you are making the request is the source, the remote machine is the
>>target.
>>
>>         The system that is my target is also the system we use DDM files
>>from.  The DDM files are using *SNA, however.
>>         Oh, well.
>>
>>Thank you,
>>Matt Tyler

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at 
http://webmail.netscape.com/