Archives of the TeradataForum

Message Posted: Tue, 20 Jan 2009 @ 15:12:58 GMT

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

Hi,

I am trying to convert oracle procedure to teradata procedure.

I need teradata equivalent for

     CURSOR%NOTFOUND
     SQL%ROWCOUNT

and syntax for * 'for loop'* inside procedure

Oracle loop:

     For i = 0...diffvalue

diffvalue is variable.

I need a Teradata equivalent loop syntax for it.

Thanks in advance.

Regards,

Ragavendran

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