This is weird... Online vs. In a Job INDEX

Tim Cummings tim.cummings@frequencymarketing.com
Wed, 16 Oct 2002 11:51:04 -0400


Nancy,

My guess would be that the subfile "UM21004F" already exists with the same
layout but is not an indexed subfile.

Tim Cummings
Cummings Consulting
Cincinnati, OH
513-576-1182

-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]On
Behalf Of Nancy Tietz
Sent: Wednesday, October 16, 2002 10:48 AM
To: powerh-l@lists.swau.edu
Subject: This is weird... Online vs. In a Job INDEX


I am able to create an indexed subfile online in Quiz, but not in a job.

HP3000 series 939   MPE
Q U I Z   (PowerHouse  8.19.C2)

Here is what happened in the job: (I traced it back to the INDEX. If I take
out the INDEX it works.)
  300
  301      >
  302      > ACC *TGRDVF03
  303      >
  304      > SORTED ON EE-SSN
  305      >
  306      > SET SUB NAME UM21004F KEEP AT EE-SSN INDEX EE-SSN
  307      > REP SUM &
  308      >  NEW-BEG &
  309      >  F4 &
  310      >  NEW-DIV &
  311      >  F7 &
  312      >  EE-SSN &
  313      >  REST
  314      >
  315      > GO ;*********
  316      *E* File error on dictionary portion of subfile.
  317      *E* The file does not exist in specified domain; the file was not
found.
  318      (FILE
  319      OPEN ERROR -247)
  320      >  EXIT

And here is the successful run OnLine:
:quiz

Q U I Z   (PowerHouse  8.19.C2)
Copyright 1998 COGNOS INCORPORATED
M-Care

> ACC *TGRDVF03.WRK
*W* PowerHouse name for TGRDVF03.WRK is TGRDVF03.
> SORTED ON EE-SSN
> SET SUB NAME UM21004T KEEP AT EE-SSN INDEX EE-SSN
> REP SUM &
>  NEW-BEG F4 NEW-DIV F7 EE-SSN REST
> SET REP LIM 999999
> GO

Records selected:  2311
Records written:   1841

>

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