ksam file into pdl
Deskin, Bob
Bob.Deskin@Cognos.COM
Fri, 24 Jan 2003 07:47:18 -0500
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_000_01C2C3A6.BAD1BC10
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C2C3A6.BAD1BC10"
------_=_NextPart_001_01C2C3A6.BAD1BC10
Content-Type: text/plain;
charset="iso-8859-1"
Unfortunately, there is no "file information" to import. Unlike IMAGE, KSAM
does not have a built-in layout. The only structure information in the file
is the index information and that is only position, length, and datatype. So
unless someone knows of something magical, you'll have to type it in - but
only once. Of course if you have a 3GL program, you might be able to get
much of the basic information in a form that could be edited. COBOL is
probably closest.
Bob Deskin
PowerHouse Web 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: Jeff Wilson [mailto:jeffw@brazoria-county.com]
Sent: Thursday, January 23, 2003 5:29 PM
To: powerh-l@lists.swau.edu
Subject: ksam file into pdl
Sensitivity: Private
I need to access several (15 to 20 of various sizes) KSAM files via
Powerhouse (QTP to be exact). Is there a way to 'import' the file
information into the data dictionary without having to type in all the field
names and file specs? I'm in a HP-3000/MPE environment using Powerhouse
8.19.
Thanks in advance!
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_01C2C3A6.BAD1BC10
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=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4919.2200" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D272174512-24012003>Unfortunately, there is no "file =
information" to=20
import. Unlike IMAGE, KSAM does not have a built-in layout. The only =
structure=20
information in the file is the index information and that is only =
position,=20
length, and datatype. So unless someone knows of something magical, =
you'll have=20
to type it in - but only once. Of course if you have a 3GL program, you =
might be=20
able to get much of the basic information in a form that could be =
edited. COBOL=20
is probably closest.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D272174512-24012003>
<P><FONT face=3DArial size=3D2>Bob=20
Deskin =
=20
</FONT><BR><FONT face=3DArial size=3D2>PowerHouse Web Product Manager, =
Application=20
Development Tools, Cognos Inc.</FONT> <BR><FONT face=3DArial=20
size=3D2>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) =
727-1178</FONT>=20
<BR><FONT face=3DArial size=3D2>3755 Riverside Drive P.O. Box 9707 Stn. =
T, Ottawa ON=20
K1G 4K9 CANADA</FONT> </P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Jeff Wilson=20
[mailto:jeffw@brazoria-county.com]<BR><B>Sent:</B> Thursday, January =
23, 2003=20
5:29 PM<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B> ksam =
file=20
into pdl<BR><B>Sensitivity:</B> Private<BR><BR></FONT></DIV>
<DIV><SPAN class=3D729362722-23012003><FONT face=3DArial size=3D2>I =
need to access=20
several (15 to 20 of various sizes) KSAM files via Powerhouse =
(QTP to be=20
exact). Is there a way to 'import' the file information into =
the data=20
dictionary without having to type in all =
the field names and=20
file specs? I'm in a HP-3000/MPE environment using Powerhouse=20
8.19.</FONT></SPAN></DIV>
<DIV><SPAN class=3D729362722-23012003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D729362722-23012003><FONT face=3DArial =
size=3D2>Thanks in=20
advance!</FONT></SPAN></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><IMG height=3D59 =
src=3D"cid:272174512@24012003-26d9" width=3D244=20
v:shapes=3D"_x0000_i1025"> </P></DIV>
<DIV><FONT face=3DArial =
size=3D2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">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>
<P><FONT SIZE=3D2 FACE=3D"Arial"> </FONT> </P>
------_=_NextPart_001_01C2C3A6.BAD1BC10--
------_=_NextPart_000_01C2C3A6.BAD1BC10
Content-Type: application/octet-stream;
name="image001.gif"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="image001.gif"
Content-ID: <272174512@24012003-26d9>
R0lGODlh9AA7APcAAEJaa0Jac0pac0pjc0pje0prhFJjc1Jre1JzjFpre1prhFpzhFp7lFp7nGNz
hGNzjGN7nGOEnGt7hGt7jGuEjGuEnGuEpWuMpXOElHOMpXuElHuMlHuMnHuUrYSEhISMnISUnISU
pYScrYSctYyMjIyUnIycpYycrYyctYyltZSUlJScpZScrZSlrZSltZSlvZStvZycnJyltZytvZyt
xpy1xqWlpaWttaW1vaW1xq2tra21va21xq29xq29zrW1tbW9xrW9zrXGzrXG1r29vb3Gzr3G1r3O
1r3O3sbGxsbOzsbO1sbO3sbW3s7Ozs7O1s7W1s7W3s7W587e59bW1tbW3tbe3tbe59be79bn59bn
797e3t7e597n597n7+fn5+fn7+fv7+fv9+/v7+/v9+/39/f39/f3//f/////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////ywAAAAA9AA7AAAI/gDTCBxI
sKDBgwgTKlzIsKHDhxAjSpxIsaLFixgzatzIsaPHjyBDihxJsqTJkyhTqlzJsqXLNGgKmok50MzL
mzhzVjxD0EwZm2bIlIFJJgyZoEaR2jxjxmYaMzxh6pxKFSXNp1GFPg3jBUxMMFe8lLkipUuasVLE
XglLZq2YNGSyiGkaZq7PqFXz6rV4hmbQMjzJgAnDtMsVpleiXGmKJayZLGGfeulydDKYMl68jEFD
pgsYuFcue+ES5izevahT94T6VMwYqGHC/vSiGDBX2F7I8Cxz9ClrrDZ/8vQ5kEzMoD7DhjHjpbRT
1dBzMoUZFEzzomt/ghULF8zcNHiP/he8SjGmUKbXL0dfD7JLlPc23b8/unuw7jFXpsgm03Woz6Vn
wcdSGGU9x96BPb2nYBQGGtRFAQQQMECEEEoYoQ+EdTGEEaXxZ0VZfTW11hhlwLdEhBEusVJbUniF
4ItpnGjhjCoeBIaEAQCQ4wACCKAjABN2YUSEE16RhhAoFpHGFQeg6OQBAfg4YYMlnREbYTAeSAaO
APwIJAFUnoHAAAMAAZQAA+zgnwAEXEGAj2gScMSbALBpBJRwDlAnmQB0wQUABESh0hlFnZYldDf2
yYWfowEaRRhRNKGYGVG8iQMXJtQJwA1dsFBnAAQUMUAIXRTB5psmpGHCqQIocQUI/gH4CaiiAQzw
aGKTDiRfFGY9BR9tH1K5EGalHcrelgPkmOOitSJApIU+6OmnAThOO+EBSxgxgAKy4qhEGkrUSoCi
CwDAbLLMEuDshCgu4aaTKT6L4oQ1LoRGU4IZZyx7Mk6oKKA8aiquj4vqSHAXBhNQ4rh+JiDhAEBN
OEACzPoYJcNc1BpwjnFKqOmeXPao6YRKKnTGGFpcRt6+0VHaxLhceLHnpU9BwYGPjF7RRayLngtG
F28W0cXNA3Aw0AZoclAqzn9iXKsBO2zBlBItCBDAAkmUNgYQCei5qAI7jJFGFxqAKuhB95YBRllk
sMxeU0wNSasBXIyBAQAOVDE0/tNdHpxw2xKy0MUNUQJxVhpA1MkpC9JmnKysARguAwAHgMCFAAl0
8YUDATjwRRgJ8GxCuVB3MQGbBWVlXxhDuQ1dX2NkFsYQPGbx5w5DAyqABF1UoaOf4tI6YRMCRTtB
F0/kKPYGaYyhIxWmwyyz0wDYtKeUQOxNJvNACGD7lwMcwAUUgBop0H9WZmGcsK5TVYYYRm1Hxom0
+glnnVl0wXTwwNs60IkDKBgG0vAEc6XhdIbxV/94lqO2dQEIJgidoqilLQI0j1aB0tNoahWFe3Gm
OVD5Tfv00hS1rcUo56lUn2TWsy4Yxk8IC8C5xrVB/wnkCnqyAhcWcIM0gGAA/itIww0c4AUrzOpc
AGhU0Z5jhkzFzFHjEggDbYUxQDVhDHPhD5ZGiBr+UEYMXZjLGUr0HpjtzE96itKP9qdAx50tDWF4
E+4+8IUyoMkAZ9iCCbqwAzRNcYoCOIAJgPCZMfCMTNoaQPN4BkXhMcE6P2kKF/MyxspI4Qq6mUmM
niUAB3yvClkogbgChq6dtdFsBEGAAEBwhSU8kE0AUALyuvABUAmPkclCU5eeAoDsIe1NA+ye7WrF
hMe58TyT3AtmMDkG1j2HDAewGAASoAQufGAAGFjUNQEANjN0qVEREt4b06CtzC0KA2wqWsy40CRj
1opW5jKBAQIQxB0EIHOb/gMA78aQgH8RAEniXFkypQObK3ABMOAhyI0C4BQzPAGdyZpA9s7HBRCw
kYZNG6cKYQioEwnghYAyoy37t4IiOMV3PEqAEMQ2hiJ0TYamDAJGHTXQqpjBOkJBpkHGACUvxQlJ
AVuj7jgWIYuxyUBmCBmoxuCxKLErWXV6E1Gt1qWXtlNZOpqQUQkQR4tNCSOGqilf8INJ8SCECe18
FhPSUKlnXWtOFmpCvwhAvIK0VUIHWOvLZhSFue51ePNCURnldQAkWUhFcKXXQMLKkJk0RaAIOQ1j
k2kG+HmHfQNJWxSY8J4rkOcLU1DQYnzFoPMJ6CBmSMxoTVsFKTRUQJQq/q0ZuLDZJTShKV6QwhI4
a4QmHKUMnHWsGcbAhCUg1LEJdYhjhQK3hjRFk2KtiRccwxCmBIVEzBXhZAUCWfIYarvJFUhU7sXc
3FqhMqSZiXUJYl0xDCYp/4lkeJ/C3poUBQyf+4lUFluTp5SBN4+NLlymIIXN2CsoX7AMGAYTSccO
hyn3SmgIQ2hd6wo3hE+5F4SB8lyolKGZPvFCE1rkhSnkxifIfCyG6TIanRmlmfYRjorpO5wQliEM
htEZiYAyHeGSdwzv7Q14WUagLGB2sSYUrRU8w9zfxvcoHebNh3/yk5y+xsoA/ouWbzwao3RhxF0I
AxekMIXPMZc3Y3By/k7/Ux0rZIABURjMdA3ahR3nNMs+kXKawcIABnABDGv+73N5Q4aiTCY0y4Hu
QAkUBX0pJCju6XOfO2AEz4RhMJi+tKaF8uFLL9jSC/ZCgi89GVF3xXYujNmlW8mELOR2t2Gxzhdi
DGTLhMHTYcZ0UbogBAaIIDSG6QADMoBoT2v6MmSo9YJxfIU+62zZC15dpvnMAET3BrJuS20TvCBC
1MYuCn1eQhCGvZa1cGEtfrqCFdBNai5AptxcWLe6dZaY4r6HCUfY7RGMoJjEHIEJa6lCEz4kb3TL
Wd39zrEOdeaZ6YqAAUL4cxaWIOkl/DnH5bb0ua+A6un2ud/rzrFn/jC+KCn0uQou7vYkubJmDzYI
0k3oc3E/Dm4G9ODNrRwBBBiAAl655+HChnPNafDm91SgzxnowRB6zYAXQCACPZgBBCDQA3X3WeoV
8IHUqb6oK6Rg5x0oQmL6zAOc+4niGSgLWGYwbAbQgN5Xf3oPYtYFCyA9CFaHsxEYUAGjM6DSRgh6
BqwgaWdfZsgsww2JRjMX4TzlZzU3gg8Y0IH3FB7OI7D5uEegmIfTgOJ/H8LlpRAFIQxh3BGY+d+L
0GcjHIHvUTD530G/hNdXYC0u+HuvB19zSRv0CjBgQA6AfYWj770CoGw2A7LF97D0LgrHj/3Hr/Bm
H4y7A+o++hL6/l3z2HtG0WJFTluiwO2u3Gu6tC18B4LAhJgzgP2bbf3eIXCEKOzcB3t//+QZgP8o
WOEIKHABkiZ9cCZ7lid0NJeADNBaEXB5V1AFModyhmF/EBAFsyYklMcEwmYEY8cAUkB4ftYFTOAC
b/ZxELiAVzB5GfBwEXcFdpcBLnAEHcgrgwEgAnY+rjEbhJFaZVFzPpAtQ5BvfRYETXAFRrBzQpB/
/NZ6oGcEoNdvxcd/oFcFNUeFClgFU6CAa0FzO8cEVoByW7iApWYFOcAAMBAaYJF7hecCB4iFzsYF
Ash+ffaBbzgFJUhs53YEKWB3fVeFTAZ+N7hf+lVZPyN7HPgh/gfIgV/2cD7QAzwXBVMgbD3wegzA
WR/XBUW0c7U3hzVHhwsoe2H4gM6mfO+RAgzAA6T3a8qHaLTxZu7yM1OgfboFe91XhVegiU9Yc79X
hvxHb+9hex/YhVOQXoh3gz4BBiBYBc3BFd3nGYmBAgwAASlgcVdwBG/2cAjogbN2BT2wc9CIgs52
gh0oitW2iif4gUzwAkfXAXO3ioPBBb0mAnGGY9enN9THAEMAggeoGN3IAJlXjs5mGI6YAXrjBVVQ
gmG3Fj1wdBAQGvoViApxLz/zgJ7BG2KWGJ7RTOm2bnQncOJGeYqBhX+2agSnH11nUO92ku6GbumW
YxLIBVMg/m8XZ3BilnlBQBrYgZEtRmfm1gUf+Hv+95PppjPn9mbD946h1VmHpm5lsRzFaIz3dR34
QmpJwRvWYWmr1oCU94rLJhQw1hWzhmuehmnWYWx1EW1UCWSy1hwwNhhABm7ERhlIMWptaWxkeWtX
KWt4iZeT13dhdl8jFwZpxhXL9hr7BZEIkTbZFSKEBjclVGiEJmYhuRZfIAZTZmOcxml/8Vuclmb/
lV2aGWh65mEAdmNgYDuaMWhZ9plU1mRURmieyZm7Zm5VWWjJ9mQ71heI6VwZ1l/IdT4b9hT3VZZJ
MR3iARRYcS9AEWHItZzNGWA8FmE9NkZAZhT6hQbDgZ30/hVCLgcgPsad16Vpg+hyEmZd2LabGzFo
a3ZkKDFod/ER7qly6OkSPRYT2+UBg2KDFkEFHoCf44FhT5kQ/jmfAtGf/ekEE3GeE7EFNtCfKkAF
F+EB7Fmg/ck+KvAFIDGgFfEFDeoBNgChDqGhOSGhafAFIqoSW0ACVGATW/ADEfoQJIoQJ7oRMVoR
KoCgZsChMDqhKeGfVGADAyGhOuCfJHCgFFqhzRMDHhADGJoGQoqfMVqkHoCgBREDIFoQY6CkTFqg
QWoTHvADRYqgBiqhMbAFabAFMXAQA/qlRjqmw6WlTfqkTjqkHpAEdEqlaSClYmqgZuCfXwCnBQqm
U2oQ/h4gNgWhAmaKpgLhBP0JpG5qBkpKAmY6p/1pp0aaBk5QpEDKEWOqA4Y6pQ1iojVhpwJhA0mQ
BkSwqaDKpQQhqgVRowRhqqiqqkFaoE5gBilaoE6RBC76A6dKqE4xqFvgnzEqq6lqq8F6q8OqrCRQ
EK4ao/5prKrKrAaRBCSgA0nQpGnAq2ngqwX6Gr9arBD6Bc3qpMoKqrnqpODaESRqBk6Qpk7aqjYg
pQPxBSoQrOdDrARBohyqAv0JrGqar6zqpF5aqwR7Ps16rwGrq6y6pvgarwYLsRDbr/8qsSQKrQM7
o2PgBD8QA1RqBgnrFDFgA7easW5qsQarAiTLoxCh/qHE+hwk4ARi459mcKEG26cDC7EkkAQzaxBW
urA4i7IHC7EaaqqbSqgRe7Fd2rDP4bCsurM9O7Qvy7Q5axBBmwZGSxBOoAPwCq0NgrEMi6lcy67n
kwRdu68Yyp8CoQN4irVEsK2q2rQFmrYnSgUqyqKbagNvmwSqugXuqq8MSwLayp9X+qpLS7ROIa05
C7YHW6hpwJ82Ibisqrdwm7ENYgNmagZmOxCEOxBEMFxE2qR62xQ6YLms+rljMKMWMaY28Kla259E
cLF8mqRLGqf7ahOM6gGxSyVo6qBvS7tbiqmwq7Ssyp80W66EiqROO6B/uqSfKrdh65+5G7sCYbwQ
R5ulHqACz1u126qkHmqoT4G8aTCkMVu9/2oGDXqjGbu05Nu26TkRLJsTHJsQ8bse80ugqGGzgSi5
+Nu//vu/ABzAAjyfAQEAADs=
------_=_NextPart_000_01C2C3A6.BAD1BC10--