Available in...
Open Studio for Big Data
Open Studio for Data Integration
Open Studio for ESB
An SQL statement can be any valid SQL statement that the related JDBC is able to execute. The SQL template code is a group of SQL statements. The basic rules to write an SQL statement in the SQL template editor are:
-
An SQL statement must end with
;. -
An SQL statement can span lines. In this case, no line should be ended with
;except the last one.