Quiz Extract
Deskin, Bob
Bob.Deskin@Cognos.COM
Wed, 18 Aug 2004 13:20:31 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C48547.A9CE2AD7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
What is your intent? Any formatting you specify (Pic etc) is written to
the subfile. But if you're trying to report something, a subfile isn't
it. You should be able to redirect the QUIZ output disk file. The
default name is QUIZLIST. You should be able to assign QUIZLIST to
another disk outside of QUIZ.
Bob Deskin =20
Senior Product Manager, Application Development Tools, Cognos Inc.=20
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178=20
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA=20
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Pickering, John
(NORBORD)
Sent: August 18, 2004 1:06 PM
To: 'Kristina Carlton'; 'powerh-l@lists.sowder.com'
Subject: RE: Quiz Extract
=09
=09
I would have thought that just your time alone to dink around
trying to force some hokey solution would be a lot more valuable that
simply buying more disc space!
=20
-----Original Message-----
From: Kristina Carlton [mailto:Kristina.Carlton@JICompanies.com]
Sent: Wednesday, August 18, 2004 12:28 PM
To: 'powerh-l@lists.sowder.com'
Subject: Quiz Extract
=09
=09
Hi,
=20
I am new to this list. I just started using Quiz and have some
questions.
=20
We have our files located on Disk 0 which has limited space. I
am working on extracts that retrieve quite a bit of data and ideally we
want to redirect the output to disk 1. I have been able to do so with
the subfile but not with the textfile. I tried the following:
=20
SET REPORT DEVICE DISC NAME DKF1:[DW]DWDTL
=20
However, I then noticed in the Cognos book I have that you
cannot specify a disk name with the SET REPORT statement. So we started
suppressing the text file and decided to use the subfile. That has its
own set of problems such as not being able to use a PICTURE format, not
being able to use the count function and more.
=20
Ultimately we would like to extract data on a nightly basis and
dump it into a Progress data warehouse. Any advice is greatly
appreciated.
=20
Thanks,
-Kristina
Ext. 2459=20
=20
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.=20
=20
------_=_NextPart_001_01C48547.A9CE2AD7
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16"><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C48516.6095C7E0" rel=3DFile-List><!--[if gte =
mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>2.85 =
pt</w:DrawingGridHorizontalSpacing>
=
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
font-family: Century Gothic;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; =
mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Courier New"
}
LI.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Courier New"
}
DIV.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Courier New"
}
P.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Courier New"
}
LI.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Courier New"
}
DIV.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Courier New"
}
SPAN.EmailStyle15 {
COLOR: #333399; mso-bidi-font-family: Arial; mso-style-type: =
personal-compose; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: =
"Century Gothic"; mso-hansi-font-family: "Century Gothic"
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD><BODY lang=3DEN-US style=3D"tab-interval: .5in"><DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D018021617-18082004>What=20
is your intent? Any formatting you specify (Pic etc) is written to the =
subfile.=20
But if you're trying to report something, a subfile isn't it. You should =
be able=20
to redirect the QUIZ output disk file. The default name is QUIZLIST. You =
should=20
be able to assign QUIZLIST to another disk outside of =
QUIZ.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D018021617-18082004><!-- Converted from text/rtf format -->
<P><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Bob=20
Deskin &=
nbsp; =20
</FONT></SPAN><BR><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Senior =
Product=20
Manager, Application Development Tools, Cognos Inc.</FONT></SPAN> =
<BR><SPAN=20
lang=3Den-us><FONT face=3DArial size=3D2>bob.deskin@cognos.com (613) =
738-1338 ext 7268=20
FAX: (613) 727-1178</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT =
face=3DArial=20
size=3D2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9=20
CANADA</FONT></SPAN> </P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com] <B>On=20
Behalf Of </B>Pickering, John (NORBORD)<BR><B>Sent:</B> August 18, =
2004 1:06=20
PM<BR><B>To:</B> 'Kristina Carlton';=20
'powerh-l@lists.sowder.com'<BR><B>Subject:</B> RE: Quiz=20
Extract<BR><BR></FONT></DIV>
<DIV>
<DIV><SPAN class=3D890451117-18082004><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2>I would <SPAN class=3D906591217-18082004>have thought =
</SPAN>that=20
just your time alone to dink around trying to force some hokey =
solution would=20
be a lot more valuable that simply buying more disc space<SPAN=20
class=3D906591217-18082004>!</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D890451117-18082004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV></DIV>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Kristina Carlton=20
[mailto:Kristina.Carlton@JICompanies.com]<BR><B>Sent:</B> Wednesday, =
August=20
18, 2004 12:28 PM<BR><B>To:</B> =
'powerh-l@lists.sowder.com'<BR><B>Subject:</B>=20
Quiz Extract<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Hi,<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">I am new to this =
list. I=20
just started using Quiz and have some=20
questions.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">We have our =
files located=20
on Disk 0 which has limited space. I am working on extracts that =
retrieve=20
quite a bit of data and ideally we want to redirect the output to disk =
1. I=20
have been able to do so with the subfile but not with the textfile. I =
tried=20
the following:<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">SET REPORT =
DEVICE DISC=20
NAME DKF1:[DW]DWDTL<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">However, I then =
noticed in=20
the Cognos book I have that you cannot specify a disk name with the =
SET REPORT=20
statement. So we started suppressing the text file and decided to use =
the=20
subfile. That has its own set of problems such as not being able to =
use a=20
PICTURE format, not being able to use the count function and=20
more.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Ultimately we =
would like=20
to extract data on a nightly basis and dump it into a Progress data =
warehouse.=20
Any advice is greatly appreciated.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Thanks,<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail=20
Signature" <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><S=
PAN=20
class=3DEmailStyle15><FONT color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">-Kristina<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Ext.=20
2459</SPAN></FONT></SPAN><FONT color=3D#333399><SPAN=20
style=3D"COLOR: #333399; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><FONT=20
color=3D#333399><SPAN style=3D"COLOR: #333399"><![if =
!supportEmptyParas]><![endif]> </SPAN></FONT><FONT=20
color=3D#333399><SPAN=20
style=3D"COLOR: #333399; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV>
<P> <FONT FACE=3D"Arial" =
SIZE=3D"2">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.</FONT>
</P>
</DIV></BODY></HTML>
------_=_NextPart_001_01C48547.A9CE2AD7--