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
 

 

To Sort the output of a the SEARCH (3.14 option)

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

New User


Joined: 01 May 2006
Posts: 7
Location: INDIA, Mumbai

PostPosted: Wed Dec 12, 2007 1:47 am    Post subject: To Sort the output of a the SEARCH (3.14 option)
Reply with quote

Hi,

I need to sort an input file that has a list of program names and while writing the output, I need to put these program names within brackets. The problem is some program names are 7 characters in lenght and some are 8 characters in lenght, so while trying to put brackets, for the 7 character program, I am getting a SPACE before closing the bracket.

Could some body advise as how to solve this using SYNCSORT and DFSORT? . I am trying to use ALTSEQ but its not working properly.
Back to top
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Wed Dec 12, 2007 2:24 am    Post subject: Re: To Sort the output of a the SEARCH (3.14 option)
Reply with quote

ch.sridhar wrote:
Hi,

I need to sort an input file that has a list of program names and while writing the output, I need to put these program names within brackets. The problem is some program names are 7 characters in lenght and some are 8 characters in lenght, so while trying to put brackets, for the 7 character program, I am getting a SPACE before closing the bracket.

Could some body advise as how to solve this using SYNCSORT and DFSORT? . I am trying to use ALTSEQ but its not working properly.


Here is a DFSORT job which would give you the desired results. This job will take care of spaces

Code:

//STEP0100 EXEC PGM=ICEMAN                                 
//SYSOUT   DD SYSOUT=*                                   
//SORTIN   DD *                                         
A                                                       
BB                                                       
CCC                                                     
DDDD                                                     
EEEEE                                                   
FFFFFF                                                   
GGGGGGG                                                 
HHHHHHHH                                                 
//SORTOUT  DD SYSOUT=*                                   
//SYSIN    DD *                                         
  SORT FIELDS=COPY                                       
    INREC IFTHEN=(WHEN=INIT,                             
      BUILD=(1,80,JFY=(LEAD=C'(',SHIFT=LEFT,TRAIL=C')')))
//*                                                     


and the output is

Code:

(A)       
(BB)     
(CCC)     
(DDDD)   
(EEEEE)   
(FFFFFF) 
(GGGGGGG)
(HHHHHHHH)


Hope this helps...
Back to top
View user's profile Send private message
ch.sridhar

New User


Joined: 01 May 2006
Posts: 7
Location: INDIA, Mumbai

PostPosted: Wed Dec 12, 2007 2:46 am    Post subject: Reply to: To Sort the output of a the SEARCH (3.14 option)
Reply with quote

Hi,

I have tried previously with JFY and TRAIL options etc...but the sort step is abending.
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 Dec 12, 2007 3:03 am    Post subject:
Reply with quote

Hello,

You are using Syncsort.
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Wed Dec 12, 2007 3:19 am    Post subject:
Reply with quote

yes, the WER messages belongs to SyncSort.

is Alissa registered in this forum?
Back to top
View user's profile Send private message
ch.sridhar

New User


Joined: 01 May 2006
Posts: 7
Location: INDIA, Mumbai

PostPosted: Wed Dec 12, 2007 3:27 am    Post subject:
Reply with quote

Hi,

Yes sorry I forgot to tell...I can use SYNCSORT only not DFSORT so is there any way I can do this with SYNCSORT.


Thanks,
Sridhar
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 Dec 12, 2007 5:01 am    Post subject:
Reply with quote

Hello,

Quote:
is Alissa registered in this forum?
Yes, she is.
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: Wed Dec 12, 2007 11:35 pm    Post subject:
Reply with quote

Sridhar,

Kolusu's job works fine with DFSORT which has supported the JFY function since April, 2006. Syncsort does NOT support the JFY function.
Back to top
View user's profile Send private message
ch.sridhar

New User


Joined: 01 May 2006
Posts: 7
Location: INDIA, Mumbai

PostPosted: Thu Dec 13, 2007 12:01 am    Post subject:
Reply with quote

Frank,

Thanks for the response but I am not sure if my company has DFSORT or not...Could you please let me know if there is a way to handle this with SYNCSORT.


Thanks,
Sridhar
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Thu Dec 13, 2007 12:24 am    Post subject:
Reply with quote

ch.sridhar wrote:
Could you please let me know if there is a way to handle this with SYNCSORT.


That will be up to someone from SYNCSORT to respond to. Please wait for their response, or contact their tech. support directly via their website.
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 Dec 13, 2007 12:24 am    Post subject:
Reply with quote

Quote:
Frank,

Thanks for the response but I am not sure if my company has DFSORT or not...Could you please let me know if there is a way to handle this with SYNCSORT.


Kolusu and I are DFSORT developers. DFSORT and Syncsort are competitive products. We're happy to answer questions on DFSORT and DFSORT's ICETOOL, but we don't answer questions on Syncsort.
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 Incorrect output when trying to add n... monica1 PL/I & Assembler 10 Fri Jan 13, 2017 5:02 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 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
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am


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