And a more general solution for any manipulations needed in a stage is to write a REXX stage that does exactly what you want.
Brian Nielsen On Wed, 29 Apr 2009 16:19:41 -0500, Huegel, Thomas <thue...@kable.com> wrote: >There is a pipe stage on the VM download page TABULATE that will do >exactly what you want. > >-----Original Message----- >From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On >Behalf Of James Stracka (DHL US) >Sent: Wednesday, April 29, 2009 4:05 PM >To: IBMVM@LISTSERV.UARK.EDU >Subject: Using PIPE to SUM a Column > >I have a file that has numeric data in column 3 that I want to sum. > >Not realizing there was no PIPE SUM stage I tried: > >PIPE < JIMS TESTFILE A | SPECS WORD 3 | SUM | VAR TOTAL > >Which of course gave: > >FPLSCB027E Entry point SUM not found >FPLSCA003I ... Issued from stage 4 of pipeline 1 FPLSCA001I ... Running >"SUM" >Ready(-0027); T=0.01/0.01 13:44:13 > > >Is there a way to SUM the data within a PIPE instead of doing: > >PIPE < JIMS TESTFILE A | SPECS WORD 3 | STEM VALUE. >Total = 0 >Do ix = 1 to value.0 > Total = total + value.ix >end >======================== ========================= =======================
