View previous topic :: View next topic
|
Author |
Message |
rimli
New User
Joined: 21 Aug 2003 Posts: 5
|
|
|
|
Would you please let me know the below queries:
1> How do I MATCH 2 files using ICETOOL? The match should be made based on some key value in the file (suppose records starting from pos 1-5 for eg)
2> How do I do date manipulations from current date using ICETOOL?
Thanks for your help.
Rimli. |
|
Back to top |
|
|
abdul
EXPERT
Joined: 28 Jul 2003 Posts: 23 Location: Bangalore,India
|
|
Back to top |
|
|
honeypria567
New User
Joined: 20 Nov 2006 Posts: 14 Location: chennai
|
|
|
|
in ICETOOL there is one command is there SPLICE.
by using SPLICE you can match 2 files.
SPLICE from(indd) to (outdd) on(p,m,f)......with(p,m).....withall
please correct me if i was wrong
thanks,
Honey |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
1> How do I MATCH 2 files using ICETOOL? The match should be made based on some key value in the file (suppose records starting from pos 1-5 for eg) |
See the "Create files with matching and non-matching records" Smart DFSORT Trick at:
www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Quote: |
2> How do I do date manipulations from current date using ICETOOL? |
You need to be more specific about exactly what you want to do. What type of date (yyyymmdd or yyyyddd or what)? What do you want to do to it? |
|
Back to top |
|
|
|