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.