PH and text files
Joe Boyle
atla38@dsl.pipex.com
Wed, 13 Apr 2005 07:22:32 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_005A_01C53FF9.90261A70
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
One way is to map a sequential file into a dictionary and then read the
records via that.
Alternatively, you could create a subfile and then copy the txt file over
the .sf part.
In either case you might have to use the RMS covert command to modify the
file into a fixed rather than variable format; I'm sure that there are KB
docs available from Cognos on all of the above if you get stuck.
Then again, if you mean is there a standardized PH command to unstring the
text within the commas, then I'm afraid you will have to make lots of use of
the index function and write them out to defines mapped to a subfile perhaps
- or report them directly.
Regards, Joe.
_____
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Aci Polajnar
Sent: 13 April 2005 06:31
To: PowerH List
Subject: PH and text files
Hi there
Anybody, is there a way to read variable length text file, comma delimited
usinq QUIZ. My platform is ALPHA/VMS and PH-710G
Thanks and best regards!
--
________________________________________________________________
Aci Polajnar Tel : +386(0)3 4274174
IS Consultant Fax : +386(0)3 4274198
Razvojni Center Celje e-mail: acip@rcc-irc.si
3000 Celje, Slovenia URL : http://www.rcc-irc.si
________________________________________________________________
------=_NextPart_000_005A_01C53FF9.90261A70
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>One way is to map a sequential file =
into a
dictionary and then read the records via that. =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Alternatively, you could create a =
subfile
and then copy the txt file over the .sf part. =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>In either case you might have to =
use the
RMS covert command to modify the file into a fixed rather than variable =
format;
I’m sure that there are KB docs available from Cognos on all of =
the above
if you get stuck.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Then again, if you mean is there a =
standardized
PH command to unstring the text within the commas, then I’m afraid =
you
will have to make lots of use of the index function and write them out =
to
defines mapped to a subfile perhaps – or report them =
directly.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'> <o:p></o:p></span></font></p>
</div>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Aci Polajnar<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 13 April 2005 =
06:31<br>
<b><span style=3D'font-weight:bold'>To:</span></b> PowerH List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> PH and text =
files</span></font><o:p></o:p></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hi there</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Anybody, is there a way to read variable length text =
file,
comma delimited usinq QUIZ. My platform is ALPHA/VMS and =
PH-710G</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks and best regards!</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>-- <br>
________________________________________________________________</span></=
font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Aci =
Polajnar  =
;
Tel : +386(0)3 4274174<br>
IS
Consultant &nb=
sp;
Fax : +386(0)3 4274198<br>
Razvojni Center Celje =
e-mail: <a
href=3D"mailto:acip@rcc-irc.si">acip@rcc-irc.si</a><br>
3000 Celje, =
Slovenia
URL : <a =
href=3D"http://www.rcc-irc.si">http://www.rcc-irc.si</a><br>
________________________________________________________________</span></=
font><o:p></o:p></p>
</div>
</div>
</body>
</html>
------=_NextPart_000_005A_01C53FF9.90261A70--