DSXchange

Try searching on the errror message. I remember a few posts on the same "specify width" error. Or read them as char and downstream change the type.

I was going to advise the modify stage as well. Give both these strategies a short.
EE is very particular as its skeleton is built over a strongly typed language(C, C++). Hence its always advised as a first step to take care of all data type conversions and stick to it till the very end.

Search here. There are lots of posts be Kim explaining the same, and in depth.

I have not worked on windows so I will let someone else give the insight on that. Unlike DB2, oracle does not like internal formats for dates. It has to be in YYYY-MM-DD format. I dont know how this would have worked in windows keeping in mind that the DSEngine is the same for both the platforms.

Make sure its nullable from the first stage.

How often does this happen? Are you purging your log files regularly. Also keep the &PH& folder size in check?

I bet not. I think you need to set that as nullable.

Welcome Aboard
Simply do a null check using IsNull(). If its coming from a flat file you might also want to check for zero length after trimming the column value and then explicity set it to null using SetNull().

your funny sud djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible. Your query is not that hard, at all. Pass t...

Confusing. Please explain in words. Your also maipulating the dates. What needs to be added to what date and on what criteria.

Put an annotation outside the transformer on the canvas. You cannot put comments inside a transformer stage, as far as I know.

Date() inside the transformer or OS level date function? What expression are you using with Date()? Date() creates internal format. Now its upto you to change that to the format you require using the OCONV() function.

Use Convert()

If you specify it as not null in datastage but its a nullable column in the database, it wont help. Explicitly use the IsNull() function to check for nullability and either reject the record or specify a default value.

Its an ODBC error. Can you please give us some insight on the job design the sequence job design. What other error messages are there, if any and what happens when you run this job outside the sequence job. Do you still get the same error message?