Hope this helps and if anyone else knows how to return sets of data
without stored procedures I'm all ears.
Use data queues and send "end of data set" messages so the queue knows when
it has received all entries. A similar approach would be to make data queue
records as long as possible and "chunk" multiple logical entries onto one
data queue record. Each data queue record would have to have a header area
where you would denote whether there were additional records needing to be
read.
Thoughts?
Aaron Bartell
http://mowyourlawn.com
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On
Behalf Of dnitke
Sent: Wednesday, February 06, 2008 11:42 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] Something to read overlunch: Eclipse IDE in
thebrowser
Hey All,
My choice for calling a program to perform a functions wouldnt be as a
stored procedure, I agree with the other comments. If you expect a dataset
returned then the stored procedure is the way to go since I beleive (note I
dont know for sure) that using JT400 would require some sort of parameters
with array datastructure logic which seems to be more complex then needed.
Hope this helps and if anyone else knows how to return sets of data without
stored procedures I'm all ears.
Don N.
----------------------------------------
From: "Luis Colorado"
<LuisC@xxxxxxxxxxxxxxxx>
Sent: Wednesday, February 06, 2008 6:52 AM
To: "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Something to read overlunch: Eclipse IDE in
thebrowser
So, do you mean that you are thinking about calling RPG programs using
stored procedures?
Well, IMHO you are just adding an extra layer of complexity that you don't
need. You are adding another piece that needs to be created, moved, tested,
maintained and tracked, and, thus, another possible source of errors.
On the other hand, if you think that using JDBC is user than JT400, you
might want to consider creating your own wrapper classes to make your life
easier.
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Thorbjørn Ravn Andersen
Sent: Wednesday, February 06, 2008 12:31 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] Something to read overlunch: Eclipse IDE
in thebrowser
dnitke skrev den 06-02-2008 04:38:
a Rich Client product. The business logic is mostly RPG Stored procedures
mostly because its more effecient (current OS400 of course since V6.1 from
what I have read has more JVM memory for SQL) and it allowed us to re-use
existing logic (some). We use both JDBC to call the stored procedures and
JT400
I'd like to hear your opinion on calling stored procedures as opposed to
doing ProgramCall's. Advantages beyond having easy access through SQL,
disadvantages, ease of debugging.
This is because I am considering if it would be an advantage for us to
investigate this more.
midrange.com
