Extracting the DDL

cmcclellan

I have a very unique problem - I need to extract the DDL and save along with the data in the workflow.

Attached are 2 files, the CSV and the workflow to process it - basically to set the datatypes to the proper format.

But obviously saving as CSV means that you lose the datatypes that have been defined.

I understand that I really need to write to a database in order to get the proper DDL, but is there a way to get generic/ANSI SQL - something that might work as a CREATE TABLE in (almost) any RDBMS ?

MOCK_DATA.yxmd

MOCK_DATA.csv

danilang

Hi @cmcclellan

While there may be an automated way to do this type of thing that i'm not aware of, I've always built up the required SQL as a string.  I'd start with the Field Info tool to get the required metadata for the dataset and then add in the correct boiler plate for ANSI-SQL Create, Insert, Update etc.

Dan