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

Difference between Inrec and Outrec


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

New User


Joined: 05 Feb 2008
Posts: 24
Location: Coimbatore

PostPosted: Tue Apr 15, 2008 12:23 pm
Reply with quote

Hi,

Please explain me the difference between Inrec and Outrec with examples.

Thanks in advance.

R's
Prema.
Back to top
View user's profile Send private message
bharath18

New User


Joined: 12 Sep 2006
Posts: 15
Location: Chennai, Tamilnadu, India

PostPosted: Tue Apr 15, 2008 12:40 pm
Reply with quote

INREC
Specifies how records are reformatted before they are sorted, copied, or merged.

OUTREC
Specifies how records are reformatted after they are sorted, copied, or
merged.
Back to top
View user's profile Send private message
Premdev

New User


Joined: 05 Feb 2008
Posts: 24
Location: Coimbatore

PostPosted: Tue Apr 15, 2008 12:43 pm
Reply with quote

Thanks Bharath.

It will be grateful if you explain me with an example.

R's
Prema.
Back to top
View user's profile Send private message
bharath18

New User


Joined: 12 Sep 2006
Posts: 15
Location: Chennai, Tamilnadu, India

PostPosted: Tue Apr 15, 2008 1:01 pm
Reply with quote

Example :

You could use the following statements to show all of the authors for the books used in computer science.

Code:

   INCLUDE COND=(110,5,CH,EQ,C’COMP’)
   SORT FIELDS=(76,15,CH,A,91,15,CH,A)
   OUTREC BUILD=(91,15,X,76,15)


The authors first name and last name will be displayed in the Upper Case. If you wanted to display these names with an initial uppercase letter and the subsequent in lower case letters, you could use the following OUTREC statement.

Code:

  OUTREC BUILD=(91,1,92,14,TRAN=UTOL,X,
     76,1,76,14,TRAN=UTOL)
Back to top
View user's profile Send private message
bharath18

New User


Joined: 12 Sep 2006
Posts: 15
Location: Chennai, Tamilnadu, India

PostPosted: Tue Apr 15, 2008 1:05 pm
Reply with quote

You can also change the format as First Name & Last Name

Like,

Code:

  OUTREC BUILD=(76,1,77,14,TRAN=UTOL,X,
     91,1,92,14,TRAN=UTOL)
Back to top
View user's profile Send private message
Premdev

New User


Joined: 05 Feb 2008
Posts: 24
Location: Coimbatore

PostPosted: Tue Apr 15, 2008 1:37 pm
Reply with quote

Thank you Bharath icon_smile.gif
Back to top
View user's profile Send private message
superk

Global Moderator


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

PostPosted: Tue Apr 15, 2008 4:55 pm
Reply with quote

This same topic was already answered here.
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: Tue Apr 15, 2008 9:13 pm
Reply with quote

Prema,

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

Use [URL] BBCode for External Links

Here's a link to the Chapter on reformatting records:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4?DT=20060615173822
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 Timestamp difference and its average ... DB2 11
No new posts Difference when accessing dataset in ... JCL & VSAM 7
No new posts question on Outrec and sort #Digvijay DFSORT/ICETOOL 20
No new posts What is the difference between Taskty... Compuware & Other Tools 2
No new posts INREC PARSE used to sort a CSV file DFSORT/ICETOOL 2
Search our Forums:

Back to Top