DSXchange

any suggestions to improove performance? i have tried all that have been suggested till now.

Hi, I fixed all the errors and now the job is loading data into the tables and not logging any warnings. but they are running vrey slow some of them at 30 -80 rows per second. Is there any bechmark speed to which i should try and optimize my jobs? i mean somwhere around 1000 rows per socond. somethi...

Its working now. thanx a lot. There was a schema mismatch between the DB2 bulk load stage and the actual production table.

Ray's advice helped. thanx again

My source is progress and target is DB2

Using the cast function is throwing me an error:

SQLSTATE=37000, DBMS.CODE=-20003
[DataStage][SQL Client][ODBC][DataDirect][ODBC PROGRESS driver][PROGRESS]Syntax error (7587

I used CAST(fieldname as integer) and changed sql type to integer in the odbc stage

will do that. The source is Progress.
thanx for the info. will try and let you know

it says,

SQL3120W The field value in row "F0-1" and column "36" cannot be converted to an INTEGER value, but the target column is not nullable. The row was not loaded.

yes. I have run the job again and then will give you the exact error message

doing nothing does not help. It is resulting in job abort with the message that unable to convert to integer sine the target is not nullable it drops the record

I tries Int(FieldName) but it didnt work

Hi,

Can anyone help me out in converting a column which has a SQL type as BIT to Integer in a transformer.

thanx,
Rohit

Oh Okay. cool.

Am sorry being ingorant bout the rules. I thought my topic was related to this so.

I am also facing the same kind of issue. I my case there is a text field in which user has copied and pasted some data using windows. Now this field when viewed in a text editor contains some extra characters which is causing a delimiter issue in our jobs. The character is there at the end of record...

Ok ArndW,

will try and fix it today. I hope the slowness is because of this issue because i have tried all other solutions to improove the performance. thanx for the advice