IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT output to be in multiple files


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 3156
Location: Tucson AZ

PostPosted: Wed Aug 01, 2007 6:55 pm
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

Moderator Emeritus


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

PostPosted: Wed Aug 01, 2007 8:31 pm
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
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: 3156
Location: Tucson AZ

PostPosted: Sun Aug 05, 2007 2:39 pm
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: 2146
Location: At my coffee table

PostPosted: Sun Aug 05, 2007 2:43 pm
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: 8797
Location: Welsh Wales

PostPosted: Sun Aug 05, 2007 4:16 pm
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

Moderator Emeritus


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

PostPosted: Sun Aug 05, 2007 9:05 pm
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: 2146
Location: At my coffee table

PostPosted: Sun Aug 05, 2007 9:40 pm
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

Moderator Emeritus


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

PostPosted: Sun Aug 05, 2007 10:00 pm
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
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: 1436
Location: Bangalore,India

PostPosted: Tue Aug 07, 2007 12:08 pm
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
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
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: 128
Location: Guntur

PostPosted: Tue Aug 07, 2007 7:13 pm
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
Reply with quote

Thank you buddies
Lakshmi
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Aug 08, 2007 2:17 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
Search our Forums:

Back to Top