Archives of the TeradataForum
Message Posted: Fri, 11 Nov 2005 @ 10:15:04 GMT
| Subj: | | Re: Stored procedures results |
| |
| From: | | David Clough |
First of all, thanks for all the PPI advice.
In terms of Stored Procedures - something I'm currently working with - I have noticed that you cannot retrieve information back from a Dynamic
SQL call. How I get around this slight restriction is to create a Global Temporary table, write the results into that and then use non-dynamic
SQL to get the results back into the Stored Procedure.
This may not be what you're getting at, but it's worth knowing.
Regards,
_______________________
Dave Clough
Database Designer
Express ICS
www.tnt.com
| 
