Archives of the TeradataForum
Message Posted: Fri, 14 Mar 2003 @ 19:32:32 GMT
| Subj: || || Re: Trouble migrating a huge SP to production |
| From: || || Jason Fortenberry |
How did you migrate this SP over? Did you just copy into Queryman and run, use BTEQ, part of a database restore? It sounds like you
probably lost some formatting along the way, and since the SQL syntax in the SP is not verified at SP create time, you don't see these type
errors until you actually call the SP. Perhaps try copying out the SQL part of the procedure and run it in small steps to see where the
error is, if possible.