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: 183
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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Sum Fields ballaswaroop DFSORT/ICETOOL 4 Tue May 02, 2017 11:07 am


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