Monday, November 15, 2010

IReport dynamic table sql

In IReport tool, you can dynamically generate SQL by changing table name.

1) Create parameter for table name. Ex :- $P{tableName}
2) Change IReport SQL as following.

      SELECT * FROM $P!{tableName}

Wednesday, November 10, 2010

limit Resultset size in informix

Use the following SQL to limit the size of the result set in informix. 

SELECT FIRST 1 * FROM orders