Dictionary to SQL
Goparaju, Vidyasagar
VGoparaju@tradepointsystems.com
Fri, 4 Feb 2005 16:08:01 -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_01C50AFD.9BF82D06
Content-Type: text/plain;
charset="iso-8859-1"
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_001_01C50AFD.9BF82D06
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>It is generated based on Record definition of an RMS =
file.</FONT>
</P>
<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 Robert Edis</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, February 04, 2005 2:30 PM</FONT>
<BR><FONT SIZE=3D2>To: PowerHouse List</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Dictionary to SQL</FONT>
</P>
<P><FONT SIZE=3D2>Sagar</FONT>
</P>
<P><FONT SIZE=3D2>If you mean the RDBMS "Rdb" it IS an Oracle =
database!</FONT>
<BR><FONT SIZE=3D2>Has been for 10 years.</FONT>
</P>
<P><FONT SIZE=3D2>Did you run this against a record definition of an =
RMS</FONT>
<BR><FONT SIZE=3D2>file or a RDBMS database definition?</FONT>
</P>
<P><FONT SIZE=3D2>Blue</FONT>
</P>
<P><FONT SIZE=3D2>--- "Goparaju, Vidyasagar"</FONT>
<BR><FONT SIZE=3D2><VGoparaju@tradepointsystems.com> =
wrote:</FONT>
</P>
<P><FONT SIZE=3D2>> You have to provide dictionary file/record name =
not</FONT>
<BR><FONT SIZE=3D2>> dictionary name.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> For example, you have a file/record called =
EMPLOYEE</FONT>
<BR><FONT SIZE=3D2>> in your dictionary.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> QSHOW</FONT>
<BR><FONT SIZE=3D2>> >SET LANG SQL</FONT>
<BR><FONT SIZE=3D2>> >GENE DATABASE EMPLOYEE</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Will create QSHOW.TXT file in your directory =
with</FONT>
<BR><FONT SIZE=3D2>> the following information:</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Create Schema Authorization EOD:EMPDAT.DAT =
--></FONT>
<BR><FONT SIZE=3D2>> something for RDB. Not valid</FONT>
<BR><FONT SIZE=3D2>> on Oracle Database.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Create Table EMPLOYEE</FONT>
<BR><FONT SIZE=3D2>> (</FONT>
<BR><FONT SIZE=3D2>> =
EMP_NO Decimal(10) Not Null,</FONT>
<BR><FONT SIZE=3D2>> =
EMP_NAME Char(30) Not Null,</FONT>
<BR><FONT SIZE=3D2>> =
MODIFIED_BY Char(12) Not Null,</FONT>
<BR><FONT SIZE=3D2>> =
DATE_UPDATED Decimal(8) Not Null,</FONT>
<BR><FONT SIZE=3D2>> =
TIME_UPDATED Decimal(4) Not Null,</FONT>
<BR><FONT SIZE=3D2>> =
FILLER Char(39) Not Null</FONT>
<BR><FONT SIZE=3D2>> )</FONT>
<BR><FONT SIZE=3D2>> Create Unique =
Asc Index EMP_NO_KEY</FONT>
<BR><FONT SIZE=3D2>> On =
EMPLOYEE</FONT>
<BR><FONT SIZE=3D2>> (</FONT>
<BR><FONT SIZE=3D2>> =
EMP_NO</FONT>
<BR><FONT SIZE=3D2>> )</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> Sagar</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>> From: Johnson, Harold A EDUC:EX</FONT>
<BR><FONT SIZE=3D2>> [<A =
HREF=3D"mailto:Harold.A.Johnson@gems1.gov.bc.ca">mailto:Harold.A.Johnson=
@gems1.gov.bc.ca</A>]</FONT>
<BR><FONT SIZE=3D2>> Sent: Thursday, February 03, 2005 1:10 =
PM</FONT>
<BR><FONT SIZE=3D2>> To: 'Goparaju, Vidyasagar'</FONT>
<BR><FONT SIZE=3D2>> Cc: PowerH List</FONT>
<BR><FONT SIZE=3D2>> Subject: RE: Dictionary to SQL</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> This isn't documented in QSHOW help - when I =
try to</FONT>
<BR><FONT SIZE=3D2>> run these commands,</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> $QSHOW</FONT>
<BR><FONT SIZE=3D2>> >set lang SQL</FONT>
<BR><FONT SIZE=3D2>> >gene database =
<dict> ? what exactly is =
this,</FONT>
<BR><FONT SIZE=3D2>> the short form of the</FONT>
<BR><FONT SIZE=3D2>> dictionary in OpenVMS? thnx</FONT>
<BR><FONT SIZE=3D2>> Default device is disc file QSHOGEN.SQL.</FONT>
<BR><FONT SIZE=3D2>> The file</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT =
SIZE=3D2>AVED$DISK5:[AVED.SFD.APPN.SFA.DEVE.SRC.SQL]QSHOGEN.SQL;</FONT>
<BR><FONT SIZE=3D2>> already</FONT>
<BR><FONT SIZE=3D2>> exists.</FONT>
<BR><FONT SIZE=3D2>> Create new version?y</FONT>
<BR><FONT SIZE=3D2>> *E* No valid files were specified in the =
GENERATE</FONT>
<BR><FONT SIZE=3D2>> statement.</FONT>
<BR><FONT SIZE=3D2>> > gene all</FONT>
<BR><FONT SIZE=3D2>> *W* GENERATE target is not a relational =
database.</FONT>
<BR><FONT SIZE=3D2>> ></FONT>
<BR><FONT SIZE=3D2>> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>> From: Goparaju, Vidyasagar</FONT>
<BR><FONT SIZE=3D2>> [<A =
HREF=3D"mailto:VGoparaju@tradepointsystems.com">mailto:VGoparaju@tradepo=
intsystems.com</A>]</FONT>
<BR><FONT SIZE=3D2>> Sent: 2005 February 3 10:44 AM</FONT>
<BR><FONT SIZE=3D2>> To: Johnson, Harold A EDUC:EX</FONT>
<BR><FONT SIZE=3D2>> Cc: PowerH List</FONT>
<BR><FONT SIZE=3D2>> Subject: RE: Dictionary to SQL</FONT>
<BR><FONT SIZE=3D2>> There is an option is QSHOW to create SQL =
script.</FONT>
<BR><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>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Sagar</FONT>
<BR><FONT SIZE=3D2>> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>> From: powerh-l-admin@lists.sowder.com [</FONT>
<BR><FONT SIZE=3D2>> <A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A></FONT>
<BR><FONT SIZE=3D2>> <<A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>> ]On Behalf</FONT>
<BR><FONT SIZE=3D2>> Of Johnson, Harold A</FONT>
<BR><FONT SIZE=3D2>> 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>
<BR><FONT SIZE=3D2>> Anyone know how to convert a PH Dictionary =
(OpenVMS)</FONT>
<BR><FONT SIZE=3D2>> to SQL? I think that</FONT>
<BR><FONT SIZE=3D2>> there are 3rd party utilities to do this, but =
we are</FONT>
<BR><FONT SIZE=3D2>> 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</FONT>
<BR><FONT SIZE=3D2>> data and extract it</FONT>
<BR><FONT SIZE=3D2>> directly? As a last resort, we will =
have to do the</FONT>
<BR><FONT SIZE=3D2>> conversion by hand.</FONT>
<BR><FONT SIZE=3D2>> cheers</FONT>
<BR><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</FONT>
<BR><FONT SIZE=3D2>> =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</FONT>
<BR><FONT SIZE=3D2>> powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>> Unsubscribe: "unsubscribe =
<password>" in message</FONT>
<BR><FONT SIZE=3D2>> body to</FONT>
<BR><FONT SIZE=3D2>> powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>> <A HREF=3D"http://lists.sowder.com/mailman/listi=
nfo/powerh-l" =
TARGET=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A><=
/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>&=
gt;</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> This list is closed, thus to post to the list =
you</FONT>
<BR><FONT SIZE=3D2>> must be a subscriber.</FONT>
<BR><FONT SIZE=3D2>></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_01C50AFD.9BF82D06--