Skip navigation
Contact Us
4827 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


Hi,

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 (0)