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.