Dictionary to SQL

[Valentin Likoum]

On 03.02.2005 Johnson, Harold A EDUC:EX <Harold.A.Johnson@gems1.gov.bc.ca> wrote:

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

  Some years ago we migrated from RMS files to RDB database and I
wrote some small C programm which converts DDL definitions to SQL.
So path was:
$ QSHOW
set lang cdd
gene all
^Z
$! qshogen.ddl is in the current directory
$ mc []ddltosql
$! create_db.sql is in the current directory

  Drop me a line if you need this programm.


-- 
  Valentin Likoum
  valentin.likoum at ncc dot volga dot ru