INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...It is good to know that there are groups such as this willing to share knowledge in this money driven economy..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > NCR: Teradata Forum

import (mload/bteq) with duplicate keys)

Read More Threads Like This One

lexa001 (Programmer)

26 Oct 06 8:24

Hello,

Is it possible to import records if they have duplicate keys ?
For example a file with 100 000 records in which one record exists in the table ; the result of the bteq or mload is "no record imported because of duplicate unique key" and I would like to import the 99999 records without modifying the file.

I thank you for your help on this.

B. regards

Xavier

rrrkrishnan (Programmer)

27 Oct 06 18:50

You would be able to load this data if you define the target table with a non unique primary index.

al1024 (MIS)

29 Dec 06 11:25

Test the integrity of your data before inserting :

INSERT INTO doubles (id, columns, batch_no)
SELECT  id, columns, $BATCHNO
FROM    source
    INNER JOIN
        target
        ON  target.id = source.id
;
INSERT INTO target (id, columns)
SELECT id, columns
FROM source
WHERE NOT EXISTS (  SELECT 1 FROM doubles
                    WHERE   doubles.id = source.id
                        AND doubles.batch_no = $BATCHNO
            )
;

You can then use doubles table to update target table or whatever you want.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To NCR: Teradata