Home > IT Answers > AS/400 > Connect to Unix from iSeries
BCL2008
5 pts.
 Connect to Unix from iSeries
RPGLE, SQL, Unix
I am trying to connect to EDW data mart on a Unix server from an SQLRPGLE pgm using the embedded SQL CONNECT TO code. I am getting SQLCOD = -000000113 when in debug and the connection fails. I have the code I can send in an email if you want? BCL2008

Software/Hardware used:
ASKED: October 10, 2008  2:57 PM
UPDATED: August 21, 2010  10:46 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The “code” isn’t much use. What would be useful would be a description of the DRDA setup on your Unix system. If your Unix system has no feature that follows Open DRDA standards, then you don’t have much chance of connecting through a SQLRPGLE program.

Other than DRDA, you’ll probably need Java and whatever Type 4 JDBC driver is supplied by the DBMS vendor for your Unix system. SQLRPGLE won’t be much help there, but RPGLE can fairly easily call your Java program.

Tom

TomLiotta
 108,360 pts.