Dictionary to SQL
Goparaju, Vidyasagar
VGoparaju@tradepointsystems.com
Thu, 3 Feb 2005 14:22:49 -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_01C50A25.BEAD5368
Content-Type: text/plain;
charset="iso-8859-1"
Output goes into QSHOSQL.TXT.
Sagar
-----Original Message-----
From: Goparaju, Vidyasagar
Sent: Thursday, February 03, 2005 1:21 PM
To: 'Johnson, Harold A EDUC:EX'
Cc: PowerH List
Subject: RE: Dictionary to SQL
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.
------_=_NextPart_001_01C50A25.BEAD5368
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C509F3.73A12250">
<title>RE: Dictionary to SQL</title>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:553679495 -2147483648 8 0 66047 0;}
@font-face
{font-family:r_ansi;
panose-1:0 0 0 0 0 0 0 0 0 0;
mso-font-alt:"Times New Roman";
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-format:other;
mso-font-pitch:auto;
mso-font-signature:0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;
text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p
{margin-right:0in;
mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:#993366;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dblue =
style=3D'tab-interval:.5in'>
<div class=3DSection1>
<p class=3DMsoNormal><span class=3DEmailStyle20><font size=3D2 =
color=3D"#993366"
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Output goes into =
QSHOSQL.TXT.<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle20><font size=3D2 =
color=3D"#993366"
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><br>
Sagar<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle20><font size=3D2 =
color=3D"#993366"
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblack
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Goparaju, =
Vidyasagar <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, February =
03, 2005
1:21 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Johnson, Harold A =
EDUC:EX'<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> PowerH List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Dictionary =
to SQL</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>You have to provide dictionary file/record =
name not
dictionary name.<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>For example, you have a file/record called =
EMPLOYEE
in your dictionary.<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>QSHOW<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>>SET LANG =
SQL<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>>GENE DATABASE =
EMPLOYEE<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Will create QSHOW.TXT file in your directory =
with the
following information:<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Create Schema Authorization EOD:EMPDAT.DAT =
</span></font></span><span
class=3DEmailStyle19><font size=3D2 color=3Dnavy face=3DWingdings><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Wingding=
s;
mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-char-type:sy=
mbol;
mso-symbol-font-family:Wingdings'><span =
style=3D'mso-char-type:symbol;mso-symbol-font-family:
Wingdings'>=E0</span></span></font></span><span =
class=3DEmailStyle19><font size=3D2
color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'> something for RDB. Not valid on Oracle =
Database.<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Create Table =
EMPLOYEE<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun: =
yes"> </span>(<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>EMP_NO Decimal(10) Not =
Null,<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>EMP_NAME Char(30) Not =
Null,<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>MODIFIED_BY Char(12) =
Not Null,<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>DATE_UPDATED =
Decimal(8) Not
Null,<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>TIME_UPDATED =
Decimal(4) Not
Null,<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>FILLER Char(39) Not =
Null<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun: =
yes"> </span>)<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Create Unique Asc<span style=3D"mso-spacerun:
yes"> </span>Index =
EMP_NO_KEY<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>On =
EMPLOYEE<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun: yes"> =
</span>(<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun:
yes"> </span>EMP_NO =
<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style=3D"mso-spacerun: =
yes"> </span>)<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;co=
lor:navy'><br>
<span class=3DEmailStyle19><font =
color=3Dnavy>Sagar<o:p></o:p></font></span></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:.5in'><span =
class=3DEmailStyle19><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblack
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Johnson, Harold A =
EDUC:EX
[mailto:Harold.A.Johnson@gems1.gov.bc.ca]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, February =
03, 2005
1:10 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Goparaju, =
Vidyasagar'<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> PowerH List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Dictionary =
to SQL</span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]> <![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>This
isn't documented in QSHOW help - when I try to run these =
commands,</span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>$QSHOW</span></f=
ont><font
color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o:p>=
</o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>>set
lang SQL</span></font><font color=3Dblack><span =
style=3D'color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>>gene
database <dict> ? what exactly is =
this, the
short form of the dictionary in OpenVMS? =
thnx</span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:1.0in'><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black'>Default =
device is disc
file QSHOGEN.SQL.</span></font><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black;mso-color-alt:w=
indowtext'><o:p></o:p></span></font></p>
<p style=3D'margin-left:1.0in'><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black'>The file
AVED$DISK5:[AVED.SFD.APPN.SFA.DEVE.SRC.SQL]QSHOGEN.SQL; already =
exists.</span></font><font
size=3D2 color=3Dblack face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:
r_ansi;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></=
p>
<p style=3D'margin-left:1.0in'><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black'>Create new =
version?y</span></font><font
size=3D2 color=3Dblack face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:
r_ansi;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></=
p>
<p style=3D'margin-left:1.0in'><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black'>*E* No valid =
files were
specified in the GENERATE statement.</span></font><font size=3D2 =
color=3Dblack
face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:r_ansi;color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style=3D'margin-left:1.0in'><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black'>> gene =
all</span></font><font
size=3D2 color=3Dblack face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:
r_ansi;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></=
p>
<p style=3D'margin-left:1.0in'><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black'>*W* GENERATE =
target is
not a relational database.</span></font><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black;mso-color-alt:w=
indowtext'><o:p></o:p></span></font></p>
<p style=3D'margin-left:1.0in'><font size=3D2 color=3Dblack =
face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:black'>> =
</span></font><font
size=3D2 color=3Dblack face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:
r_ansi;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></=
p>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:1.5in'><font size=3D2 color=3Dblack face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:black'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Goparaju, =
Vidyasagar
[mailto:VGoparaju@tradepointsystems.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 2005 February 3 =
10:44 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Johnson, Harold A =
EDUC:EX<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> PowerH List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Dictionary =
to SQL</span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:1.5in'><font size=3D2 color=3Dblack =
face=3D"Times New Roman"><span
style=3D'font-size:10.0pt;color:black'>There is an option is QSHOW to =
create SQL
script.</span></font><font color=3Dblack><span style=3D'color:black'> =
</span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:1.5in'><font size=3D2 color=3Dblack =
face=3D"Times New Roman"><span
style=3D'font-size:10.0pt;color:black'>$QSHOW</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'> >SET LANG =
SQL</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>* GENE DATABASE <Dictionary file =
name></span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>* </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:1.5in'><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]> <![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:1.5in'><font size=3D2 color=3Dblack =
face=3D"Times New Roman"><span
style=3D'font-size:10.0pt;color:black'>Sagar</span></font><font =
color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style=3D'margin-left:1.5in'><font size=3D2 color=3Dblack =
face=3D"Times New Roman"><span
style=3D'font-size:10.0pt;color:black'>-----Original =
Message-----</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>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 Johnson, Harold A EDUC:EX</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Sent: Thursday, February 03, 2005 12:33 =
PM</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>To: PowerH List</span></font><font color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Subject: Dictionary to SQL</span></font><font =
color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style=3D'margin-left:1.5in'><font size=3D2 color=3Dblack =
face=3D"Times New Roman"><span
style=3D'font-size:10.0pt;color:black'>Anyone know how to convert a PH =
Dictionary
(OpenVMS) to SQL? I think that</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>there are 3rd party utilities to do this, but we are only =
doing it
once and</span></font><font color=3Dblack><span style=3D'color:black'> =
<br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>don't want buy anything.</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>OR, is there some way to access the dictionary meta data =
and
extract it</span></font><font color=3Dblack><span =
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>directly? As a last resort, we will have to do =
the
conversion by hand.</span></font><font color=3Dblack><span =
style=3D'color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:1.5in'><font size=3D2 color=3Dblack =
face=3D"Times New Roman"><span
style=3D'font-size:10.0pt;color:black'>cheers</span></font><font =
color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style=3D'margin-left:1.5in'><font size=3D2 color=3Dblack =
face=3D"Times New Roman"><span
style=3D'font-size:10.0pt;color:black'>=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</span></font><font color=3Dblack><span =
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Mailing list: powerh-l@lists.sowder.com</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Unsubscribe: "unsubscribe <password>" in =
message
body to powerh-l-request@lists.sowder.com</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'><a =
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><=
/span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>This list is closed, thus to post to the list you must be =
a
subscriber.</span></font><font color=3Dblack><span =
style=3D'color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
</div>
</body>
</html>
------_=_NextPart_001_01C50A25.BEAD5368--