show in xml table x

Database
Fan

show in xml table x

Hi - I'm using 

show in xml table 

to faciliate a system integration. 

 

Is there anyway to do the reverse - i.e. to turn xml into a create table statement?

3 REPLIES
Apprentice

Re: show in xml table x

Hi Jaime,

 

I don't believe there is. Teradata basically requires an SQL statement (i.e. plain text) in order to create a table.

 

You could probably load an XML document into a table, shred it to extract the parts, building the components of a 'create table' statement and then execute that. After the load i think this could be done using a stored procedure.

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Fan

Re: show in xml table x

Makes sense.  If anyone has developed such a stored procedure, and wishes to share it, I'd be interested.

Enthusiast

Re: show in xml table x

There is some good information that you can find from the below URL

 

https://downloads.teradata.com/extensibility/articles/a-quick-tour-of-the-xml-type