Dictionary to SQL

[Robert Edis]

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