Unable to update a row that contains a blank/null value in an indexed column.

Tools & Utilities

Unable to update a row that contains a blank/null value in an indexed column.

Hello,

I have a table with a primary index made up of two columns, let's say colA and colB.  It is possible for colA to have blank/null values, colB is always populated.  Using mload, when I execute the upsert step of the tpt script, the records with a non-blank value in both colA and colB are updated successfully.  The records with a blank in colA are treated as an insert and are duplicated on my table.  In this case, the records already exist in the table and I am trying to apply updates.

I defined the table as SET since it is not supposed to allow duplicates.  The source is a staging table which I first populate from a flat file.  I am new to Teradata so it is possible I don't have this set up correctly, but I have run out of ideas.  Has anyone encountered this problem also?  If I have not provided enough information, please let me know.

Thank you,

Jim

Tags (4)