Jess Hines Posted April 28, 2021 Share Posted April 28, 2021 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 More sharing options...
Charles Morris 2 Posted April 29, 2021 Share Posted April 29, 2021 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 Link to comment Share on other sites More sharing options...
Charles Morris 2 Posted April 29, 2021 Share Posted April 29, 2021 Its under Adapters, Change Settings for Common Adapters button image.png1334433 88.8 KB Link to comment Share on other sites More sharing options...
Toby Mills Posted April 29, 2021 Share Posted April 29, 2021 Thats kind of cool guys. Thanks! Toby Link to comment Share on other sites More sharing options...
VisuaLizeFOCUS . Posted April 30, 2021 Share Posted April 30, 2021 In 8207 while creating a synonym you have the option to turn it off. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now