Dictionary to SQL

[Robert Edis]

Cool.  Thanks.

Blue

--- "Goparaju, Vidyasagar"
<VGoparaju@tradepointsystems.com> wrote:

> 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.
>