I am building a new table and my understanding is, since Terdata stores DATE datatype as integer, I need to specify a respective integer value in COMPRESS clause, i.e. to store compressed value of '2099-01-01', I would need to have COMPRESS 1990101 when defining column. Please let me know if this is correct.
This will work, but the table DDL will show the integer as a date value.
Easier to use : COMPRESS (DATE '2099-01-01', DATE '1900-01-01')
I think this may require the default date format on the system to be YYYY-MM-DD