SQL Output Format Into-Entity Syntax
| <into-entity> | ::= | <table_name> |
If the specified table does not already exist, the SQL
output format creates a table with as many columns as the number of fields in the
SELECT clause of the query. In this case, the SQL type of
each column is determined by the data type of the
corresponding output record field, as described in
Column Type Mappings.
If the specified table already exists, the number of columns in the table must match
exactly the number of fields in the SELECT clause of the query, and the SQL type of each
column must be compatible with the data type of the output record field in the same
position, as described in Column Type Mappings.
Examples:
INTO ReportTable