You can choose to skip the statement in error and try the next statement. You can choose to skip all other statements in error. You can also decide to stop the execution immediately.

 

 

Instead of typing each table name, function or procedure into the SQL console, you can simply drag the object and drop it directly into the code. As well as being simpler, it also eliminates error because all delimiters are added (quotes) and fully qualified names including namespaces using in HDI artifacts.

 

 

To check runtime performance, you can open the SQL Analyzer by using the drop-down menu from the red Executive button. A new tab opens and many tools appear to provide you with plenty of data relating to the execution of the statements.