DSXchange

Hi,

I want to fetch records from a table 'A' based on a condition-
where A.field > B.field . B is another table.
What stage can be used to apply this filter.

Thanks in Advance

If A and B are in the same schema, I would do it in the original SQL where you select your records. That would be the fastest, most efficient method.

Wouldn't even have to be in the same schema, the same database would do. Heck, doesn't even need to be that.

use the odbc stage..

create a dummy seq file with a dummy column which reads data from a dummy file with any value just to create an input link to the odbc stage.

seq file ----> odbc

in the odbc stage , choose user defined sql and u r ready to rock and roll !

Just add the appropriate WHERE clause to the link properties in your database stage - probably on a tab called Selection.