DSXchange

I have used SQL Server in Windows PX Platform. Never had such issues with date. Try creating a dummy table with 2 columns - varchar and datetime. Pass same value (after typecast) to both and check the result. Also run an sql insert via SQL Server front-end rather than DataStage to verify the outcome.

Try to pass values which you are sure are present in lookups.

Did you check the format of data loaded?

Did you test in a stand-alone mode?

Provide sample values.

What have you tried?

You already have the format. Use aa for AM/PM.

How did you attempt running the jobs ? Maybe you are only validating them.

Can you see any log?

What if you write in a sequential file or to peek ?

Did you delete the project after creation ?

Can you 'LOGTO' the project ?

It happens by default.

What is the length of column defined in the stage ?

Not sure what you are asking.

You must investigate your source systems to see what is available.

Deadlocks in server job it not frequent. Maybe timeout.

Can you provide more information on what is being locked / timed out and find what activity is causing the deadlock ? Also bit of your design info will be useful.

Reading and writing alone will not cause deadlock.

The sample code provided by you checks for text value 'AB' in the column and not the date derivations you initiated this thread with.

PS : You must provide format mask for to_date() as DD-Mon-YYYY

Logic is assuming you are working with strings

Insert one extra dummy column in the column generator stage and drop it in the modify.

Modify stage !!??