Open Studio for Big Data
Open Studio for Data Integration
Open Studio for ESB
This syntax cannot span lines. The following list points out what you can do with this syntax and what you should pay attention to.
-
It can be used to generate the value of any existing parameter. The generated value should not be enclosed by quotation marks.
-
No space char is allowed after
</or before/>. -
Inside this syntax, the
<%...%>or<%=...%>syntax should not be used.
The statement written in the below example is a valid one.
#sql sentence
DROP TABLE temp_</TABLE_NAME/>;The statement identifies the TABLE_NAME parameter and then removes the corresponding table.
For more information on the <%...%> syntax, see The <%...%> syntax.
For more information on the <%=...%> syntax, see The <%=...%> syntax.
The following sections present more specific code used to access more complicated parameters.
Parameters that the SQL templates can access with this syntax are simple. They are often used for connection purpose and can be easily defined in components, such as TABLE_NAME, DB_VERSION, SCHEMA_TYPE, etc.