Hi there everybody,i'm trying to schedule some data load procedures in PAS Administrator, but i need to filter the loaded data by month and year in order to load only the new data at the moment the procedure runs(monthly),this means that if my procedure runs on may 2014 for example, the query returning the data and the SET PERIOD instruction in the load procedure need to be parametrized to retrieve and load only data corresponding to may 2014. I'm trying multiple ideas but i'm not getting the expected result.Does anybody can give me any advice of how to accomplish this? is there any way to get the system year and month and use it as a parameter to my querys and SET PERIOD instructions?? I hope anybody can help me, this will be very helpful to me!
Greetings from Guatemala!