Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Compare yesterday's date to the one o... migusd SYNCSORT 4 Fri Sep 22, 2017 11:35 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us