SQL

Most of the data delivered by data providers is defined by using SQL stored in the Query property. Sybase IQ ETL supports a modified set of the SQL-92 standard.

If you do not want to get into the details of SQL-92, you can use the built-in Query Designer to draw the query and have the SQL generated for you. If you want to manually write SQL, or copy SQL from existing projects, you can manually specify your SQL for the Query property.