| Author |
Message |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Fri May 05, 2006 5:51 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Typical !!!
SYNCSORT FOR Z/OS 1.1BR TPF3
GGrrrr !!!!! |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Fri May 05, 2006 4:19 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Kolusu,
I ran the exact code you provided and this came out in my SYSOUT.
SYSIN :
JOINKEYS FILES=F1,FIELDS=(01,8,A)
* ... |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Thu May 04, 2006 9:41 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Kolusu,
I don't mean to waste your time. I'm trying everything to get this solution.
I read the thread on the Join that you posted but that merges 2 records from 2 files into one larger record in ... |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Wed May 03, 2006 11:21 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Ok, I used the following code but got an empty file after a successful completion which leads me to my parameters for the OUTREC or the OUTFIL commands ??
//S1 EXEC PGM=ICETOOL ... |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Wed May 03, 2006 5:58 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Hi again.
Frank Yaeger, thanks for that heads-up but the scenario you posted won't occur (thankfully).
Kolusu, thanks...that Synctool solution worked !!!!
However, now I've got a change reque ... |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Fri Apr 28, 2006 11:22 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
OK I used this (A/c # is 8 chars long)
//STEP0100 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT ... |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Fri Apr 28, 2006 10:16 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Hi,
The contents of pos 143 for A rows will be blanks/spaces. I just used ..... for illustration purposes.
These are the details of the record if it helps...
Data class . . . . . : EXTENDRL
... |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Fri Apr 28, 2006 9:38 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Kolusu,
Thanks for the quick reponse. I'm not sure I follow you though...
Where you have AAAAA and BBBBB above...what do they refer to?
Here's a better (I hope) explanation as to what I'm aft ... |
Topic: Comparing fields in VSAM dataset using FileAid JCL |
youtalkintome
Replies: 17
Views: 10961
|
Forum: Utilities Posted: Thu Apr 27, 2006 10:09 am Subject: Comparing fields in VSAM dataset using FileAid JCL |
Hi all.
Question for ya from a noob.
I've got a million-record VSAM file sorted by position 1 (account #).
Some records also have an old account number in pos 143.
How can I extract all accoun ... |
| |