Archives of the TeradataForum
Message Posted: Fri, 07 Dec 2007 @ 17:08:55 GMT
<-- Anonymously Posted: Fri, 7 Dec 2007 11:54 -->
I want to load data from a file to an empty table.
The data has certain fields of format: PIC S9(9)V9(2). I know it means DECIMAL(11,2) in Teradata.
But I think some conversion needs to be done before loading, because its giving me error while loading.
Also when I export from a table having some fields format as DECIMAL(11,2) how exactly the data should appear in the file.
Can someone provide me some inputs in this regard. Thank you.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|