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?
omit 2 days old data from current date in Sort.
Re: omit 2 days old data from current date in Sort.
What have you tried so far? What was the result? What was the problem with the result?
Regards
Nic
Nic
-
- Website Team
- Posts: 70
- Joined: Wed Jul 31, 2013 10:19 pm
Re: omit 2 days old data from current date in Sort.
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?
Re: omit 2 days old data from current date in Sort.
This suggestion looks good, will try it.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?
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute