In 8207, I just tried refreshing some synonyms to pull in a ...

[Jess Hines]

In 8207, I just tried refreshing some synonyms to pull in a new database field, and found that in addition to that, its automatically creating a bunch of DEFINE fields for any dates.

For example, if I have a VAL_DATE field like so:

FIELDNAME=VAL_DATE, ALIAS=VAL_DATE, USAGE=MDYY, ACTUAL=DATE,

 

Then after refresh, I get all these as well, and have to go in and delete them to keep my master file clean:

DEFINE VAL_DATE_YEAR/I4 MISSING ON ALL=DTPART(VAL_DATE, YEAR);

TITLE='Val Date,Year', $

DEFINE VAL_DATE_QUARTER/I1 MISSING ON ALL=DTPART(VAL_DATE, QUARTER);

TITLE='Val Date,Quarter', $

DEFINE VAL_DATE_MONTH/I2 MISSING ON ALL=DTPART(VAL_DATE, MONTH);

TITLE='Val Date,Month', $

DEFINE VAL_DATE_DAY/I2 MISSING ON ALL=DTPART(VAL_DATE, DAY);

TITLE='Val Date,Day', $

DEFINE VAL_DATE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(VAL_DATE, YEAR);

TITLE='Val Date,Y', $

DEFINE VAL_DATE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(VAL_DATE, QUARTER);

TITLE='Val Date,Y-Q', $

DEFINE VAL_DATE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(VAL_DATE, MONTH);

TITLE='Val Date,Y-M', $

DEFINE VAL_DATE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(VAL_DATE, DAY);

TITLE='Val Date,M-D-Y', $

 

Is this some configuration setting, or do I just have to live with this unwanted behavior from now on

[Charles Morris 2]

yes there is a config setting to turn off the Deconstruct Dates. Cant recall where it is but it may be associated with the adapter, same place you set things like how many default decimal places for numerics

[Charles Morris 2]

Its under Adapters, Change Settings for Common Adapters button

 

image.png1334433 88.8 KB

[Toby Mills]

Thats kind of cool guys.

Thanks!

Toby

[VisuaLizeFOCUS .]

In 8207 while creating a synonym you have the option to turn it off.