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
 

 

"FIELDS Box"

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Fri Aug 01, 2014 10:10 pm    Post subject: "FIELDS Box"
Reply with quote

As can be seen from the following, BUILD is nearly 10 years old.

BUILD is an alias of FIELDS (means it is another name for it, so operation is identical).

FIELDS is used in many places, and has more than one meaning. There is no need to confuse the use of FIELDS more by using it on INREC, OUTREC and to use OUTREC on OUTFIL when it has a perfectly reasonable alternative.

BUILD has only one meaning, and is used on INREC, OUTREC, OUTFIL and within IFTHEN on the same.

FIELDS will always exists, as it has since, as far as I know, the first release of IBM's first Mainframe SORT product.

However, let's not use it in sample code.

First infraction will be incur a small currency penalty to be paid into the "FIELDS Box" (if you know how a "Swear Box" works, this should be easy).

People who continue to use FIELDS will be forced to perform a series of simple joins using SPLICE instead of JOINKEYS, and further transgressions will lead to their WHEN=GROUP License revoked.

Note:
BUILD has also been available in SyncSort for many years, so the FIELDS Box applies to SyncSort as well.

Quote:
Summary of Changes for SC26-7523-01 z/OS Version 1 Release 6
(PTFs - December, 2004)

[...]

OUTFIL Enhancements

[...]

BUILD or OUTREC: The existing OUTREC parameter, or its new alias of BUILD,
allows you to reformat each record by specifying all of its items one by one.
BUILD or OUTREC gives you complete control over the items you want in your
reformatted OUTFIL records and the order in which they appear. You can delete,
rearrange and insert fields and constants.

[...]

INREC and OUTREC Enhancements
[...]

BUILD or FIELDS: The existing FIELDS parameter, or its new alias of BUILD,
allows you to reformat each record by specifying all of its items one by one.
BUILD or FIELDS gives you complete control over the items you want in your
reformatted INREC or OUTREC records and the order in which they appear.
You can delete, rearrange and insert fields and constants.
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Fri Aug 08, 2014 6:18 pm    Post subject:
Reply with quote

Good explanation Bill icon_smile.gif Thanks - It should be on sticky?
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Amount field is getting corrupted whe... thesumitk SYNCSORT 5 Tue Oct 18, 2016 8:20 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts Multi row fetch - "for read only... Nileshkul DB2 3 Sun Aug 14, 2016 12:52 am


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