Dictionary to SQL
Deskin, Bob
Bob.Deskin@Cognos.COM
Thu, 3 Feb 2005 14:19:07 -0500
This is a multi-part message in MIME format.
------_=_NextPart_001_01C50A25.3B59682B
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I tried this in the Windows version. You can generate the SQL for a
relational database, but you can't generate SQL from non-relational
files.
=20
I'll make a note about the documentation.
=20
Bob
-----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: February 3, 2005 2:10 PM
To: 'Goparaju, Vidyasagar'
Cc: PowerH List
Subject: RE: Dictionary to SQL
=09
=09
This isn't documented in QSHOW help - when I try to run these
commands,
=20
$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.
>=20
-----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
=09
=09
There is an option is QSHOW to create SQL script.=20
$QSHOW=20
>SET LANG SQL=20
* GENE DATABASE <Dictionary file name>=20
*=20
Sagar=20
-----Original Message-----=20
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Johnson, Harold A
EDUC:EX=20
Sent: Thursday, February 03, 2005 12:33 PM=20
To: PowerH List=20
Subject: Dictionary to SQL=20
Anyone know how to convert a PH Dictionary (OpenVMS) to
SQL? I think that=20
there are 3rd party utilities to do this, but we are
only doing it once and=20
don't want buy anything.=20
OR, is there some way to access the dictionary meta data
and extract it=20
directly? As a last resort, we will have to do the
conversion by hand.=20
cheers=20
=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=20
Mailing list: powerh-l@lists.sowder.com=20
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com=20
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com=20
http://lists.sowder.com/mailman/listinfo/powerh-l=20
This list is closed, thus to post to the list you must
be a subscriber.=20
=20
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.=20
=20
------_=_NextPart_001_01C50A25.3B59682B
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16"><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD><BODY =
><DIV>
<DIV><SPAN class=3D016151819-03022005><FONT face=3DArial color=3D#0000ff =
size=3D2>I=20
tried this in the Windows version. You can generate the SQL for a =
relational=20
database, but you can't generate SQL from non-relational=20
files.</FONT></SPAN></DIV>
<DIV><SPAN class=3D016151819-03022005><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D016151819-03022005><FONT face=3DArial color=3D#0000ff =
size=3D2>I'll=20
make a note about the documentation.</FONT></SPAN></DIV>
<DIV><SPAN class=3D016151819-03022005><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D016151819-03022005><FONT face=3DArial color=3D#0000ff =
size=3D2>Bob</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com] <B>On=20
Behalf Of </B>Johnson, Harold A EDUC:EX<BR><B>Sent:</B> February 3, =
2005 2:10=20
PM<BR><B>To:</B> 'Goparaju, Vidyasagar'<BR><B>Cc:</B> PowerH=20
List<BR><B>Subject:</B> RE: Dictionary to SQL<BR><BR></FONT></DIV>
<DIV><SPAN class=3D739440719-03022005><FONT face=3DArial =
color=3D#0000ff size=3D2>This=20
isn't documented in QSHOW help - when I try to run these=20
commands,</FONT></SPAN></DIV>
<DIV><SPAN class=3D739440719-03022005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D739440719-03022005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>$QSHOW</FONT></SPAN></DIV>
<DIV><SPAN class=3D739440719-03022005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>>set lang SQL</FONT></SPAN></DIV>
<DIV><SPAN class=3D739440719-03022005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>>gene database <dict> =
? what=20
exactly is this, the short form of the dictionary in =
OpenVMS? =20
thnx</FONT></SPAN></DIV>
<DIV><SPAN class=3D739440719-03022005><FONT face=3Dr_ansi size=3D2>
<P>Default device is disc file QSHOGEN.SQL.</P>
<P>The file AVED$DISK5:[AVED.SFD.APPN.SFA.DEVE.SRC.SQL]QSHOGEN.SQL; =
already=20
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=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> Goparaju, =
Vidyasagar=20
[mailto:VGoparaju@tradepointsystems.com]<BR><B>Sent:</B> 2005 =
February 3=20
10:44 AM<BR><B>To:</B> Johnson, Harold A EDUC:EX<BR><B>Cc:</B> =
PowerH=20
List<BR><B>Subject:</B> RE: Dictionary to SQL<BR><BR></FONT></DIV>
<P><FONT size=3D2>There is an option is QSHOW to create SQL =
script.</FONT>=20
</P>
<P><FONT size=3D2>$QSHOW</FONT> <BR><FONT=20
size=3D2> >SET LANG SQL</FONT> =
<BR><FONT=20
size=3D2>* GENE DATABASE <Dictionary file name></FONT> =
<BR><FONT=20
size=3D2>* </FONT></P><BR>
<P><FONT size=3D2>Sagar</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
powerh-l-admin@lists.sowder.com [<A=20
=
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</A>]On=20
Behalf Of Johnson, Harold A EDUC:EX</FONT> <BR><FONT size=3D2>Sent: =
Thursday,=20
February 03, 2005 12:33 PM</FONT> <BR><FONT size=3D2>To: PowerH =
List</FONT>=20
<BR><FONT size=3D2>Subject: Dictionary to SQL</FONT> </P>
<P><FONT size=3D2>Anyone know how to convert a PH Dictionary =
(OpenVMS) to=20
SQL? I think that</FONT> <BR><FONT size=3D2>there are =
3rd party=20
utilities to do this, but we are only doing it once and</FONT> =
<BR><FONT=20
size=3D2>don't want buy anything.</FONT> <BR><FONT size=3D2>OR, is =
there some=20
way to access the dictionary meta data and extract it</FONT> =
<BR><FONT=20
size=3D2>directly? As a last resort, we will have to do =
the=20
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=20
=3D</FONT> <BR><FONT size=3D2>Mailing list: =
powerh-l@lists.sowder.com</FONT>=20
<BR><FONT size=3D2>Subscribe: "subscribe" in message body to=20
powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2>Unsubscribe:=20
"unsubscribe <password>" in message body to=20
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=3D2><A=20
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
=
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FO=
NT>=20
<BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
subscriber.</FONT> </P></BLOCKQUOTE></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV>
<P> <FONT FACE=3D"Arial" =
SIZE=3D"2">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>
</DIV></BODY></HTML>
------_=_NextPart_001_01C50A25.3B59682B--