# Copy Book to SQL

**URL:** <https://forum.cloverdx.com/t/copy-book-to-sql/1687>\
**Category:** CloverDX Platform\
**Created:** [October 27, 2015, 12:00am UTC](https://forum.cloverdx.com/t/copy-book-to-sql/1687 "2015-10-27T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![anil\_cloveretl](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@anil\_cloveretl](https://forum.cloverdx.com/u/anil_cloveretl)\
**Post date:** [October 27, 2015, 12:00am UTC](https://forum.cloverdx.com/t/copy-book-to-sql/1687/1 "2015-10-27T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [October 27, 2015, 3:13pm UTC](https://forum.cloverdx.com/t/copy-book-to-sql/1687/2 "2015-10-27T15:13:00Z")

</div>

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.