RE: Counting (was: RE: [U2] TCL beginner)

2005-09-06 Thread Ron Hutchings
Universe supports the ENUM command that does the same thing as adding our favorite CNT I-descriptor to the dictionary or VOC. It is always available without editting dictionaries or vocs. It does add a column to the output. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscr

RE: [U2] TCL beginner

2005-09-04 Thread Stevenson, Charles
ENUM works with multivalues too. Here is an example, again using a file everyone should know, Pick Flavour NEWACC (NEWACC is used to build VOCs for new accounts) verbs have multivalues in <8>. The following shows how many NEWACC verbs allow the various ...-SUPP keywords. F8.MV is a D-item with <6>

RE: [U2] TCL beginner

2005-09-04 Thread Stevenson, Charles
No one mentioned the ENUM keyword? Here is an example using a file everyone knows: >SORT VOC BY TYPE SAMPLE 10 ID.SUP BREAK.ON TYPE ENUM @ID TYPE VOC. K=< K=> K>< K>= ** 4 VCLEAR.LOCKS VDIVX VHASH.TEST VMENU.DOC VT.LOAD ** 5 XQUIT.KEY **

Counting (was: RE: [U2] TCL beginner)

2005-09-04 Thread Ross Morrissey
PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TCL beginner I use a TCL command that I created called COUNTER. It requires the dict item in the file called COUNTER that represents the value 1. At tcl type COUNTER CUSTOMER STATE The proc goes like this: PQN HSORT A2 H BY A3 H BREAK-ON A3 H TO

Re: [U2] TCL beginner

2005-09-02 Thread Mark Johnson
I use a TCL command that I created called COUNTER. It requires the dict item in the file called COUNTER that represents the value 1. At tcl type COUNTER CUSTOMER STATE The proc goes like this: PQN HSORT A2 H BY A3 H BREAK-ON A3 H TOTAL COUNTER DET-SUPP P I use this quite extensively for this exac

RE: [U2] TCL beginner

2005-09-02 Thread Kevin King
If F40 is mv'd change the BY to BY.EXP; everything else should be fine. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] TCL beginner

2005-09-02 Thread Allen E. Elwood
is case I think it should work. Amazing that Dataflo has the same F-stuff that M2K has. Wonder who copied who?!! Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bruce Ordway Sent: Friday, September 02, 2005 16:03 To: 'u2-users@listserver.u2ug.org&#

RE: [U2] TCL beginner

2005-09-02 Thread Bruce Ordway
Hmmm... I looked a little closer & noticed that all the bogus values were for old files which may or may not have had correct values entered. I modified the TCL to this: LIST RMA WITH F41 = "Y" AND WITH F40 = "1028" "1029" "1030" "1031" "1032" "1033" "1034" "1035" BY F40 BREAK-ON F40 TOTAL Z_RMA_C

RE: [U2] TCL beginner

2005-09-02 Thread Bruce Ordway
>Assume you called it One< I called it Z_RMA_CNT. I also had to change the words a little because of my flavor I think. LIST RMA BY F40 BREAK-ON F40 TOTAL Z_RMA_CNT ID-SUPP DET-SUPP Anyway, I'm getting wierd results. Could it be because F40 is a MV field? COMMENT Z_RMA_CNT

Re: [U2] TCL beginner

2005-09-02 Thread Jim Bullock
Hi Bruce - SORT RMA BY F40 BREAK.ON F40 TOTAL EVAL"1" DET.DUP Jim --- Bruce Ordway <[EMAIL PROTECTED]> wrote: > Hi, > > I've got Dataflo running on Unidata 5.2. > I know just enough TCL to be dangerous. > > Anyway I've been struggling this afternoon withg something I thought would > be simpl

RE: [U2] TCL beginner

2005-09-02 Thread Kevin King
SORT RMA BY F40 BREAK.ON F40 TOTAL CNT (ID This assumes you have a CNT field in your VOC, defined as: 001 V 002 1 003 004 005 10R 006 R --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] TCL beginner

2005-09-02 Thread Allen E. Elwood
Hi Bruce, First, create a dictionary that is an I descriptor and just give it a value of 1. Assume you called it One Then: LIST RMA BY F40 BREAK.ON F40 TOTAL One ID.SUP DET.SUP Should do it! btw, are you a Manage-2000 client? I noticed the F40 convention which is standard for files on M2K.