Dictionary to SQL
Goparaju, Vidyasagar
VGoparaju@tradepointsystems.com
Thu, 3 Feb 2005 13:43:46 -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_001_01C50A20.4ABDC870
Content-Type: text/plain;
charset="iso-8859-1"
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]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
This list is closed, thus to post to the list you must be a subscriber.
------_=_NextPart_001_01C50A20.4ABDC870
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2657.73">
<TITLE>RE: Dictionary to SQL</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>There is an option is QSHOW to create SQL =
script.</FONT>
</P>
<P><FONT SIZE=3D2>$QSHOW</FONT>
<BR><FONT SIZE=3D2> >SET LANG =
SQL</FONT>
<BR><FONT SIZE=3D2>* GENE DATABASE <Dictionary file name></FONT>
<BR><FONT SIZE=3D2>* </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Sagar</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: powerh-l-admin@lists.sowder.com [<A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>]On Behalf Of Johnson, Harold A EDUC:EX</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, February 03, 2005 12:33 PM</FONT>
<BR><FONT SIZE=3D2>To: PowerH List</FONT>
<BR><FONT SIZE=3D2>Subject: Dictionary to SQL</FONT>
</P>
<P><FONT SIZE=3D2>Anyone know how to convert a PH Dictionary (OpenVMS) =
to SQL? I think that</FONT>
<BR><FONT SIZE=3D2>there are 3rd party utilities to do this, but we are =
only doing it once and</FONT>
<BR><FONT SIZE=3D2>don't want buy anything.</FONT>
<BR><FONT SIZE=3D2>OR, is there some way to access the dictionary meta =
data and extract it</FONT>
<BR><FONT SIZE=3D2>directly? As a last resort, we will have =
to do the conversion by hand.</FONT>
</P>
<P><FONT SIZE=3D2>cheers</FONT>
</P>
<P><FONT SIZE=3D2>=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</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A><=
/FONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C50A20.4ABDC870--