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

How to get single quote in outfile using outrec of sort util


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
shikhagupta33

New User


Joined: 11 Apr 2005
Posts: 7
Location: Bangalore

PostPosted: Sat Feb 21, 2009 10:49 am
Reply with quote

Hi,

I am using 3.14 option in Batch mode. I have list of 100 procs to be searched in JCLLIB pds. I.e. I want to get list of Jobs which are executing these procs. My list is there in a file like below.
proc001
proc002
proc003
-----
-----
proc100

Now I want to get my list as below
srchfor 'proc001'
srchfor 'proc002'
scrchfor 'proc003'
-------------------
-------------------
srchfor 'proc100'

For this I want to use sort utility's outrec to get my i/p file modified and give output like as I wanted.

So that I can use my o/p file to be input to my bacth mode of option 3.14
Please help.
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: Sat Feb 21, 2009 8:19 pm
Reply with quote

If you want to include a single apostrophe in the character string, you must specify it as two single apostrophes. Thus:
Required: O'NEILL
Specify: C'O''NEILL'
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Sat Feb 21, 2009 9:11 pm
Reply with quote

Shikha,

You can use a DFSORT job like the following to do what you asked for:

Code:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file (FB)
//SORTOUT DD DSN=... output file (FB/80)
//SYSIN    DD    *
  OPTION COPY
  INREC BUILD=(C'srchfor ''',1,7,C'''',80:X)
/*
Back to top
View user's profile Send private message
shikhagupta33

New User


Joined: 11 Apr 2005
Posts: 7
Location: Bangalore

PostPosted: Tue Mar 03, 2009 5:37 pm
Reply with quote

Thank you for the resolution. It worked.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top