Netezza GOTO statement

Question

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?

Answer 1

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

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