Netezza GOTO statement

347 Views Asked by At

I have a specific query. Can we implement GOTO logic in Netezza Stored Procedure. I need to implement a labelled block inside a netezza procedure. Then I want to execute a GOTO statement from inside the same procedure, which will jump and execute the labelled block. Can we achieve that. If possible, how?

1

There are 1 best solutions below

0
ScottMcG On BEST ANSWER

As of version 7.2, NZPLSQL does not support GOTO. The control structures it does support include:

  • IF-THEN-ELSE
  • LOOP
  • WHILE
  • FOR
  • EXIT