Jump to content

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


Jess Hines

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...