We are using Bi publisher 10g with sybase and we have a query which uses temporary table
Below is the sample T-sql query
Select column1,column2 into temp_table from table1
Select column1 from temp_table
We are not able to drop the temp_table in bi publisher. We tried using functions to place them in 'After Trigger' of bip but the sybase function does not allow 'Drop' command to be used in it.
Also, Does 'exec' command work on bip?
Can some one please suggest a solution