Dictionary to SQL

[Ken Langendock]

Harold, the only way I know how to do this is to go
into qshow and export all the file contents into a
text file.

qshow
set lang pdl
gen all
exit

Once you have the flat file...it is a lot of search
and replaced to get the sql source correct.

Have fun
Ken

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