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
 

 

SYNCSORT output to be in multiple files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
lakshmi_ta

New User


Joined: 23 Aug 2006
Posts: 13

PostPosted: Wed Aug 01, 2007 6:44 pm    Post subject: SYNCSORT output to be in multiple files
Reply with quote

Hi Friends,

I would like to know how to write control card for SYNCSORT, output of SYNCSORT would be in 3 different files.

Regards,
Lakshmi
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Aug 01, 2007 6:55 pm    Post subject:
Reply with quote

Quite similar to DFSORT, with FNAMES or FILES in the OUTFIL control statement.....Check your manual.....
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: Wed Aug 01, 2007 8:31 pm    Post subject:
Reply with quote

Hello,

If you post what your input looks like and what you want in the 3 output files someone may have suggestions.

As was previoiusly posted, you will find the info in the manuals. If you read something that is not clear, please post your questions here.
Back to top
View user's profile Send private message
lakshmi_ta

New User


Joined: 23 Aug 2006
Posts: 13

PostPosted: Sun Aug 05, 2007 1:44 pm    Post subject: sync sort control card to write output in multiple files
Reply with quote

Hi,

How can I write the out put of syncsort in 3 differrent files? Anybody can help me??

Lakshmi
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Sun Aug 05, 2007 2:39 pm    Post subject:
Reply with quote

Wasn't the answer to this question answered to your satisfaction?
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Aug 05, 2007 2:43 pm    Post subject:
Reply with quote

William Thompson wrote:
Quite similar to DFSORT, with FNAMES or FILES in the OUTFIL control statement.....Check your manual.....


Have you checked the manual?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Sun Aug 05, 2007 4:16 pm    Post subject:
Reply with quote

Would these three output files all be the same data, or would there be some form of data selection to determine which data resides in each of the output files.

Is your input data FB or VB ?
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: Sun Aug 05, 2007 9:05 pm    Post subject:
Reply with quote

Hello lakshmi_ta,

If you are not willing to post information about your requirement, we can make few good suggestions.

You need to re-read your topic all the way thru and provide the requested information.

People are trying to help you, but you are not making yourseld "help-able". The most important part of getting usable answers here is to present a clear, detailed question (with example data).

You need to show some input (that covers the kinds of data your process will encounter), the rules for processing the input, and what you expect the output to be from that input.

It is not hard to do, but it does mean that you have to put in a bit of effort.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Aug 05, 2007 9:40 pm    Post subject:
Reply with quote

Well, he did ask the question a second time this morning......
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: Sun Aug 05, 2007 10:00 pm    Post subject: Re: SYNCSORT output to be in multiple files
Reply with quote

Maybe the next round will include some usable details. . .

We can only hope. . . . icon_confused.gif
Back to top
View user's profile Send private message
lakshmi_ta

New User


Joined: 23 Aug 2006
Posts: 13

PostPosted: Tue Aug 07, 2007 12:04 pm    Post subject:
Reply with quote

Hi friends,

Thank you for your interest. Iam just attending the interviews as a mainframe developer. I don't have any manuals. In my last interview, they asked me the control card to write the output of a sync sort in three files, they didn't tell/ask me about the file structure and all.

Hope you can understand me.

Regards,
Lakshmi
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Tue Aug 07, 2007 12:08 pm    Post subject:
Reply with quote

Lakshmi,

Quote:
they didn't tell/ask me about the file structure and all.


How anyone in the world could help you without the file structure? Though it was in interview, without knowing the file attributes, condition for spliting the files...... none can write a control card/program.
Back to top
View user's profile Send private message
lakshmi_ta

New User


Joined: 23 Aug 2006
Posts: 13

PostPosted: Tue Aug 07, 2007 1:02 pm    Post subject:
Reply with quote

why can't you explain me with some example?? take a file with rf=fb,lrecl= 132,

the condition will be like, all the names starting with L should be in one file, K will be in another and in a 3rd file all the names should be with V. assume, all the files have the same attributes, assume the charector position from 4,1.

Lakshmi
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Aug 07, 2007 1:05 pm    Post subject:
Reply with quote

Quote:
lakshmi_ta
cool.

Use OUTFIL with INCLUDE cond
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 130
Location: Guntur

PostPosted: Tue Aug 07, 2007 7:13 pm    Post subject:
Reply with quote

hi lakshmi,

Quote:

the condition will be like, all the names starting with L should be in one file, K will be in another and in a 3rd file all the names should be with V. assume, all the files have the same attributes, assume the charector position from 4,1.


your control card will look like this
Code:

SORT FIELDS=COPY                         
    OUTFIL FILES=01,INCLUDE=(4,1,CH,EQ,C'L')
    OUTFIL FILES=02,INCLUDE=(4,1,CH,EQ,C'K')
    OUTFIL FILES=03,INCLUDE=(4,1,CH,EQ,C'V')



If you need any clarification dont hesitate to ask.
Back to top
View user's profile Send private message
lakshmi_ta

New User


Joined: 23 Aug 2006
Posts: 13

PostPosted: Tue Aug 07, 2007 9:18 pm    Post subject:
Reply with quote

Thank you buddies
Lakshmi
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: Wed Aug 08, 2007 2:17 am    Post subject:
Reply with quote

You're welcome, Lakshmi icon_smile.gif

Going forward, it is best to post interview questions in the Interview Questions section of the forum.

If we understand that the question is a generalization, we won't fuss so much about the details.

I believe you would have received your answer much more quickly if we had understood your situation.

Quote:
I don't have any manuals
Many of the manuals that have the info that interviewers ask about are available via the "Manuals" link at the top of the web pages.

We're here when you have questions.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 1 Fri Dec 02, 2016 9:47 am
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 8 Thu Dec 01, 2016 8:28 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am


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