MVSFORUMS.com

[bakul]

When calling a stored procedure, if parameters are passed using host variables,how does the stored procedure actually receive them.Is an SQLDA structure created in that case?
I ask this question because I found conflicting information on the websites.
One website states that an SQLDA structure is created whenever a stored procedure is called and another says that SQLDA structure is used only when parameters are passed using SQLDA structure.

[kolusu]

bakul,

A stored procedure is works like as it it is a sub-routine. The parms you send are received in the linkage section. And if you look at the PROCEDURE DIVISION statement of a storec procedure, you will notice that you have a USING clause which essentially refers to the linkage section.

And where SQLDA come from? Unless your stored procedure is using dynamic sql, I don't see a reason as to why you need SQLDA

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[bakul]

Yes it does help!
Thanks a lot!