Temporary Tables in IBM Informix

Milton Guevara · Post by **Milton Guevara** » Thu Nov 20, 2008 9:42 am

I have a report to Informix which must be run in two steps: first create a temporary table with data from a previous query and then the report must collect the temporary table for use in the same report.
Any idea as i can do this in stimulsoft?

Thank you
Milton

Post by **Edward** » Fri Nov 21, 2008 1:38 am

Hello, Milton.

I see only one way how your report could be created.
1) You create a stored procedure and prepare the temporary table there as you need. This procedure must return all necessary columns.
2) There are limitations on using of stored procedures in Stimulsoft Reports.
- Number of Columns is fixed.
- For the stored procedures with variable number of columns 'Retrieve Columns' button will not work and you have to add columns for such a procedure 'by hand' in the DataSource Editor.

Thank you.

Milton Guevara · Post by **Milton Guevara** » Fri Nov 21, 2008 8:29 am

Edward, thank you for your help.

Milton

Post by **Edward** » Fri Nov 21, 2008 9:38 pm

Please let us know if any help is required.

Thank you.