Sybase dataset

When I used sql to get data from sybase it does, but if i use temporary tables and then I select from that table I can not get any resultset, even the table has rows.

What I missing? or What I have to do to get the result set from the temporary table.

Thanks.

David

Find more posts tagged with

Comments

rmurphy

What is creating the temp tables? If it is another process or connection, have they been committed before performing the query?

Rob

shah_east

Hello,
I am just started using Birt with sybase. We are using adaptive server 12.5.2. I've noticed the following pecularities when trying to call stored procedures when trying to create a dataset.

If the procedure has no input parameters, the only way that I have been able to get it to work by using the "SQL Query" option when creating the dataset (as opposed to stored procedures) and using "execute" rather than call. The results are returned fine in the preview.

If there are input arguments, then I cannot use the sql query option, but am forced to use the "stored procedure" option "call ****(?,?,?), however in that case nothing is returned when I preview the results (I use default values for inpute data). The output columns are also not populated with names.

Has anyone had any luck using sybase with birt correctly?