Reply from kiran bankupally on Apr 17 at 9:07 PM just to summerize.... cursors used in loop statements map to Do-select action Cursors used in Table variables map to Temp Tables Variables map to state records complex conditional statements normally map to peoplecode
| | | ---------------Original Message--------------- From: Ken Duncan Sent: Tuesday, April 17, 2012 5:29 PM Subject: Stored proc -> App Engine and Temp Tables: Right Strategy? I am converting a stored procedure with multiple parts and variables defined to an Application Engine program. It looks to me like a good approach would be to make the parts of the stored procedure each a SQL step and the variable definitions should be turned into temporary tables. Does this sound like a good approach? Thanks. Ken | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment