Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2003 @ 19:32:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hey Bhupesh,

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.

--Jason

	<Prev	Next>		<<First	<Prev	Next>	Last>>