Dictionary to SQL

Fri, 4 Feb 2005 14:15:18 -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_01C50B06.8044AC81
Content-Type: text/plain;
	charset="iso-8859-1"

Sorry, but these commands don't react the way that you are describing.  I'm
on OpenVMS 7.3 using an "Oracle" (yes, I was aware of that) RDB database, PH
v710g1.

This is what happens:

$QSHOW
>set lang sql   (ok)
>gene database access_error_file   (which is an RMS file defined in the
dictionary)
Default device is disc file QSHOGEN.SQL
>exit

The resulting QSHOGEN.SQL file is empty.

?

thnx

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Goparaju, Vidyasagar
Sent: 2005 February 4 1:08 PM
To: 'Robert Edis'; PowerHouse List
Subject: RE: Dictionary to SQL

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
<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
<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
<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>  
> < 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>  
> < 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
<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_01C50B06.8044AC81
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>Sorry, 
but these commands don't react the way that you are describing.&nbsp; I'm 
on&nbsp;OpenVMS 7.3 using an "Oracle" (yes, I was aware of that) RDB database, 
PH v710g1.</DIV>
<DIV>&nbsp;</DIV>
<DIV>This 
is what happens:</DIV>
<DIV>&nbsp;</DIV>
<DIV>$QSHOW</DIV>
<DIV>&gt;set lang sql&nbsp;&nbsp; (ok)</DIV>
<DIV>&gt;gene database access_error_file&nbsp;&nbsp; (which is an RMS file 
defined in the dictionary) Default device is disc file QSHOGEN.SQL</DIV>
<DIV>&gt;exit</DIV>
<DIV>&nbsp;</DIV>
<DIV>The resulting 
QSHOGEN.SQL file is empty.</DIV>
<DIV>&nbsp;</DIV>
<DIV>?</DIV>
<DIV>&nbsp;</DIV>
<DIV>thnx</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: 
 powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com]On 
 Behalf Of Goparaju, Vidyasagar Sent: 2005 February 4 1:08 
 PM To: 'Robert Edis'; PowerHouse List Subject: RE: 
 Dictionary to SQL </DIV>
 It is generated based on Record definition of an RMS 
 file. 
 Sagar 
 -----Original Message----- 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 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" &lt;VGoparaju@tradepointsystems.com&gt; wrote: 
 &gt; You have to provide dictionary file/record name 
 not &gt; dictionary name. &gt; 
 &gt; For example, you have a file/record called 
 EMPLOYEE &gt; in your dictionary. &gt; &gt; QSHOW &gt; 
 &gt;SET LANG SQL &gt; &gt;GENE DATABASE 
 EMPLOYEE &gt; &gt; Will create 
 QSHOW.TXT file in your directory with &gt; the 
 following information: &gt; &gt; Create Schema Authorization EOD:EMPDAT.DAT --&gt; &gt; something for RDB. Not valid &gt; on 
 Oracle Database. &gt; &gt; 
 Create Table EMPLOYEE &gt;&nbsp;&nbsp;&nbsp; ( 
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EMP_NO 
 Decimal(10) Not Null, &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EMP_NAME Char(30) Not 
 Null, &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 MODIFIED_BY Char(12) Not Null, &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATE_UPDATED Decimal(8) 
 Not Null, &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TIME_UPDATED Decimal(4) 
 Not Null, &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILLER Char(39) Not 
 Null &gt;&nbsp;&nbsp;&nbsp; ) &gt; Create Unique Asc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Index 
 EMP_NO_KEY &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On EMPLOYEE 
 &gt;&nbsp;&nbsp;&nbsp; ( &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EMP_NO &gt;&nbsp;&nbsp;&nbsp; ) &gt; &gt; &gt; Sagar &gt; 
 &gt; &gt; &gt; &gt; -----Original Message----- 
 &gt; From: Johnson, Harold A EDUC:EX &gt; [<A 
 href="mailto:Harold.A.Johnson@gems1.gov.bc.ca">mailto:Harold.A.Johnson@gems1.gov.bc.ca</A>] 
 &gt; Sent: Thursday, February 03, 2005 1:10 PM 
 &gt; To: 'Goparaju, Vidyasagar' &gt; 
 Cc: PowerH List &gt; Subject: RE: Dictionary to 
 SQL &gt; &gt; This isn't 
 documented in QSHOW help - when I try to &gt; run 
 these commands, &gt; &gt; 
 $QSHOW &gt; &gt;set lang SQL &gt; &gt;gene database &lt;dict&gt;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp; 
 what exactly is this, &gt; the short form of 
 the &gt; dictionary in OpenVMS?&nbsp;&nbsp; 
 thnx &gt; Default device is disc file 
 QSHOGEN.SQL. &gt; The file &gt; AVED$DISK5:[AVED.SFD.APPN.SFA.DEVE.SRC.SQL]QSHOGEN.SQL; 
 &gt; already &gt; exists. 
 &gt; Create new version?y &gt; *E* No 
 valid files were specified in the GENERATE &gt; 
 statement. &gt; &gt; gene all &gt; *W* GENERATE target is not a relational database. &gt; &gt; &gt; -----Original 
 Message----- &gt; From: Goparaju, Vidyasagar 
 &gt; [<A 
 href="mailto:VGoparaju@tradepointsystems.com">mailto:VGoparaju@tradepointsystems.com</A>] 
 &gt; Sent: 2005 February 3 10:44 AM &gt; To: Johnson, Harold A EDUC:EX &gt; Cc: 
 PowerH List &gt; Subject: RE: Dictionary to SQL 
 &gt; There is an option is QSHOW to create SQL script. 
 &gt; $QSHOW &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;SET LANG SQL 
 &gt; * GENE DATABASE &lt;Dictionary file name&gt; 
 &gt; * &gt; &gt; Sagar &gt; -----Original 
 Message----- &gt; From: 
 powerh-l-admin@lists.sowder.com [ &gt; <A 
 href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A> 
 &gt; &lt;<A 
 href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>&gt; 
 ]On Behalf &gt; Of Johnson, Harold A &gt; EDUC:EX &gt; Sent: Thursday, February 03, 
 2005 12:33 PM &gt; To: PowerH List &gt; Subject: Dictionary to SQL &gt; Anyone 
 know how to convert a PH Dictionary (OpenVMS) &gt; to 
 SQL?&nbsp;&nbsp; I think that &gt; there are 3rd party 
 utilities to do this, but we are &gt; only doing it 
 once and &gt; don't want buy anything. 
 &gt; OR, is there some way to access the dictionary 
 meta &gt; data and extract it &gt; directly?&nbsp;&nbsp; As a last resort, we will have to do 
 the &gt; conversion by hand. &gt; cheers &gt; = = = = = = = = = = = = = = = 
 = = = = = = = = = = = &gt; = = &gt; Mailing list: powerh-l@lists.sowder.com &gt; Subscribe: "subscribe" in message body to &gt; powerh-l-request@lists.sowder.com &gt; 
 Unsubscribe: "unsubscribe &lt;password&gt;" in message &gt; body to &gt; 
 powerh-l-request@lists.sowder.com &gt; <A 
 href="http://lists.sowder.com/mailman/listinfo/powerh-l" 
 target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A> 
 &gt; &lt;<A 
 href="http://lists.sowder.com/mailman/listinfo/powerh-l" 
 target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A>&gt; 
 &gt; &gt; This list is closed, thus 
 to post to the list you &gt; must be a 
 subscriber. &gt; 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Mailing list: powerh-l@lists.sowder.com Subscribe: "subscribe" in message body to 
 powerh-l-request@lists.sowder.com Unsubscribe: 
 "unsubscribe &lt;password&gt;" in message body to 
 powerh-l-request@lists.sowder.com <A 
 href="http://lists.sowder.com/mailman/listinfo/powerh-l" 
 target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A> 
 This list is closed, thus to post to the list you must be a 
 subscriber. </BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C50B06.8044AC81--