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);