0 Replies Latest reply: Nov 6, 2013 9:01 AM by 650567 RSS

    How to drop a temp table in bi publisher

    650567

      Hi

       

      We are using Bi publisher 10g with sybase and we have a query which uses temporary table

       

      Below is the sample T-sql query

      Ex :

       

      Select column1,column2 into temp_table from table1

      Select column1 from temp_table

      drop 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