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

DAVID MORANKO DMORANKO@wellplan.com
Wed, 16 Oct 2002 16:11:32 -0400


This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_277BBA17.503159F1
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Nancy,

Are you sure your two examples are looking at the same file? In your =
snippet from the Job version your input file is not qualified for the =
group name. Or perhaps in your 'on-line' example, you could be accessing a =
temp file as opposed to a disc file? Just a thought...




>>> Nancy Tietz <ntietz@mcare.med.umich.edu> 10/16/02 10:48AM >>>

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     =20
  301      >=20
  302      > ACC *TGRDVF03
  303      >=20
  304      > SORTED ON EE-SSN
  305      >=20
  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      >=20
  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. =20
  318      (FILE=20
  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

>=20

=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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.e=
du
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

--=_277BBA17.503159F1
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"=
>
<META content=3D"MSHTML 6.00.2712.300" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: =
2px">
<DIV><FONT size=3D1>Nancy,</FONT></DIV>
<DIV><FONT size=3D1></FONT>&nbsp;</DIV>
<DIV><FONT size=3D1>Are you sure your two examples are looking at the same =
file?=20
In your snippet from the Job version your input file is not qualified for =
the=20
group name. Or perhaps in your 'on-line' example, you could be accessing a =
temp=20
file as opposed to a disc file? Just a thought...</FONT></DIV>
<DIV><FONT size=3D1></FONT>&nbsp;</DIV>
<DIV><FONT size=3D1></FONT>&nbsp;</DIV>
<DIV><BR><BR>&gt;&gt;&gt; Nancy Tietz &lt;ntietz@mcare.med.umich.edu&gt;=20=

10/16/02 10:48AM &gt;&gt;&gt;<BR><BR>I am able to create an indexed =
subfile=20
online in Quiz, but not in a job.<BR><BR>HP3000 series 939&nbsp;&nbsp; =
MPE<BR>Q=20
U I Z&nbsp;&nbsp; (PowerHouse&nbsp; 8.19.C2)<BR><BR>Here is what happened =
in the=20
job: (I traced it back to the INDEX. If I take<BR>out the INDEX it=20
works.)<BR>&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR>&nbsp;=20
301&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; <BR>&nbsp;=20
302&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; ACC *TGRDVF03<BR>&nbsp;=20
303&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; <BR>&nbsp;=20
304&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; SORTED ON EE-SSN<BR>&nbsp;=20
305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; <BR>&nbsp;=20
306&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; SET SUB NAME UM21004F KEEP AT =
EE-SSN=20
INDEX EE-SSN<BR>&nbsp; 307&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; REP SUM=20
&amp;<BR>&nbsp; 308&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;&nbsp; NEW-BEG=20
&amp;<BR>&nbsp; 309&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;&nbsp; F4 &amp;<BR>&n=
bsp;=20
310&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;&nbsp; NEW-DIV &amp;<BR>&nbsp;=20
311&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;&nbsp; F7 &amp;<BR>&nbsp;=20
312&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;&nbsp; EE-SSN &amp;<BR>&nbsp;=20
313&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;&nbsp; REST<BR>&nbsp;=20
314&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; <BR>&nbsp;=20
315&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt; GO ;*********<BR>&nbsp;=20
316&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *E* File error on dictionary portion =
of=20
subfile.<BR>&nbsp; 317&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *E* The file does not =
exist=20
in specified domain; the file was not<BR>found.&nbsp; <BR>&nbsp;=20
318&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (FILE <BR>&nbsp;=20
319&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OPEN ERROR -247)<BR>&nbsp;=20
320&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;&nbsp; EXIT<BR><BR>And here is =
the=20
successful run OnLine:<BR>:quiz<BR><BR>Q U I Z&nbsp;&nbsp; (PowerHouse&nbsp=
;=20
8.19.C2)<BR>Copyright 1998 COGNOS INCORPORATED<BR>M-Care<BR><BR>&gt; =
ACC=20
*TGRDVF03.WRK<BR>*W* PowerHouse name for TGRDVF03.WRK is TGRDVF03.<BR>&gt;=
=20
SORTED ON EE-SSN<BR>&gt; SET SUB NAME UM21004T KEEP AT EE-SSN INDEX=20
EE-SSN<BR>&gt; REP SUM &amp;<BR>&gt;&nbsp; NEW-BEG F4 NEW-DIV F7 EE-SSN=20
REST<BR>&gt; SET REP LIM 999999<BR>&gt; GO<BR><BR>Records selected:&nbsp;=
=20
2311<BR>Records written:&nbsp;&nbsp; 1841<BR><BR>&gt; <BR><BR>=3D =3D =3D =
=3D =3D =3D =3D =3D =3D=20
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D<BR>Mailing list:=20
powerh-l@lists.swau.edu<BR>Subscribe: "subscribe" in message body to=20
powerh-l-request@lists.swau.edu<BR>Unsubscribe: "unsubscribe" in message =
body to=20
powerh-l-request@lists.swau.edu<BR><A=20
href=3D"http://lists.swau.edu/mailman/listinfo/powerh-l">http://lists.swau.=
edu/mailman/listinfo/powerh-l</A><BR>This=20
list is closed, thus to post to the list you must be a=20
subscriber.<BR></DIV></BODY></HTML>

--=_277BBA17.503159F1--