Dictionary to SQL
Joe Boyle
atla38@dsl.pipex.com
Fri, 4 Feb 2005 22:59:51 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_0009_01C50B0D.3CDF6180
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
I think that someone is getting your question the wrong way around Harold. I
am 99.9% certain that 'set lang sql' works one way only, and that is to
create sql syntax (crudely) describing the tables in a relational database
which is in turn referenced in a PH dictionary.
There is a product called PHIntegrator which I suspect enables PH to process
relational tables as if they were RMS files; if someone would be kind enough
to correct me I would be very grateful :-)
Regards, Joe.
_____
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Johnson, Harold A
EDUC:EX
Sent: 04 February 2005 22:15
To: 'Goparaju, Vidyasagar'; 'Robert Edis'; PowerHouse List
Subject: RE: Dictionary to SQL
Sorry, but these commands don't react the way that you are describing. I'm
on OpenVMS 7.3 using an "Oracle" (yes, I was aware of that) RDB database, PH
v710g1.
This is what happens:
$QSHOW
>set lang sql (ok)
>gene database access_error_file (which is an RMS file defined in the
dictionary)
Default device is disc file QSHOGEN.SQL
>exit
The resulting QSHOGEN.SQL file is empty.
?
thnx
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Goparaju, Vidyasagar
Sent: 2005 February 4 1:08 PM
To: 'Robert Edis'; PowerHouse List
Subject: RE: Dictionary to SQL
It is generated based on Record definition of an RMS file.
Sagar
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Robert Edis
Sent: Friday, February 04, 2005 2:30 PM
To: PowerHouse List
Subject: RE: Dictionary to SQL
Sagar
If you mean the RDBMS "Rdb" it IS an Oracle database!
Has been for 10 years.
Did you run this against a record definition of an RMS
file or a RDBMS database definition?
Blue
--- "Goparaju, Vidyasagar"
<VGoparaju@tradepointsystems.com> wrote:
> You have to provide dictionary file/record name not
> dictionary name.
>
> For example, you have a file/record called EMPLOYEE
> in your dictionary.
>
> QSHOW
> >SET LANG SQL
> >GENE DATABASE EMPLOYEE
>
> Will create QSHOW.TXT file in your directory with
> the following information:
>
> Create Schema Authorization EOD:EMPDAT.DAT -->
> something for RDB. Not valid
> on Oracle Database.
>
> Create Table EMPLOYEE
> (
> EMP_NO Decimal(10) Not Null,
> EMP_NAME Char(30) Not Null,
> MODIFIED_BY Char(12) Not Null,
> DATE_UPDATED Decimal(8) Not Null,
> TIME_UPDATED Decimal(4) Not Null,
> FILLER Char(39) Not Null
> )
> Create Unique Asc Index EMP_NO_KEY
> On EMPLOYEE
> (
> EMP_NO
> )
>
>
> Sagar
>
>
>
>
> -----Original Message-----
> From: Johnson, Harold A EDUC:EX
> [mailto:Harold.A.Johnson@gems1.gov.bc.ca]
> Sent: Thursday, February 03, 2005 1:10 PM
> To: 'Goparaju, Vidyasagar'
> Cc: PowerH List
> Subject: RE: Dictionary to SQL
>
> This isn't documented in QSHOW help - when I try to
> run these commands,
>
> $QSHOW
> >set lang SQL
> >gene database <dict> ? what exactly is this,
> the short form of the
> dictionary in OpenVMS? thnx
> Default device is disc file QSHOGEN.SQL.
> The file
>
AVED$DISK5:[AVED.SFD.APPN.SFA.DEVE.SRC.SQL]QSHOGEN.SQL;
> already
> exists.
> Create new version?y
> *E* No valid files were specified in the GENERATE
> statement.
> > gene all
> *W* GENERATE target is not a relational database.
> >
> -----Original Message-----
> From: Goparaju, Vidyasagar
> [mailto:VGoparaju@tradepointsystems.com]
> Sent: 2005 February 3 10:44 AM
> To: Johnson, Harold A EDUC:EX
> Cc: PowerH List
> Subject: RE: Dictionary to SQL
> There is an option is QSHOW to create SQL script.
> $QSHOW
> >SET LANG SQL
> * GENE DATABASE <Dictionary file name>
> *
>
> Sagar
> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com [
> mailto:powerh-l-admin@lists.sowder.com
> <mailto:powerh-l-admin@lists.sowder.com> ]On Behalf
> Of Johnson, Harold A
> EDUC:EX
> Sent: Thursday, February 03, 2005 12:33 PM
> To: PowerH List
> Subject: Dictionary to SQL
> Anyone know how to convert a PH Dictionary (OpenVMS)
> to SQL? I think that
> there are 3rd party utilities to do this, but we are
> only doing it once and
> don't want buy anything.
> OR, is there some way to access the dictionary meta
> data and extract it
> directly? As a last resort, we will have to do the
> conversion by hand.
> cheers
> = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message
> body to
> powerh-l-request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> <http://lists.sowder.com/mailman/listinfo/powerh-l>
>
> This list is closed, thus to post to the list you
> must be a subscriber.
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
------=_NextPart_000_0009_01C50B0D.3CDF6180
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:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
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]-->
<title>RE: Dictionary to SQL</title>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:r_ansi;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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
{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.EmailStyle18
{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>
</head>
<body 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'>I think that someone is getting =
your
question the wrong way around Harold. I am 99.9% certain that ‘set =
lang
sql’ works one way only, and that is to create sql syntax =
(crudely) describing
the tables in a relational database which is in turn referenced in a PH
dictionary.<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'>There is a product called =
PHIntegrator
which I suspect enables PH to process relational tables as if they were =
RMS
files; if someone would be kind enough to correct me I would be very =
grateful </span></font><font
size=3D2 color=3Dnavy face=3DWingdings><span =
style=3D'font-size:10.0pt;font-family:
Wingdings;color:navy'>J</span></font><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>Johnson, Harold A =
EDUC:EX<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 04 February 2005 =
22:15<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Goparaju, =
Vidyasagar';
'Robert Edis'; PowerHouse List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Dictionary =
to SQL</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 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>Sorry, but these commands don't =
react the
way that you are describing. I'm on OpenVMS 7.3 using an
"Oracle" (yes, I was aware of that) RDB database, PH =
v710g1.</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 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>This is what =
happens:</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 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>$QSHOW</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>>set lang sql =
(ok)</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>>gene database
access_error_file (which is an RMS file defined in the =
dictionary)<br>
</span></font><font size=3D2 face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi'>Default device is disc file =
QSHOGEN.SQL</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>>exit</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 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>The resulting QSHOGEN.SQL file is =
empty.</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 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>?</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 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>thnx</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 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b>
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>Goparaju, =
Vidyasagar<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 2005 February 4 =
1:08 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Robert Edis'; =
PowerHouse List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Dictionary =
to SQL</span></font><o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>It is
generated based on Record definition of an RMS file.</span></font> =
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Sagar</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>-----Original
Message-----</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>From:
powerh-l-admin@lists.sowder.com [<a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>]On
Behalf Of Robert Edis</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Sent: Friday, February =
04, 2005
2:30 PM</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>To: PowerHouse =
List</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subject: RE: Dictionary =
to SQL</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Sagar</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>If you
mean the RDBMS "Rdb" it IS an Oracle database!</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Has been for 10 =
years.</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Did you
run this against a record definition of an RMS</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>file or a RDBMS database
definition?</span></font> <o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Blue</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>---
"Goparaju, Vidyasagar"</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'><VGoparaju@tradepointsystems.com>
wrote:</span></font> <o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>> You
have to provide dictionary file/record name not</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> dictionary =
name.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> For example, you =
have a
file/record called EMPLOYEE</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> in your =
dictionary.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> QSHOW</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> >SET LANG =
SQL</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> >GENE DATABASE =
EMPLOYEE</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Will create =
QSHOW.TXT file in
your directory with</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> the following =
information:</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Create Schema =
Authorization
EOD:EMPDAT.DAT --></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> something for RDB. =
Not valid</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> on Oracle =
Database.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Create Table =
EMPLOYEE</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
(</span></font>
<br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
EMP_NO Decimal(10) Not Null,</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
EMP_NAME Char(30) Not Null,</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
MODIFIED_BY Char(12) Not Null,</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
DATE_UPDATED Decimal(8) Not Null,</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
TIME_UPDATED Decimal(4) Not Null,</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
FILLER Char(39) Not Null</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
)</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Create Unique
Asc Index EMP_NO_KEY</span></font> =
<br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
On EMPLOYEE</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
(</span></font>
<br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>> =
EMP_NO</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
)</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sagar</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> -----Original =
Message-----</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> From: Johnson, =
Harold A
EDUC:EX</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> [<a
href=3D"mailto:Harold.A.Johnson@gems1.gov.bc.ca">mailto:Harold.A.Johnson@=
gems1.gov.bc.ca</a>]</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sent: Thursday, =
February 03,
2005 1:10 PM</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> To: 'Goparaju, =
Vidyasagar'</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Cc: PowerH =
List</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Subject: RE: =
Dictionary to SQL</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> This isn't =
documented in QSHOW
help - when I try to</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> run these =
commands,</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
$QSHOW</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> >set lang =
SQL</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> >gene database
<dict> ? what exactly is =
this,</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> the short form of =
the</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> dictionary in
OpenVMS? thnx</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Default device is =
disc file
QSHOGEN.SQL.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> The =
file</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>></span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>AVED$DISK5:[AVED.SFD.APPN.SFA.DEVE.SRC.SQL]QSH=
OGEN.SQL;</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
already</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
exists.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Create new =
version?y</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> *E* No valid files =
were
specified in the GENERATE</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
statement.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > gene =
all</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> *W* GENERATE target =
is not a
relational database.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> ></span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> -----Original =
Message-----</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> From: Goparaju, =
Vidyasagar</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> [<a
href=3D"mailto:VGoparaju@tradepointsystems.com">mailto:VGoparaju@tradepoi=
ntsystems.com</a>]</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sent: 2005 February =
3 10:44 AM</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> To: Johnson, Harold =
A EDUC:EX</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Cc: PowerH =
List</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Subject: RE: =
Dictionary to SQL</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> There is an option =
is QSHOW to
create SQL script.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
$QSHOW</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>>
>SET LANG SQL</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> * GENE DATABASE =
<Dictionary
file name></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> *</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sagar</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> -----Original =
Message-----</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> From:
powerh-l-admin@lists.sowder.com [</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a></span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <<a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>>
]On Behalf</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Of Johnson, Harold =
A</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
EDUC:EX</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sent: Thursday, =
February 03,
2005 12:33 PM</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> To: PowerH =
List</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Subject: Dictionary =
to SQL</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Anyone know how to =
convert a
PH Dictionary (OpenVMS)</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> to SQL? =
I think
that</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> there are 3rd party =
utilities
to do this, but we are</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> only doing it once =
and</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> don't want buy =
anything.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> OR, is there some =
way to
access the dictionary meta</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> data and extract =
it</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
directly? As a
last resort, we will have to do the</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> conversion by =
hand.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
cheers</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =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</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =3D =
=3D</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Mailing list:
powerh-l@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Subscribe:
"subscribe" in message body to</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <st1:PersonName =
w:st=3D"on">powerh-l-request@lists.sowder.com</st1:PersonName></span></fo=
nt>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Unsubscribe: =
"unsubscribe
<password>" in message</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> body =
to</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <st1:PersonName =
w:st=3D"on">powerh-l-request@lists.sowder.com</st1:PersonName></span></fo=
nt>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a></=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <<a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a>&g=
t;</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> This list is =
closed, thus to
post to the list you</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> must be a =
subscriber.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>></span></font> =
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>=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</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Mailing list: =
powerh-l@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subscribe: =
"subscribe" in
message body to <st1:PersonName =
w:st=3D"on">powerh-l-request@lists.sowder.com</st1:PersonName></span></fo=
nt>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Unsubscribe: =
"unsubscribe
<password>" in message body to <st1:PersonName =
w:st=3D"on">powerh-l-request@lists.sowder.com</st1:PersonName></span></fo=
nt>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'><a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a></=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>This list is closed, =
thus to post
to the list you must be a subscriber.</span></font> <o:p></o:p></p>
</blockquote>
</div>
</body>
</html>
------=_NextPart_000_0009_01C50B0D.3CDF6180--