Rajat Sharma
Member
Hi everyone, hope you all are well!
I have couple of question regarding temp-tables. I know these are very basic questions for this forum, for that i did go through “PROHAND” and few other docs that I have but couldn’t conclude anything regarding the same.
1. We have been working with temp-tables (in our shop), but normally we do use temp-tables sharing by using input-output parameters. I read somewhere that, when we pass temp-table by using input-output parameters then progress(AVM) copy the data to called procedure (.p file) and that is a kind of overhead so instead of passing temp-table by input-output parameters we should use BY-REFERENCE or BIND or TEMP-TABLE handle. I have been trying to do/create practical scenarios for that but couldn’t difference between them.
2. Should our sharing techniques (input-output, by-reference, bind, handle, and temp-handle) depends on the kind of sharing like: sharing temp-tables in different procedures (.p files) of single session or multiple session?
3. In many previous threads, I read that we shouldn’t use SHARED TEMP-TABLE are devils (why, please suggest). If yes, then what is the alternative that we should use and is it applicable only to shared temp-tables or we shouldn’t use SHARED anywhere (like: SHARED VARIABLE, STREAMS). Please suggest.
Please suggest or share any document relevant to my issues.
Thanks & Regards!
Rajat.
I have couple of question regarding temp-tables. I know these are very basic questions for this forum, for that i did go through “PROHAND” and few other docs that I have but couldn’t conclude anything regarding the same.
1. We have been working with temp-tables (in our shop), but normally we do use temp-tables sharing by using input-output parameters. I read somewhere that, when we pass temp-table by using input-output parameters then progress(AVM) copy the data to called procedure (.p file) and that is a kind of overhead so instead of passing temp-table by input-output parameters we should use BY-REFERENCE or BIND or TEMP-TABLE handle. I have been trying to do/create practical scenarios for that but couldn’t difference between them.
2. Should our sharing techniques (input-output, by-reference, bind, handle, and temp-handle) depends on the kind of sharing like: sharing temp-tables in different procedures (.p files) of single session or multiple session?
3. In many previous threads, I read that we shouldn’t use SHARED TEMP-TABLE are devils (why, please suggest). If yes, then what is the alternative that we should use and is it applicable only to shared temp-tables or we shouldn’t use SHARED anywhere (like: SHARED VARIABLE, STREAMS). Please suggest.
Please suggest or share any document relevant to my issues.
Thanks & Regards!
Rajat.