If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Put a Filter -- PL&SQL or not ?

Started by tamise, 07 Mar 2014 01:47:37 PM

Previous topic - Next topic

tamise

Hello,

I want to filter a table with a WHERE clause (PAYS='France' and VILLE ='Paris' ) , but I want to put the filter in a table.
I have a table which  contain a filter. It looks like :
--------------------------------------------------------------
l                   FILTER                                                l
---------------------------------------------------------------
l  PAYS='France' and VILLE ='Paris'                       l
---------------------------------------------------------------

So at the end, I want to filter the table TABLE_FINAL as :
delete from TABLE_FINAL where = PAYS='France' and VILLE ='Paris' .

But the issue is that i cannot to do this : Can i use PL&SQL or not ?
Because the problem is that i obtain :  delete from TABLE_FINAL where = 'PAYS='France' and VILLE ='Paris''

Thanks