This is weird... Online vs. In a Job INDEX
Pickering, John (NORBORD)
PICKERIJ@norbord.com
Wed, 16 Oct 2002 12:38:09 -0400
Bob
I don't understand your answer. Since Nancy's name is only 8 characters and
8.19 builds indexed subfiles as single file native mode ksam files and not
the 2 file data and keyfile structure from the classic days, why should Quiz
be changing the name? Sample experiment below.
Regards,
JWP
/quiz
Q U I Z (PowerHouse 8.19.C4)
Copyright 1999 COGNOS INCORPORATED
Norbord Industries Inc.
> use qeditscr
> acc issue-lines
> set sub nam TGRDVA03 keep index issue-no
> rep sum issue-no stock-no
> set rep lim 10
> go
*W* The maximum number of records has been selected.
Records selected: 10
Records written: 10
> :listfile tg@,2
ACCOUNT= NORBORD GROUP= JWP
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP EOF LIMIT R/B SECTORS #X MX
TGRDVA03 644 14B FAK 10 10 204 112 2 *
>
> -----Original Message-----
> From: Deskin, Bob [SMTP: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.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.