DSXchange

Posted: **Wed Nov 11, 2009 4:57 am**

We have a teradata API stage inserting records in to it.

On any run, it insert only the last row! Below is the log output

APITarget: Number of rows received = 20, rejected = 0, inserted = 1, updated = 0, deleted = 0

Is there any know issues we have in Teradata API stage. Please help

Many Thanks
MSR

Posted: **Wed Nov 11, 2009 7:46 am**

Simply the table is set table , not multi set , so it can't contain duplicates , and the 20 rows received must be 1 row duplicated 20 times , check this and feed us back

M.Gendy

Posted: **Wed Nov 11, 2009 11:02 am**

mgendy wrote: 20 rows received must be 1 row duplicated 20 times
M.Gendy

No the rows are unique. The rows are not eliminated for that reason. My Non unique primary index(default as it is the first column) is employee_id and I have loaded 20 unique primary index records.

Please find the data snapshot below

100,Steven,King,SKING,515.123.4567,AD_PRES,24000,NULL,NULL,90
101,Neena,Kochhar,NKOCHAR,515.123.4568,AS_VP,17000,NULL,100,90
102,Lex,De Hann,LDEHAAN,515.123.4569,AD_VP,17000,NULL,100,90
103,Alexandar,Hunold,AHUNOLD,590.423.4567,IT_PROG,9000,102,60
104,Bruce,Ernst,BERNST,590.423.4568,IT_PROG,6000,NULL,103,60
107,Diana,Lorentz,DLORENTZ,590.423.5567,IT_PROG,4200,NULL,103,60
124,Kevin,Mourgos,KMURURGOS,650.123.5234,ST_MAN,5800,NULL,100,50
141,Trenna,Rajs,TRAJS,650.121.8009,ST_CLERK,3500,NULL,124,50
142,Curtis,Davies,CDAVIES,650.121.2994,ST_CLERK,3100,NULL,124,50
143,Randall,Matos,RMATOS,650.121.2874,ST_CLREK,2600,NULL,124,50
144,Peter,Vargas,PVARGAS,650.121.2004,ST_CLERK,2500,NULL,124,50
149,Eleni,Zlotkey,EZLOTKEY,011.44.1344.429018,SA_MAN,10500,0.2,100,80
174,Ellen,Abel,EABLE,011.44.1644.429267,SA_REP,11000,0.3,149,149,80
176,Jonathon,Taylor,JTAYLOR,011.44.1644.429265,SA_REP,8600,0.2,149,80
178,Kimberely,Grant,KGRANT,011.44.1644,SA_REP,7000,0.15,149,NULL
200,Jennifer,Whalen,JWHALEN,515.123.4444,AD_ASST,4400,NULL,101,10
201,Michael,Hartstein,MHARTSTE,515.123.5555,MK_MAN,13000,NULL,100,20
202,Pat,Fay,PFAY,603.123.6666,MK_REP,6000,NULL,201,20
205,Shelly,Higgins,SHIGGINS,515.123.8080,AC_MGR,12000,NULL,101,110
206,William,Gietz,WGIETZ,515.123.8181,AC_ACCOUNT,8300,NULL,205,110

Posted: **Wed Nov 11, 2009 12:04 pm**

What column is the primary key defined as in Teradata?

Posted: **Thu Nov 12, 2009 1:44 am**

The syntax from SHOW Table is below

ArndW wrote:What column is the primary key defined as in Teradata
SHOW TABLE emps; wrote: CREATE SET TABLE DEV01VHA.emps ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
employee_id INTEGER NOT NULL,
first_name VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
last_name VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

email VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
phone_number VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
job_id VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
salary DECIMAL(8,2),
commission DECIMAL(2,2),
manager_id INTEGER,
department_id INTEGER)
PRIMARY INDEX ( employee_id );

Posted: **Thu Nov 12, 2009 1:46 am**

Does the table contains any previous data ? or it is empty ?

Posted: **Thu Nov 12, 2009 2:02 am**

mgendy wrote:Does the table contains any previous data ? or it is empty ?

It is a empty table

Posted: **Thu Nov 12, 2009 2:04 am**

mgendy wrote:Does the table contains any previous data ? or it is empty ?

It is a empty table

Posted: **Thu Jan 07, 2010 8:09 pm**

IBM has agreed this as a know bug and they are going to provide a patch for this issue.

Posted: **Sun Jan 10, 2010 2:22 am**

anandsiva wrote:IBM has agreed this as a know bug and they are going to provide a patch for this issue.

could you please clarify where exactly is the bug ?

Regards

DSXchange

Teradata API Stage

Teradata API Stage