Quiz Extract
Hoppe, Eric EP
Eric.Hoppe@steelscape-inc.com
Wed, 18 Aug 2004 16:55:27 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4857E.D6135060
Content-Type: text/plain
Why not simply take your system down for an hour or so and move the whole
files to other disks? I am assuming your phdat logical points to more than
one disk.
Then again... unless your raid sets are getting full, new drives are cheap.
---ehops
now an ex-powerhouser :(
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Wednesday, August 18, 2004 10:21 AM
To: Kristina Carlton; powerh-l@lists.sowder.com
Subject: RE: Quiz Extract
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
Senior 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: 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
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!
-----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
Hi,
I am new to this list. I just started using Quiz and have some questions.
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:
SET REPORT DEVICE DISC NAME DKF1:[DW]DWDTL
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.
Ultimately we would like to extract data on a nightly basis and dump it into
a Progress data warehouse. Any advice is greatly appreciated.
Thanks,
-Kristina
Ext. 2459
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.
------_=_NextPart_001_01C4857E.D6135060
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:eXclaimer =3D=20
"http://www.exclaimer.co.uk"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<TITLE>Message</TITLE>
<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><SPAN class=3D336295223-18082004><FONT face=3D"Comic Sans MS" =
color=3D#000080=20
size=3D2>Why not simply take your system down for an hour or so and =
move=20
the whole files to other disks? I am assuming your phdat =
logical=20
points to more than one disk.</FONT></SPAN></DIV>
<DIV><SPAN class=3D336295223-18082004><FONT face=3D"Comic Sans MS" =
color=3D#000080=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D336295223-18082004><FONT face=3D"Comic Sans MS" =
color=3D#000080=20
size=3D2>Then again... unless your raid sets are getting full, new =
drives are=20
cheap.</FONT></SPAN></DIV>
<DIV><SPAN class=3D336295223-18082004><FONT face=3D"Comic Sans MS" =
color=3D#000080=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D336295223-18082004><FONT face=3D"Comic Sans MS" =
color=3D#000080=20
size=3D2>---ehops</FONT></SPAN></DIV>
<DIV><SPAN class=3D336295223-18082004><FONT face=3D"Comic Sans MS" =
color=3D#000080=20
size=3D2>now an ex-powerhouser :(</FONT></SPAN></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> =
Deskin, Bob=20
[mailto:Bob.Deskin@Cognos.COM] <BR><B>Sent:</B> Wednesday, August 18, =
2004=20
10:21 AM<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><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=20
subfile. But if you're trying to report something, a subfile isn't =
it. You=20
should be able to redirect the QUIZ output disk file. The default =
name is=20
QUIZLIST. You should be able to assign QUIZLIST to another disk =
outside of=20
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 =
=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=20
7268 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 =
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]=20
<B>On Behalf Of </B>Pickering, John (NORBORD)<BR><B>Sent:</B> =
August 18,=20
2004 1:06 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=20
color=3D#0000ff><FONT size=3D2>I would <SPAN =
class=3D906591217-18082004>have=20
thought </SPAN>that just your time alone to dink around trying to =
force some=20
hokey solution would be a lot more valuable that simply buying more =
disc=20
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>=20
'powerh-l@lists.sowder.com'<BR><B>Subject:</B> Quiz=20
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=20
located on Disk 0 which has limited space. I am working on extracts =
that=20
retrieve quite a bit of data and ideally we want to redirect the =
output to=20
disk 1. I have been able to do so with the subfile but not with the =
textfile. I tried 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=20
in the Cognos book I have that you cannot specify a disk name with =
the SET=20
REPORT statement. So we started suppressing the text file and =
decided to use=20
the subfile. That has its own set of problems such as not being =
able to use=20
a 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. Any advice is greatly=20
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]--><=
SPAN=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=3DArial =
size=3D2>This=20
message may contain privileged and/or confidential information. =
If you=20
have received this e-mail in error or are not the intended recipient, =
you may=20
not use, copy, disseminate or distribute it; do not open any =
attachments,=20
delete it immediately from your system and notify the sender promptly =
by=20
e-mail that you have done so. Thank you.</FONT>=20
</P></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C4857E.D6135060--