I am trying to write a simple script to report tables which have not been used since last 90 days. i am using below code to get the values (some specific tables have been renamed)
but when report is generated i am getting it is generating something like below, where i am getting all as expected, only the sapce_IN_GB (space occupied by table) showing some unusual value. i am not able to find if it is BTEQ issue or i hvae to use some function to get correct value.
please see SPACE_IN_GB, the first value is actually 273 GB,is there something missed?
Well, CurrentPerm is a FLOAT column and you get FLOAT as result.
The default format for FLOAT is a scientific notation with exponent and mantissa, so 2.72951547622681E 002 equals 2.72951547622681 * 100 which is 272.9515.
You might simply CAST(SPACE_IN_GB AS DEC(8,2)).