Hiya
I've been playing around with start routines and found a way to filter my records but only through hard coding my conditions. I'd rather make this a table driven solution since my requirements will change quite often.
So here is my criteria: I have 2 tables with values that will contain my conditions. One table contains the codes (ZCODE) and the other table contains the sections (ZSECTION). If the records in my data_package does equal any of the values in ZCODE and ZSECTION, it should be deleted. So something like:
delete data_package where ZCODE not in R_ZCODE and ZSECTION not in R_SECTION.
Does anyone know how this might work? I'm not familiar with using range values or how to fill them with data from my 2 tables and then using it to set my conditions to delete the data_package.