E9.2 WorkTable data delete on UKID and UPMJ

Pranoy

Active Member
Hi All,

I'm working on purging the old worktable orphan records till the date = today's date - 2. I.e. all the records in table where Table.UPMJ <= (today's date - 2)

i see that in delete table io we don't have option to use '<=' operator but only '='.

Right now I'm thinking to create a custom section on the worktable selecting the records which are <= (today's date - 2) and then in LBH/LBF I do a delete table io on UKID

any suggestions please?

Thanks,
Pranoy
 
C BSFN and JDEBASE APIs give you a lot more flexibility and can do what you are trying to do.
 
Hi All,

I'm working on purging the old worktable orphan records till the date = today's date - 2. I.e. all the records in table where Table.UPMJ <= (today's date - 2)

i see that in delete table io we don't have option to use '<=' operator but only '='.

Right now I'm thinking to create a custom section on the worktable selecting the records which are <= (today's date - 2) and then in LBH/LBF I do a delete table io on UKID

any suggestions please?

Thanks,
Pranoy
 
Back
Top