Sybase IQ 12.6 allows you to create a permanent base table when you select into more than one column and do not use the #table variable.
As in previous releases, SELECT... INTO #table always creates a temporary table regardless of the number of columns, and SELECT... INTO table with just one column selects into a host variable. For details, see Chapter 6, “SQL Statements” in Sybase IQ Reference Manual.
