Re: C++, SQLCLI: Making a remote DB2 connection

Hi Kelly,
WRKRDBDIRE is definitely a must, but this is not enough - as this, AFAIC, does not "explain" how to reach this external location.
If I'm not mistaken it uses the same facility like passthrough and SAVRSTxxx.
It should then require some iSeries administration. To find what exactly to do, google for "How to encapsulate SNA over TCP".
And before you start programming, check that access to remote location works - by starting interactive SQL and issuing something like
CONNECT TO <remote_name>.

Jevgeni.



-----Original Message-----
From: c400-l-bounces@xxxxxxxxxxxx [mailto:c400-l-bounces@xxxxxxxxxxxx] On Behalf Of marc
Sent: Thursday, February 20, 2014 11:33 PM
To: Bare Metal Programming IBM i (AS/400 and iSeries)
Subject: Re: [C400-L] C++, SQLCLI: Making a remote DB2 connection

Hi Kelly,

When I connected from a linux box, the basic philosophical gist was:

- Make sure your db2cli.ini has a system defined with the proper database name, ip, port, etc.
- Use that name as the second parm to SQLConnect, along with valid credentials
- Profit?

Never tried from CLI from IBM i to IBM i - WRKRDBDIRE might come into play?

Sorry, not terribly helpful - but maybe some places to start digging.

Marc

On 2/20/2014 7:38 AM, Kelly Beard wrote:

How is this done? A long time ago I learned enough SQLCLI to create a
minimalist C++ class wrapper for some stuff, so I don't know enough
about how to make a connection to another machine. Any help?

--
This is the Bare Metal Programming IBM i (AS/400 and iSeries) (C400-L) mailing list To post a message email: C400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/c400-l.