Hi All, I am trying to export a BIGINT column which has signed value of -1 to a file. Then I am using this file to load the data back to a table say TABLE1. I noticed that the file doesn't contain the signed value neither the table1 contains -1. Instead it has 1. It is losing the sign. How can this be fixed. I have already tried to search this forum however, couldn't find anything that could help. Please advise.
Missing sign :-)
(BIGINT , FORMAT '-(15)9') (CHAR(16))
for up to 15 digits.
Btw, BIGINT stores up to 19 digits, the default format is '-(19)9'