Page 1 of 1
Parameter marker text size exceeds allocated space
Posted: Thu Jul 22, 2004 2:06 pm
by poorna_76
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=IM974, DBMS.CODE=0
[DataStage][SQL Client]Parameter marker text size exceeds allocated space
Can you any one tell what this error is?
Thanks in Advance
Posted: Thu Jul 22, 2004 2:11 pm
by ketfos
Hi Poorna,
Can you please elaborate on what is your input and processing for the above error message?
Ketfos
Posted: Thu Jul 22, 2004 2:44 pm
by chulett
Check
this thread and see if it helps.
Parameter text exceeds ....
Posted: Thu Jul 22, 2004 3:57 pm
by poorna_76
ketfos wrote:Hi Poorna,
Can you please elaborate on what is your input and processing for the above error message?
Ketfos
I am trying to load data to SQL Server database from a Mainframe data.
The Data is in a flatfile, used ComplexFlatfile stage.
ComplexFlatfile ->Transform->ODBC
I am just loading the data into SQLServer.
thanks in advance
Posted: Thu Jul 22, 2004 5:14 pm
by ketfos
Hi,
It appears your string data is being right truncated.
Output buffer is not large enough to retain entire string.
Hence it is being truncated.
Ketfos