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

[Nancy Tietz]

I tried what you suggested, and the job still aborts.  The job purges all
subfiles to start with too.
However, I have a co-worker that was able to do the Quiz Index in a job with
my same code, different filenames.  But he didn't have the same steps as
mine has running above it.
Here is what happened in my job:
  306      > 
  307      > ACC *TGRDVA03
  308      > 
  309      > SORTED ON EE-SSN
  310      > 
  311      > SET SUB NAME TGRDVB05 KEEP INDEX EE-SSN
  312      > REP SUM &
  313      >  NEW-BEG &
  314      >  F4 &
  315      >  NEW-DIV &
  316      >  F7 &
  317      >  EE-SSN &
  318      >  REST
  319      > 
  320      > GO ;*********
  321      *E* File error on dictionary portion of subfile.
  322      *E* The file does not exist in specified domain; the file was not
fou
nd.  
  323      (FILE

  324      OPEN ERROR -247)
  325      > 
  326      > 

-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Wednesday, October 16, 2002 11:41 AM
To: 'Nancy Tietz'; powerh-l@lists.swau.edu
Subject: RE: This is weird... Online vs. In a Job INDEX


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.