I am trying to export data from a table in which one column has a data type of Decimal(38,0).
Query: select sa from aa;
When I run the select statement in SQL assistant....the output is fine....like below
When the same query is run through BTEQ there is a decimal point coming at the end of the value..like below:
I have created a table like create table a(col1 decimal(38,0),b integer)
i want to keep my col1 as identity. But when i look at the table in bteq it shows a dot after the value.
Why does this dot appear. is there any setting required???
Can i create this col1 as identity or i should use BIGINT. Which is preferable.
You can use any DEC(x,0) as identity, but the range of a BIGINT is probably enough and it's only 8 bytes instead of 16 bytes for storage.
And the setting to remove the dot is an appropriate format.