I have some doubts about the working of parameter markers. in one of my jobs i have a col with values like 0.69999999 which i want to round off to 0.7 and output to a sql server table.
I do this in the transformer by specifying the datatype for that col on output side as decimal (2,1).
the value gets rounded off to 0.7 which is seen in the log message on director but the sql returns an error msg as
Code: Select all
[DataStage][SQL Client]Parameter marker text size exceeds allocated space
I searched on the forum and found a post which says that if there n cols then there would be n parameter markers but doesnt explain how the parameter markers work.
my doubt is if DS is already rounding off the value in transformer stage, then SQL server should not give the error unless the rounding off is being done by the SQL database.
If anyone can point where i am going wrong..
Karthik