Skip navigation
Contact Us
7896 Views 4 Replies Latest reply: Sep 30, 2012 11:22 AM by Mahaveer Singh RSS
Mohankumar Viswanathan Newbie 2 posts since
Oct 16, 2004
Currently Being Moderated

Feb 23, 2007 7:09 AM

Dynamic SQL in source qualifier


I need to build my source qualifier query like

select * from tablea where $$mapparm1

here $$mapparm1 is a mapping parameter which might have where condition value like (Col1 = 1) or (col1>1 ).

Is this possible.. i mean building the dynamic SQL and running by using something like Exec command.


More Like This

  • Retrieving data ...

Bookmarked By (1)