| View previous topic :: View next topic |
| Author |
Message |
manojvoona
Beginner
Joined: 05 Jan 2006
Posts: 43
Topics: 14
|
 Posted: Mon Apr 03, 2006 12:53 am Post subject: Extract Records from 1st to last friday using Sort |
 |
|
Hi,
I need some help in sort.
My requriement is to pull all the transactions that has happened between first of month and the last friday of the month.
Now is their any way to find out the last frida y ( or an day of the month) through DFSORT.
Thanks
Manoj |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Mon Apr 03, 2006 4:50 am Post subject: |
|
|
| Quote: |
Now is their any way to find out the last frida y ( or an day of the month) through DFSORT
|
manojvoona,
NO. Sort products does NOT have any in built features to get the day of the week. However you can generate SYMNAMES using Db2 unload and use them to extract the desired records. Check this link for an example.
http://mvsforums.com/helpboards/viewtopic.php?p=28104#28104
Check this link for sql to find the last sat. all you need is to change to friday
http://mvsforums.com/helpboards/viewtopic.php?t=6028
Hope this helps...
Cheers
Kolusu
Ps: Btw I answered the same question twice last week and yet you keep opening the same topic. 
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
manojvoona
Beginner
Joined: 05 Jan 2006
Posts: 43
Topics: 14
|
| Posted: Thu Apr 06, 2006 3:40 am Post subject: |
|
|
Really sorry Kolusu,
It was by mistake 
Thanks for your help  |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
