Example codes for Control Statements using SKIP; COUNT; SUM

Supriya Das · New User Joined: 18 Jul 2008 Posts: 5 Location: India

Where can I find 3 separate coding examples for Control Statements using SKIP; COUNT; SUM. Do I have to use INCLUDE control statement along with those control statements? If you can guide me toward the right URL/hyperlink I will appreciate it.

expat · Posted: Fri Jul 25, 2008 12:27 pm Post subject:

Click here for some useful links

Frank Yaeger · Posted: Fri Jul 25, 2008 8:54 pm Post subject:

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:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html

Your questions are rather vague so it's a bit difficult to answer them, but ...

DFSORT has a SKIP keyword on the OUTFIL statement, but I suspect what you're really asking about is the SKIPREC keyword on the OPTION statement. Here's a link to complete details of the OPTION statement:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.12?DT=20060615185603

Here's a link to an example with SKIPREC:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.12.2.1?SHELF=&DT=20060615185603

COUNT is a keyword on the TRAILERx (TRAILER1, TRAILER2, TRAILER3) operand of the OUTFIL statement. Here's a link to complete details on the OUTFIL statement:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.13?DT=20060615185603

Here's a link to an example with COUNT:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.13.2.4?SHELF=&DT=20060615185603&CASE=

SUM is a control statement. Here's a link to complete details on the SUM statement:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.17?DT=20060615185603

Here's a link to examples with SUM:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.17.2?DT=20060615185603

You would need INCLUDE if you want to include records based on a criteria. Here's a link to complete details on the INCLUDE statement:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.7?DT=20060615185603

Here's a link to some examples with INCLUDE:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.7.3?DT=20060615185603

If you want something more specific, explain in detail what you want to do.

Supriya Das · New User Joined: 18 Jul 2008 Posts: 5 Location: India

Thanks Frank. I have a another question. I know that

Supriya Das · New User Joined: 18 Jul 2008 Posts: 5 Location: India

I found the answer. It is:

Supriya Das · New User Joined: 18 Jul 2008 Posts: 5 Location: India

I have 10 records in Input dataset. Forth byte is signed packed decimal. One of those 10 records is a duplicate record which should be eleminated.

The valid code is:

dick scherrer · Posted: Tue Jul 29, 2008 9:51 pm Post subject:

Hello,

Because it violates the "rules". . .

You cannot SUM a field that is a SORT FIELD (to do so really makes no sense). SUM is to total values within the SORT FIELDs. For example, total sales by customer.

Frank Yaeger · Posted: Tue Jul 29, 2008 10:15 pm Post subject:

SUM fields cannot overlap SORT fields. If you really need to SORT on a field and SUM it as well, you could do it like this (I'm assuming your input file has RECFM=FB and LRECL=80):

Supriya Das · New User Joined: 18 Jul 2008 Posts: 5 Location: India

Thanks to Frank & Dick. You guys are really helpful. Frank, you are great.