|
Thanks Dave for the explanation. A while ago Jim Mason mentioned that Runtime.exec() could also be used to call RPG programs. It would be interesting to know how this is done. Can somebody give an example? A few references would help too. Thanks. Bruce -----Original Message----- From: Dave Wall <dawall@us.ibm.com> To: JAVA400-L@midrange.com <JAVA400-L@midrange.com> Date: Wednesday, April 04, 2001 4:22 PM Subject: Re: ProgramCall and ProgramParameter classes > >I think the important considerations are: > >1) How familiar are you with JDBC. If you are already an expert at JDBC >then using JDBC procedure call is a natural way for you to call the >program. If you don't know anything about JDBC but are already using some >other Toolbox component then you may go with ProgramCall just because that >is an interface you are used to. If you don't know either then you have to >learn one. I think ProgramCall is easier but that is just my opinion. > >2) Complexity of the buffer. Those of you who use AS/400 APIs know the >input and output buffers of many APIs are obviously created by committee. >They can be very complex with their multiple repeating variable length >structures. For these types of buffers PCML is the way to go. In a text >file you define the generic layout of the buffer. At run time PCML does >all the messy math to address into the buffer to pull out fields. PCML is >a little slower, however, so if your buffer is simple PCML may not be worth >the performance hit. > >3) If correctly written, the performance of ProgramCall vs JDBC is about >the same, with PCML being a little slower. Of the two, ProgramCall should >be slightly faster just because there is less overhead on the client and >server, but if your program takes any time at all you may not see a >difference. In either case connect time is significant. If you need to >call a program more than once you should use the same connection. Toolbox >in JTOpen 2.02 has connection pooling to help you reuse connections for >both JDBC and ProgramCall > >I look foward to see the performance numbers some of you are gathering, to >see if they match my number that ProgramCall is slightly faster. > >David Wall >AS/400 Toolbox for Java > > >"Bruce Jin" <brucej@MRC-PRODUCTIVITY.COM>@midrange.com on 04/04/2001 >08:53:10 AM > >Please respond to JAVA400-L@midrange.com > >Sent by: owner-java400-l@midrange.com > > >To: <JAVA400-L@midrange.com> >cc: >Subject: Re: ProgramCall and ProgramParameter classes > > > > >I really wish to know the advantages/disadvantages in using JDBC procedure >calls versus using Toolbox if my task is only to call RPG, CL, COBOL, and >REXX from Java. > >Thanks. > >Bruce > +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.