Re: Anyone using SQLConnect, SQLPrepare, etc...

David

I'd suggest that you not mix regular embedded SQL with the CLI stuff - I believe they use the same structures and will conflict in mysterious ways. Even if that's not the case, they don't play well together in my experience.

This is the only way at this time to get a recordset back from a stored procedure in RPG.

Vern

On 8/16/2010 7:54 AM, dmosley@xxxxxxxxxx wrote:

Hey guys,

I'm just curious to know is anyone is using the c procedures (in RPG) for
ODBC connections and the other SQL procedures.
I've got a great usage for these procedures, and have my beta running....
However, I'm new to these procedures
and am curious of any drawbacks, performance lags, etc, that may change my
mind. Or, (which I'm hoping), that this
is savior of truly dynamic SQL and I'm a fool for not using this in the
past. (haha)

Either way, I'd like to hear back from anyone with experience with these
procedures.

I add the "(in RPG)" statement in my first sentence so to make sure I stay
correct in the forums guidelines.
I did create a c-program to do what I wanted, but was able to duplicate
the whole process in RPG. (yeah).

Thanks in advance to any replies.
David


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

www.dancik.com