Use variable in DDL file name creation

[Former Member]

Hello there,

I was wondering, if it is possible to adjust the file name for DDL scripts according to the object type.

E.g. I have a table "Product" and I would like to have the script name to be "Product.table_create.sql

If I have a view "Product" I would like to have the script name to be "Product.view_create.sql"

We're using the Teradata V14 DBMS Resource File.

I wish I could just adjust the constant ScriptExt within the Teradata DBMS Resource File (Script -> Sql -> File) to something like "%OBJECTTYPE%_create.sql" But unfortunately that does not work.

Am I simply using the wrong variable? Or does it not work that way at all? Does anybody have a suggestion?

Thanks in advance!

Best Regards

Dortje

[GeorgeMcGeachie · Accepted solution]

Hello Dortje

I can't see any way of doing this - perhaps someone who knows the internal workings of DB generation may have an answer.

Raise this on SCN as an enhancement request.

George

[marc_ledier · Accepted solution]

Hi,

Unfortunately, you cannot control the name of the files that standard generation produce.

In an other hand, you can create your own generation that can do it.

You may refer to chapter "Customize Generation with GTL" in documentation.

It may help.

Marc

[Former Member]

Thanks for your answers. I was actually looking for something to avoid writing new Resource DBMS Files. But I already guessed that it might not be possible.