Define SQL Statement dialog
The Define SQL Statement dialog provides an interface to write the SQL statements for the SQL Execute operator, similar to the other
TIBCO Data Science – Team Studio execute
script operators.
To view auto-completion hints while editing the script, press Ctrl+Spacebar.
The output of this operator should be assigned to a table called alpine_sql_output in the SQL script.
The following script is an example of a SQL script used in the SQL Execute operator. alpine_sql_input_1 refers to the data table fed into the SQL operator from an upstream operator, if one is present.
CREATE TABLE alpine_sql_output AS (SELECT "county","state","msa","pmsa","popdensity","pop","popchange","age6574","age75","crime","college", "income","farm","democrat","republican","perot","white","black","turnout" FROM alpine_sql_input_1);