Eclipse Community Forums: BIRT

Home » Archived » BIRT » DB2 query

Fri, 20 July 2007 10:47

Eclipse User

Originally posted by: alvin_yeung.otpp.com

I am trying to write a DB query in BIRT that look like this

SELECT *
FROM DBADMIN.TABLENAME AS TABLENAME
WHERE TABLENAME.OBJECTNAME LIKE '%?%'.

Basically, this query should return rows in TABLENAME.OBJECTNAME that
contain my BIRT Report Parameter.

However, eclipse editor do not recognize '%?%' contain any parameter.

How do I do this?

Thanks. Any help is appreciated.

Re: DB2 query [message #249190 is a reply to message #249171]

Fri, 20 July 2007 11:15

Eclipse User

Originally posted by: monicaerbes.trascender.com.ar

you can try with :

SELECT *
FROM DBADMIN.TABLENAME AS TABLENAME
WHERE TABLENAME.OBJECTNAME LIKE '%'||?||'%'

Luck

"alvin" <alvin_yeung@otpp.com> escribi

Previous Topic:	Date/Time axis label localization issue
Next Topic:	BIRT & Actuate BIRT

Goto Forum:

-=] Back to Top [=-

Current Time: Mon May 05 03:39:56 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter