Parameter marker text size exceeds allocated space

[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

[ketfos]

Hi Poorna,
Can you please elaborate on what is your input and processing for the above error message?

Ketfos

[chulett]

Check this thread and see if it helps.

[poorna_76]

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

[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