Counter increment w/o SET SUBFILE AT....

[Maloney, Charlie]

Q U I Z   (PowerHouse  8.21.D2)
Copyright 2000 COGNOS INCORPORATED
Licensed PH8-TEMPORARY for customer: 0712570003 COGNOS WINNT DEMO

> use x
> acc branches
> define d_init_value = 10100
> define d_counter = 1
> sort on country_code
> rep country_code &
>     branch_code &
>     d_counter sub at country_code init value d_init_value noreset
> go
06-NOV-2000                    The Great Outdoors                      PAGE
1

  Country  Branch  D_COUNTER
   Code     Code   (SUBTOTAL)

   AUS      MEL       10101
   AUS      SYD       10101
   BEL      BRUS      10102
   CAN      MTL       10103
   CAN      TOR       10103
   CAN      VAN       10103
   FRA      PAR       10104
   GER      FRNK      10105
   HKG      HKG       10106
   ITA      ROM       10107
   JAP      TOKY      10108
   MEX      MEX       10109
   SING     SING      10110
   SPA      MADR      10111
   SWE      STOC      10112
   UK       LON       10113
   UK       MAN       10113
   USA      BOS       10114
?
-----Original Message-----
From: Karman, Al [mailto:AKarman@usfreightways.com]
Sent: Monday, November 06, 2000 1:42 PM
To: powerh-l@sphere.swau.edu
Subject: Counter increment w/o SET SUBFILE AT....


Good day to all.......

It certainly seemed easy enough......sort on this 'ML-NO', and each time the
ML-NO changes, increment this SHIPMENT#  by one....
e.g.   ML-NO		SHIPMENT#
	001		10101
	001		10101
	002		10102
	003		10103

What am I missing to get this badboy to increment...It's only writes '10101'
currently for all values of ML-NO

As Always, TIA...!!!


DEF SHIPMENT# NUM*5 = (10100 + 1)
;
SOR ON ML-NO
;
SET SUBFILE APPEND KEEP NAME SHIPMENT &
  INDEX IX1 SEGMENT MR-NO,            &
  INDEX IX2 SEGMENT PO-NO,            &
  INDEX IX3 SEGMENT PL-NO,            &
  INDEX IX4 SEGMENT ML-NO
;
REP SUMM                       &
  MR-NO                        &
  PO-NO                        &
  PL-NO                        &
  ML-NO                        &
  SHIPMENT# SUB AT ML-NO       &
  DIMENSIONS


Al Karman
IT Consultant
US Freightways 
akarman@usfreightways.com
773.824.2284

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.