Dynamic where clause from another table

[sgharrison]

Does anyone know if its possible to take a complete where clause stored in a varchar field on one table and then apply it to a source table as its where clause ?

We wish to store the where clause elsewhere so users can dynamically extract specific data from a table to a sequential file.

Thanks
Scott.

[ray.wurlod]

Don't know if you can do this in Sybase.

In DataStage you will need to select the contents of the VarChar column, load this into a job parameter, and use a reference to that parameter in the WHERE clause in a controlled job.

[Sainath.Srinivasan]

In Sybase, you may need tsql to perform this action. As Ray suggested, you will be better-off doing it in DataStage by including the 'where' clause as a parameter and include it in your source sql selection.