How to use KgdCreateDdlMetadata

[kduke]

I received this email and thought others may benefit from my answer. This routine has been posted on this site, ADN and my tips page. If you cannot find it then I will post it again.

Gaurav

DsMetadataId is the ID of DS_METADATA. So you will need to import your table definitions. If you know how to SELECT this hash file then you might be able to create all of DDL in one job by looping through all the records in a folder in DS_METADATA. I usually call these jobs driver jobs. If you would like to do this and are unable to figure it out then ask again and I will post the code.

You could also automatically call a routine to run these scripts either with an ODBC call or sqlplus or whatever.

DSX is down right now but when it comes back up I would like to post your question and my answer so others can learn how to use this routine.

Thanks Kim.

>From: "Gaurav Bhatnagar"
>To: Kim_G_Duke
>Subject: Want some info regarding KgdCreateDdlMetadata DS routines.
>Date: Thu, 3 Mar 2005 19:00:18 +0530
>
>Hi Kim,
>i was blown away with this Datastage routine , KgdCreateDdlMetadata(DsMetadataId, OracleStyle)
>i am working to migrate a ton of data from legacy system to current one, Since i am already creating DDL for new system using Datastage tables definition , this will come as a boon.
>I wanted to ask one question though ,
>what is this "DsMetadataId" id , which it is using .
>
>i have tried to look into following hash file ( or Datastage repository looking for this id) , but could not understand that.
>
>DS_CONTAINERS
>DS_DATATYPES
>DS_JOBS
>DS_AUDIT
>DS_JOBOBJECTS
>DS_METADATA
>DS_ROUTINES
>DS_STAGETYPES
>DS_TRANSFORMS
>can you Please help me on this .
>
>
>Thanks and Regards,
>
>Gaurav Bhatnagar
>
>
>