Archives of the TeradataForum
Message Posted: Wed, 17 Aug 2005 @ 15:33:00 GMT
I'm using the fast load utility for loading into a table from flat file.But I'm having some problem
The fast load utility according to me actually sorts the records before inserting into the table, but this is not what i need
i want the first record to be taken in.
For eg : If I have table with columns say
Column1 numeric primary key, Column2 numeric , Column3 numeric
And the sample file i use for loading is :
10,30,50 10,40,20 10,20,60
And if I use the fast load utility then it inserts the row 10,20,60 to the database and rejects the other two records since its with the same primary key value 10.
Here if you see , though is the 3rd record it is the one which gets inserted instead of 10,30,50 which is the first record.
Is there any option to tell the fast load utility that insert the records in the order it comes ?
Because what i need is the records getting inserted in the order it comes in the file.
so if you have any records which have duplicate primary keys, i want the first record to be inserted and the others rejected.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|