SELECT ROWNUM=identity(10), id,name
INTO #tmp
FROM emp


Im trying to create a temporary table #tmp by using the above query in SYBASE IQ 12.7. While executing this query an error
"Function not currently supported. --at Query command line :1" was found. Could u please tell me the correct way .