Dictionary to SQL
Johnson, Harold A EDUC:EX
Harold.A.Johnson@gems1.gov.bc.ca
Thu, 3 Feb 2005 11:09:49 -0800
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_01C50A23.A4620DB1
Content-Type: text/plain;
charset="iso-8859-1"
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.
------_=_NextPart_001_01C50A23.A4620DB1
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Dictionary to SQL</TITLE>
<META content="MSHTML 6.00.2800.1480" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=739440719-03022005><FONT face=Arial color=#0000ff size=2>This
isn't documented in QSHOW help - when I try to run these
commands,</FONT></SPAN></DIV>
<DIV><SPAN class=739440719-03022005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=739440719-03022005><FONT face=Arial color=#0000ff
size=2>$QSHOW</FONT></SPAN></DIV>
<DIV><SPAN class=739440719-03022005><FONT face=Arial color=#0000ff
size=2>>set lang SQL</FONT></SPAN></DIV>
<DIV><SPAN class=739440719-03022005><FONT face=Arial color=#0000ff
size=2>>gene database <dict> ? what
exactly is this, the short form of the dictionary in OpenVMS?
thnx</FONT></SPAN></DIV>
<DIV><SPAN class=739440719-03022005><FONT face=r_ansi size=2>
<P>Default device is disc file QSHOGEN.SQL.</P>
<P>The file AVED$DISK5:[AVED.SFD.APPN.SFA.DEVE.SRC.SQL]QSHOGEN.SQL; already
exists.</P>
<P>Create new version?y</P>
<P>*E* No valid files were specified in the GENERATE statement.</P>
<P>> gene all</P>
<P>*W* GENERATE target is not a relational database.</P>
<P>> </P></FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Goparaju, Vidyasagar
[mailto:VGoparaju@tradepointsystems.com]<BR><B>Sent:</B> 2005 February 3 10:44
AM<BR><B>To:</B> Johnson, Harold A EDUC:EX<BR><B>Cc:</B> PowerH
List<BR><B>Subject:</B> RE: Dictionary to SQL<BR><BR></FONT></DIV>
<P><FONT size=2>There is an option is QSHOW to create SQL script.</FONT> </P>
<P><FONT size=2>$QSHOW</FONT> <BR><FONT size=2>
>SET LANG SQL</FONT> <BR><FONT size=2>* GENE DATABASE <Dictionary file
name></FONT> <BR><FONT size=2>* </FONT></P><BR>
<P><FONT size=2>Sagar</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
powerh-l-admin@lists.sowder.com [<A
href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>]On
Behalf Of Johnson, Harold A EDUC:EX</FONT> <BR><FONT size=2>Sent: Thursday,
February 03, 2005 12:33 PM</FONT> <BR><FONT size=2>To: PowerH List</FONT>
<BR><FONT size=2>Subject: Dictionary to SQL</FONT> </P>
<P><FONT size=2>Anyone know how to convert a PH Dictionary (OpenVMS) to
SQL? I think that</FONT> <BR><FONT size=2>there are 3rd party
utilities to do this, but we are only doing it once and</FONT> <BR><FONT
size=2>don't want buy anything.</FONT> <BR><FONT size=2>OR, is there some way
to access the dictionary meta data and extract it</FONT> <BR><FONT
size=2>directly? As a last resort, we will have to do the
conversion by hand.</FONT> </P>
<P><FONT size=2>cheers</FONT> </P>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT size=2>Mailing list: powerh-l@lists.sowder.com</FONT> <BR><FONT
size=2>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2>Unsubscribe:
"unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be a
subscriber.</FONT> </P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C50A23.A4620DB1--