Copy Book to SQL

anil_cloveretl

• October 27, 2015 00:00

• Answered

Follow

Hi all,
I got a requirement to create SQl table defination based on Metadata in Copy book (EBCIDIC structure).

Is there any way CloverETL this can be achived.

Appreciate your help here.

Regards,
Anil Gopaluni

• 

  dpavlis

  • October 27, 2015 15:13

  0

  Comment actions Permalink

  Hi Anil,
  
  This is difficult to automate. What you could do is to use Cobol CopyBook metadata extract wizard to convert your CopyBook definitions into CloverETL metadata. Then you can use Clover's feature which allows to take existing metadata definition and create DB's DDL statement, which can be run against any relational database.
  Check the CloverETL documentation which explains how to achieve this.
  
  David.

Please sign in to leave a comment.