Re: Speaking of best practices, I've got one for anyone using SQL Stored Procedures to call RPG programs...

We really don't have a need to use our stored procedures within the RPG.
We generally use then for our web-apps.

But, we've really enjoyed it, because 1) we no longer need to re-compile
the S/Ps if a new param needs to be added, and 2) all our S/Ps
have the same signature. So, it's easier to build a singlular RESTful
data access object in our Java, since everything is called the same.

David

David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com



Bryce Martin <BMartin@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/01/2010 08:18 AM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Speaking of best practices, I've got one for anyone using SQL Stored
Procedures to call RPG programs...






hmmm.... i'll have to look at that....how well does that work if you need
to use the stored procedure with RPG?


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



dmosley@xxxxxxxxxx
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/30/2010 11:29 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
cc
"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>,
rpg400-l-bounces@xxxxxxxxxxxx
Subject
Re: Speaking of best practices, I've got one for anyone using SQL Stored
Procedures to call RPG programs...






Thanks, Alan.

That was what I was trying to see if anyone else was doing, or if there
was any other methods that I hadn't thought of.

We have really pushed the XML-INTO and XML-SAX usage, because we pass all
of our parameters in via one single parameter.

David

David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com



Alan Campin <alan0307d@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/30/2010 05:33 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Speaking of best practices, I've got one for anyone using SQL Stored
Procedures to call RPG programs...






You could use XML. Just have a character string and pass the XML statement
created in Java. If you are passing a lot of parameters or variable
parameters, much better solution.

On Tue, Nov 30, 2010 at 3:10 PM, Mark Murphy/STAR BASE Consulting Inc. <
mmurphy@xxxxxxxxxxxxxxx> wrote:

Such as?

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx

-----rpg400-l-bounces@xxxxxxxxxxxx wrote: -----
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
From: dmosley@xxxxxxxxxx
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
Date: 11/30/2010 05:03PM
Subject: Re: Speaking of best practices, I've got one for anyone
using SQL Stored Procedures to call RPG programs...

Nope, I'm just referring to Stored Procedures. We're not doing anything
with embedded SQL in our java, and have simply relied 100% on
stored procedures, to wrapper around our business logic.

I'm just curious if anyone is doing something different than the same

ol'

IN/OUT variables for every parameter to be passed in.

David

David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com



Paul Holm <pholm@xxxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/30/2010 04:34 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
Re: Speaking of best practices, I've got one for anyone using SQL Stored
Procedures to call RPG programs...






dmosley@xxxxxxxxxx wrote:

Just wanted to get an idea of how everyone builds thier stored

procedure's

IN/OUT parameters.

Do you build an IN parameter for each and every field you want to pass

in,

or do you do something else?

Thanks
David


David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com

SQL versus Stored procedures: The declaration of IN/OUT Parms does
"seem" to be a significant difference. With SP, you have to manually
declare/size each and every parameter then have separate code to
process each and every end user query. With dynamic/prepared SQL you can
enable better reuse/productivity. Best practice: Use PHP/Java based
SQL for most cases where SQL can solve the problem otherwise consider a
stored procedure.

Thanks, Paul Holm

--

This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--

This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.