Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need to get the not sorted Key fields in a flat file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
naveen.m

New User


Joined: 02 Nov 2007
Posts: 9
Location: BENGALURU

PostPosted: Thu Mar 27, 2008 1:14 pm    Post subject: Need to get the not sorted Key fields in a flat file
Reply with quote

Hi,

I need to sort a master file using key fields passed thru sysin card.

As it is a support wrk. I cant use cobol code for sort process.

Jst i need to run the job for this providing the Key Fields.

after job is run i want to know which key fileds were not present in master file and need to get those Key Field values to be written in another flat file.

Pls help me out
Back to top
View user's profile Send private message

sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 182
Location: hyderabad

PostPosted: Thu Mar 27, 2008 3:54 pm    Post subject:
Reply with quote

Naveen,
Could you plese elobarate your requirement.It will be good if you provide the sample input and expected output.

Thanks
Krishy
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Mar 27, 2008 9:19 pm    Post subject:
Reply with quote

Also:

Give the RECFM and LRECL of the input file.

Give the starting position, length and format of each relevant field.

What is the approximate number of "key fields" you need to pass through SYSIN?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 27, 2008 9:58 pm    Post subject:
Reply with quote

Hello,

Sounds like maybe a good candidate for putting the "key fields" in a second data file and creating output of matched/unmatched to meet the requirement. . .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Mar 27, 2008 10:14 pm    Post subject:
Reply with quote

INCLUDE might be a better choice depending on the number, length and format of the "key fields".
Back to top
View user's profile Send private message
naveen.m

New User


Joined: 02 Nov 2007
Posts: 9
Location: BENGALURU

PostPosted: Fri Mar 28, 2008 12:19 pm    Post subject: Need to get the not sorted Key fields in a flat file
Reply with quote

dick scherrer wrote:
Hello,

Sounds like maybe a good candidate for putting the "key fields" in a second data file and creating output of matched/unmatched to meet the requirement. . .


hi,

Can i get the syntax for the same.

Thks in advance.
Back to top
View user's profile Send private message
naveen.m

New User


Joined: 02 Nov 2007
Posts: 9
Location: BENGALURU

PostPosted: Fri Mar 28, 2008 12:25 pm    Post subject: Need to get the not sorted Key fields in a flat file
Reply with quote

What is the approximate number of "key fields" you need to pass through SYSIN?[/quote]

It depends on request.
Some thing around 150-200 keyfields.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Mar 28, 2008 8:46 pm    Post subject:
Reply with quote

Quote:
Can i get the syntax for the same.


Not until you supply the rest of the information we asked for previously.

Quote:
provide the sample input and expected output


Quote:
Give the RECFM and LRECL of the input file

Give the starting position, length and format of each relevant field.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us