Eclipse Community Forums: BIRT » how to set a database schema ?

Home » Archived » BIRT » how to set a database schema ?

how to set a database schema ? [message #154255]

Wed, 19 April 2006 04:45

Eclipse User

Originally posted by: baylot.ofac.ch

Hi,

I'm working on a DB2 Server.

I need to set my database schema before run my reports.

But I don't know how to run a sql command like 'set current schema PROD'
with Birt.

I need to do that because I have to run birt on differents databases which
have not the same schema.

Thanks,

Lionel

Re: how to set a database schema ? [message #155096 is a reply to message #154255]

Fri, 21 April 2006 04:01

Eclipse User

Originally posted by: esteban27.free.fr

Hello,

have you tried this command on the 'beforeOpen' DataSource's script ?

queryText="set current schema PROD";

Bye,

Steph

Re: how to set a database schema ? [message #155184 is a reply to message #155096]

Fri, 21 April 2006 07:27

Eclipse User

Originally posted by: baylot.ofac.ch

I have tried this method and it has no effects :o(

I haven't got any errors but this code has no effects

Thanks for your help :o)

Lionel

Previous Topic:	BIRT RPC
Next Topic:	Showing only a part of a line series?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 18 03:17:25 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter