I have a project requirement where I have to unload from a db2 table and load into a teradata table using Tpump.
The fields declared in db2 Table are as below.
(LINK_ITEM_NBR INTEGER NOT NULL
,ITEM_RELATIONSHIP_TYPE_CD CHARACTER(1) FOR SBCS DATA NOT NULL
,RELATIONSHIP_ITEM_NBR INTEGER NOT NULL
,REPLENISHMENT_RATE_PCT DECIMAL(3 , 2) WITH DEFAULT NULL
,LAST_UPDATE_USERID CHARACTER(10) FOR SBCS DATA WITH DEFAULT NULL
,LAST_UPDATE_PGM_ID CHARACTER(10) FOR SBCS DATA WITH DEFAULT NULL
,LAST_UPDATE_TS TIMESTAMP WITH DEFAULT NULL
And the Teradata Table Structure is as below
LINK_ITEM_NBR INTEGER NOT NULL,
ITEM_RELATIONSHIP_TYPE_CD CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
RELATIONSHIP_ITEM_NBR INTEGER COMPRESS ,
REPLENISHMENT_RATE_PCT DECIMAL(3,2) COMPRESS ,
LAST_UPDATE_USERID CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
LAST_UPDATE_PGM_ID CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
LAST_UPDATE_TS TIMESTAMP(6) WITH TIME ZONE NOT NULL)
While trying to insert using Tpump I am getting the below error
02:33:47 UTY8800 WARNING: Rate Monitoring turned off - no permission on
02:33:47 UTY6608 Import 1 begins.
02:33:47 UTY4204 Output overflow, output size = 61, maximum buffer size =
57,file 'INFILE', record number '1'.
02:33:47 UTY1808 Record 1 of Import 1 rejected due to preceding error.
Could anyone please suggest how can I overcome this error and insert succesfully.
Thanks a lot in Advance