Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 26 Sep 2012 @ 18:52:52 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: How to write ERWin macro to support compress?
From:   Barner, Eric

I don't remember if Version 4.x has the capability to store compression list values as a propertly of the column. That version is way back.

However, using the Macro language in ERWIN, I don't believe there is macro or function which can access that metadata for an attribute in the current releases, and I am on Erwin Version 8.

In more modern releases of Erwin( 7.x & 8.x) you can store the compress value list for an column as a property. You will need to use Forward Engineer to generate the DDL correctly, with the compress values list. Works pretty cleanly.

If you are stuck with Version 4 (and you can't store the compress list in the column properties) there may be a way to use the UDPs for a column and store the compress values list there.

Some complicated Macro scripting would be necessary to evaluate in the %ForEachColumn() macro if there was a UDP with the %ColProp() macro (legacy version) or the %ColumnProp() macro in more current versions or ERWIN to extract and generate the Compress list stored in the UDP.

I would not recommend this as it Is very painful to maintain, and hard to code, but it may be your only option if you want to do this purely from ERWIN.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023