November 5, 2008 at 8:04 pm
hi ,
i'm getting this error when i try to insert to an as400 linked server
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]Data truncated.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
this is my insert statement
insert into [dbo].vw_ICMSOpenSO_Destination_DSL (CONNME, CBGNAM, CBGADD, CBGOTP, CBGONO, CBGPR#, CBGOM#, CBPCBL, CBSCBL, CBGRTP, CPCON#, CMODEM, CCREAL, CSPLIT, CRSO, CDATE, CINSTL, CREMRK, CREXCH) values ('EPINS CONTRACTOR', 'MERLINA AGONIAS ENCARNACION', '006-BL-018 APITONG ST, BGY 19, AWHAG VILLAGE PHASE 1, DAVAO', 'MK', '04524114', '0', '184262201', 'DVO01-NKAG01-COT/378', 'DVO-T0056/184', 'C4', '9177193444', 'HA88', 's080535002967', '280836254', '', '10/31/2008', 'ep0014', 'tok merlina', 'DVO')
this is the view where i insert the data
SELECT CONNME, CBGNAM, CBGADD, CBGOTP, CBGONO, CBGOM#, CBPCBL, CBSCBL, CBGRTP, CPCON#, CPCLAM, CSPANS, CITYMN, CTYCLM, COKNUM,
CRSO, CRTDID, CDATE, CINSTL, CEXTEN, CITYEX, CTYCLE, CREMRK, CREXCH
FROM ICMS2CPMSAS400.RDBGW.ICMSMISC.CBGCS3W0
the insert command was working properly until the change in field length of CINSTL the original length was A(6) then increased to A(10)
thank you
November 18, 2014 at 5:20 pm
Hi -
were you able to solve this problem? were you able to perform a successful inserT? I have an unrelated issue and was wondering if you could help me with that,.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply