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