Eclipse Community Forums: BIRT » BIRT Dataset Usage

Home » Archived » BIRT » BIRT Dataset Usage (Is it possible to pass entire dataset into the IN CLAUSE of another Data set)

BIRT Dataset Usage [message #1243860]

Tue, 11 February 2014 09:50

Eclipse User

My requirement is to get the list of ids from one database suppose sybase and then I wish to pass this list of ids to another database for processing using NOT IN clause in the sql query.

For example: I have two separate database. I will get the records from one db in one data set and then pass the entire records to another data set.

select * from second_table where id not in (select id from first_database_table)

Re: BIRT Dataset Usage [message #1243944 is a reply to message #1243860]

Tue, 11 February 2014 12:27

Eclipse User

Moving this to the BIRT forum.

Previous Topic:	Slot ID in BIRT
Next Topic:	Birt on windows mobile

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 23:35:17 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter