Import ddl metadata definitions

devidotcom · Post by **devidotcom** » Mon Oct 22, 2007 1:02 am

Hi All,

I have a ddl file with the metadata of a table in the UNIX box.
Need to import this metadata to a sequential file as I only have the metadata but not the tables in the learning box.
How do I do that.

The file looks like
cat abc.ddl
TRANSIT SYSIBM DECIMAL 10 0 Yes
BRH SYSIBM DECIMAL 3 0 Yes
CLIENT SYSIBM DECIMAL 3 0 Yes
NUMBER SYSIBM DECIMAL 6 0 Yes

Could anyone help me out

ray.wurlod · Post by **ray.wurlod** » Mon Oct 22, 2007 1:30 am

For so few fields type it in manually. There is no metadata import tool geared to the format you have specified.

devidotcom · Post by **devidotcom** » Mon Oct 22, 2007 1:33 am

Hi Ray,

Thanks for the reply..

I have mentioned just a few columns I have all together around 30 columns that I would have to entry manually.

Is there any other way out... to get them imported...

ray.wurlod · Post by **ray.wurlod** » Mon Oct 22, 2007 1:41 am

If the described data object exists somewhere (database table, text file, etc.) then you could import it from there. Otherwise no.