MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 9 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Comparing fields in VSAM dataset using FileAid JCL
youtalkintome

Replies: 17
Views: 10961

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group