omit 2 days old data from current date in Sort.

Post by **Neeraj N** » Wed Oct 31, 2018 9:38 am

Hi,

I need to omit records using sort card after a full unload of db2 table. Date field is character x(10). What would be the omit condition for that? Condition is omit 2 days old data from current date, how can I do that in SORT?

Post by **nicc** » Wed Oct 31, 2018 11:59 am

What have you tried so far? What was the result? What was the problem with the result?

Post by **Chandan Yadav** » Wed Oct 31, 2018 1:46 pm

If you are doing a table unload , why can't you exclude the records during unload itself by tweaking the DB2 query to select only last 2 days data?

Post by **Neeraj N** » Thu Nov 01, 2018 5:10 pm

Chandan Yadav wrote: ↑Wed Oct 31, 2018 1:46 pmIf you are doing a table unload , why can't you exclude the records during unload itself by tweaking the DB2 query to select only last 2 days data?

This suggestion looks good, will try it.

Mainframe, MVS and zOS Discussion

omit 2 days old data from current date in Sort.

omit 2 days old data from current date in Sort.

Re: omit 2 days old data from current date in Sort.

Re: omit 2 days old data from current date in Sort.

Re: omit 2 days old data from current date in Sort.

Create an account or sign in to join the discussion

Create an account

Sign in