Hi everyone, I am loading data from DB2 into SQl tables. So evrytime i need to get 10 days worth of data..so my where condition is CREATED_DATE > (current date - 10 days) Is it possible to take noof days as variable and i can modify this condition as beloow like how we do in SQL. CREATED_DATE > (current date - ?) Please let me know. Thanks, Jyo

Yes use Query from variable option as explained in Jamie's Blog http://consultingblogs.emc.com/jamiethomson/archive/2005/12/09/2480.aspxShailesh , Please mark the post as answered if it answers your question.