DSXchange

As Arnd and Ray suspects, have you tried to update those 17 rows into the same table through command prompt.

And hence the second job can do the FTP.

What is the datatype for that column, just to cross check, try to feed (update) null though command prompt to that particular column for that table.

Search for Error 11 in GCI Link initialisation as keyword you may find a lot. One such relevent post is
http://www.dsxchange.com/viewtopic.php? ... =dsipcopen

Have you tried the job design to split into two?

BTW what is the use of transformer4 at dead end?

Or check the reason why you get large value of data in the unexpected length of the column...

What happenes, if you give new path or new file name for the renamed file?

Try to convert into COBOL layout and import. I guess it should help you in importing multiple table defenitions at a strech.

Arnd asking rather to not write into the lookup fileset.

It shows your server is getting loaded heavily.
What is the load at the time when it is called using sequencer.
What is the volume of the data that getting written in to Lookup file set?
Is your IO occuring at different locations?

nothing to do with transformations we are just using couple of hash files along with transformer for look up. seq------transformer-------hash------transformer | | | | hash | | | odbc----transformer-----transformer-----seq this is the structure. So which part as the issue, is it the two transformer ...

Use the above in the before job subroutine with ExecSH.
Use te New_Filename.txt to read in the sequential stage.

A sequential stage between two transformers?
Do you mean a reject link to the second transformer?
What exactly is your transformations in the transformer?

And you cannot delete a post if it has been update other poster. In your other post Ray has updated a post by requesting moderator to delete the post, So you cannot delete it.