Hi Jarrell
I migrated from Informix to MS SQL a few years ago and at the beginning I had similar dilemma.
I simply started using"
SELECT col1,col2
INTO #tmp_tbl
FROM some_table;
instead of informix
SELECT col1,col2
FROM some_table
INTO TEMP tmp_tbl WITH NO LOG;
Br,
Mike