VMS to WINDOWS approach ( set lang SQL - gen database...) ?

[Lorry Litman]

This is a multi-part message in MIME format.

--=_Part_d7e14140$4cc7$4784$b9af$66a858131608
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

the gen database syntax requires you enter something. I tried gen databas=
e
ALL, but it still gave me a qshogen.sql file with only the information fr=
om
the database file in the dictionary, no RMS info.
Lorry

-----Original Message-----

This e-mail and/or any documents in this transmission is intended for the=
 address(s) only and may contain legally privileged or confidential infor=
mation. Any unauthorized use, disclosure, distribution, copying or dissem=
ination is strictly prohibited. If you receive this transmission in error=
, please notify the sender immediately and return the original.
--=_Part_d7e14140$4cc7$4784$b9af$66a858131608
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit

From: Joe Boyle [mailto:atla38@dsl.pipex.com]
Sent: Monday, March 14, 2005 8:50 AM
To: 'Lorry Litman'; 'brian_matthewsbrian matthews'
Cc: powerh-l@lists.sowder.com
Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?
MIME-Version: 1.0


I'm pretty sure that the command to get 'RMS tables' was 'gen database'
only, i.e. no database name or RMS file names referenced - presumably you
then pick the 'RMS tables' out of the full SQL generated for the whole
dictionary.

Regards, Joe.


-----Original Message-----

--=_Part_d7e14140$4cc7$4784$b9af$66a858131608
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit

From: powerh-l-admin@lists.sowder.com
[mailto: powerh-l-admin@lists.sowder.com] On Behalf Of Lorry Litman
Sent: 14 March 2005 14:21
To: 'brian_matthewsbrian matthews'
Cc: powerh-l@lists.sowder.com
Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?
MIME-Version: 1.0

we're on PH710.G1 & VMS7.3-1, with the database referenced in the
dictionary, gen database <dbname> does generate a qshogen.sql file with
table definitions (careful, views are treated as tables), however, the same
does not work for gen database <rms filename>. It creates an empty
qshogen.sql. My understanding is that this does work for VMS in PH8 version.

Lorry 

-----Original Message-----

This e-mail and/or any documents in this transmission is intended for the
address(s) only and may contain legally privileged or confidential
information. Any unauthorized use, disclosure, distribution, copying or
dissemination is strictly prohibited. If you receive this transmission in
error, please notify the sender immediately and return the original.
--=_Part_d7e14140$4cc7$4784$b9af$66a858131608--