MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » November 2000

FW: FW: AS400 Question.


  • Subject: FW: FW: AS400 Question.
  • From: David Glick <DGlick@xxxxxxxxxxxxx>
  • Date: Wed, 15 Nov 2000 13:38:56 -0800

fixed

Further information regarding the question of connecting to the AS400 DDM
server.  Thanks again.

David Glick
Vice President, Integration Services
DATASKILL, Inc
858-755-3800
dglick@dataskill.com


> -----Original Message-----
> From: Romeo Maclan 
> Sent: Tuesday, November 14, 2000 1:51 PM
> To:   David Glick
> Subject:      RE: FW: AS400 Question.
> 
> I'll rephrase my question to this:
> 
> How can I call  stored procedures in the AS400 thru the AS400 DDM server
> using the AS400 Toolbox for Java stored procedure APIs.
> The  Java program resides in a Sun Solaris client machine. The stored
> procedure and DDM server are in the AS400.
> MY code to call a stored procedure :
> /* this code connects to the AS400 */
>       try {
>               java.sql.DriverManager.registerDriver(
>                       new com.ibm.as400.access.AS400JDBCDriver()); 
>               dbConnect = 
>                       java.sql.DriverManager.getConnection(
>                               "jdbc:as400://" + systemName, userid,
> password); 
>       } catch (java.sql.SQLException e) {
>               throw new java.io.IOException(e.getMessage());
>       }
> /* This code prepares the callable statement*/        
>       CallableStatement aCS = 
>               aCS.dbConnect.prepareCall("CALL
> QGPL.PROCEDURE1(?,?,?,?,?,?,?,?,?,?,?,?,?)"); 
>       /* register the parameters to the stored procedure statements */
> 
>       aCS.registerOutParameter(1, java.sql.Types.CHAR); 
>       aCS.setString(1, "TEST");
> The above code apparently does not call a stored procedure thru the DDM
> server. What Java API
> can I use to call AS400 stored procedure thru the AS400 DDM server.
> 
> 
> 
>  -----Original Message-----
> From:         David Glick  
> Sent: Tuesday, November 14, 2000 1:31 PM
> To:   Romeo Maclan
> Subject:      RE: FW: AS400 Question.
> 
> Romeo,
> 
> Do you want to try publishing a code snippet that doesn't work?
> 
> David
> 
> 
>       -----Original Message-----
>       From:   Romeo Maclan 
>       Sent:   Tuesday, November 14, 2000 1:17 PM
>       To:     David Glick
>       Subject:        RE: FW: AS400 Question.
> 
>       Dave:
>       Thanks for publishing my question.
> 
>       I actually just use  straight JDBC calls. For the driver I use the
> AS400 JDBC driver. 
>       The answer does not help much since all this information can be
> found in the AS400 Toolbox for Java Redbook.
> 
>       Will wait for some more responses.
> 
>       Thanks,
>       Romeo
> 
>                -----Original Message-----
>               From:   David Glick  
>               Sent:   Tuesday, November 14, 2000 1:09 PM
>               To:     Romeo Maclan
>               Cc:     Robert Heavill; Wolfgang Black
>               Subject:        FW: FW: AS400 Question.
> 
>               Romeo,
> 
>               Here's the first response to your question, which raises an
> interesting point:  have you tried using straight JDBC calls to access the
> stored procedures?
> 
>               David
> 
>               David Glick
>               Vice President, Integration Services
>               DATASKILL, Inc
>               858-755-3800
>               dglick@dataskill.com
> 
> 
>               -----Original Message-----
>               From:   kulack@us.ibm.com [SMTP:kulack@us.ibm.com]
>               Sent:   Tuesday, November 14, 2000 11:03 AM
>               To:     JAVA400-L@midrange.com
>               Subject:        Re: FW: AS400 Question.
> 
> 
>               I believe the DDM server is only for record level access to
> files.
>               Stored procedures are accessed by using SQL to access
> tables.
>               SQL is done through the JDBC driver and the database server.
> 
>               Use JDBC, SQL, and the Database server to call stored
> procedures.
> 
> 
>               "Do you believe that my being stronger or faster has
> anything
>                to do with my muscles in this place?" ... "Free your mind."
>               Laurence Fishburne as Morpheus in 'The Matrix'.
> 
>               Fred A. Kulack  -  AS/400e  Java and Java DB2 access, Jdbc,
> JTA, etc...
>               IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
>               mailto:kulack@us.ibm.com   Personal:
> mailto:kulack@bresnanlink.net
>               AOL Instant Messenger: Home:FKulack  Work:FKulackWrk
> 
>               +---
>               | This is the JAVA/400 Mailing List!
>               | To submit a new message, send your mail to
> JAVA400-L@midrange.com.
>               | To subscribe to this list send email to
> JAVA400-L-SUB@midrange.com.
>               | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
>               | Questions should be directed to the list owner:
> joe@zappie.net
>               +---
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact