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

Deskin, Bob Bob.Deskin@Cognos.COM
Wed, 16 Oct 2002 11:40:57 -0400


Just off the top, is it possible that you're getting duplicate file names?
Your subfile name is 8 characters long and is only unique in the eighth
character. Since MPE/iX file names are a maximum of 8 characters long, QUIZ
replaces the last character with another letter. Try the same thing with
unique file names of 7 characters.

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Nancy Tietz [mailto:ntietz@MCARE.MED.UMICH.EDU]
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.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.