Eclipse Community Forums: BIRT

Home » Archived » BIRT » Procedures

Thu, 23 June 2005 02:47

Eclipse User

Originally posted by: venki.uaeexchange.co.in

Hello All,

Instead of JDBC ODBC driver can we use Jconnect to connect to Sybase and
further can we use stored procedures as source rather than direct select
from table

Thanks
Venki

Re: Procedures [message #50856 is a reply to message #50274]

Thu, 23 June 2005 16:08

Eclipse User

Yes you can use JConnect or any other Sybase JDBC driver. This is in fact
preferred over the Jdbc-Odbc bridge. For more information about configuring
your own JDBC driver please see the BIRT FAQ pages.

BIRT 1.0 has limited support for stored procedures. You can use a store
procedure if it has only input parameters, and returns exactly one result
set. Just type in the store procedure call in the query pane of the JDBC
data set editor (where you will normally put a SELECT statement). More
comprehensive support for stored procedures are planned for the next
release.

Gary Xue
BIRT Committer

"Venki" <venki@uaeexchange.co.in> wrote in message
news:d9dlp6$ecm$1@news.eclipse.org...
> Hello All,
>
> Instead of JDBC ODBC driver can we use Jconnect to connect to Sybase
and
> further can we use stored procedures as source rather than direct select
> from table
>
> Thanks
> Venki
>
>

Previous Topic:	How do I use multiple parameters in BITR?
Next Topic:	Report Parameters

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 09 23:04:59 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter