Where clause in preceding load

[#1]

Hello everyone,

I would like to find out if I can use the "Where" clause  in preceding load statement to filter date?

Thanks

[sdmech81]

Hi,

Create a variable say: Vdate= so n so

Then

Load A,

B,Yourdate where Yourdate>=$(Vdate);

sql select * from so n so table;

Sachin

[Peter_Cammaert]

Yes, you can. But that's often considered bad practice.

Be careful.