FW: simple request/complex solution?

[Maloney, Charlie]

choose &
  emp-no systemvalue "emp-no-values" range, &
  pay-period-no systemvalue "pay-period-no-values" range, &
  acct-no systemvalue "account-no-values" range

you can use any initial set of segments of any b-tree index.

qtp 710 ref manual, p 359, "Choose, Using Ranges with
the SYSTEMVALUE Option".

works in 620, 729, 803, etc....

use systemvalues over and over again
in multipass qz/qt com files...write once read many

sample VMS com file:  each pgm can use the systemvalues

$ ! other stuff here
$ emp-no-values :== "24,90"
$ pay-period-no-values :== "2,17"
$ account-no-values :== "1,4"
$ quiz 
  exe my_quiz_pgm_1.qzc
  exe my_quiz_prm_2.qzc
  exe my_quiz_pgm_3.qzc
  exit
$ qtp
  exe my_qtp_pgm.qtc
  exit
$ ! more stuff here

CM
Cognos Corp
Partner Operations Technical Acct Mgr

> ----------
> From: 	Pablo Grim
> Sent: 	Thursday, August 06, 1998 8:17 PM
> To: 	powerh-l@lists.swau.edu
> Subject: 	simple request/complex solution?
> 
> Hey folks,
> 
> I have a simple request from a user.  She wants to be able to retrieve
> data
> from a gl history file on a regular basis with the following selection
> criteria:  employees 1-N,  account numbers 1-N, and a single range of
> pay
> periods 1-4.
> 
> All of the necessary information is contained in the GL-HISTORY file.
> The
> file has a data structure like so:
> 
>     Record:             GL-HISTORY
>     of File:            GL-HISTORY
>     Organization:       INDEXED
> 
> -- Record Contents --
>     Item                                 Type            Size  Occ
> Offset
>     EMP-KEY                              CHARACTER         32
> 0
>     .EMP-NO                              CHARACTER          6
> 0
>     .PAY-PERIOD-NO                       CHARACTER          6
> 6
>     .ACCT-NO                             CHARACTER         20
> 12
>     PAY-AMOUNT                           INTEGER SIGNED     8
> 44
> 
>  ** EMP-KEY is a 32 byte  REPEATING PRIMARY ASCENDING  index **
> 
>     Segment                              Type            Size
>     EMP-KEY                              CHARACTER         32
> 
>  ** GL-KEY is a 26 byte  REPEATING ALTERNATE ASCENDING  index **
> 
>     Segment                              Type            Size
>     ACCT-NO                              CHARACTER         20
>     EMP-NO                               CHARACTER          6
> 
> This report will take a long time to run, so it must execute in batch.
> Input of selection criteria will be done from a quick screen, which
> will
> then create and submit the batch job.
> 
> Now if i were to simply do a CHOOSE EMP-KEY PARM thing, the user would
> be
> forced to enter all of the combinations (permutations?) of the
> selection
> criteria values, and I believe (my discrete mathmatics is rusty) that
> this
> could be an exponential amount of data entry, hmmm, or actually
> something
> like N1 * N2 * 2.  In other words, not acceptable.
> 
> The only way I can think of doing this is to create some kind of
> intermediate works files and some nested while loops to load them with
> all
> of the possible combinations of data values.  Then use the work file
> to
> link to the gl-history file.
> 
> Seems like kind of a lot of work for a simple request.
> 
> ideas?
> 
> thanks for hangin' in this far
> 
> p
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> 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
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.