DSXchange

Go back to your source, where the data comes from. Ask them what date that value represents. There's no way for us to know.

No, you've said you need to convert to a TIMESTAMP not a DATE. Regardless, any external format will work as long as you match that in the function call with the proper mask.

Don't use the substring function, use the substring operator - the square brackets: YourField[3,5] takes 5 characters starting from the 3rd. That syntax is universal across the two products.

AS the target is not null I changed the incoming rows from null to ' ' . will that satisfy the condition? Has it satisfied it yet? As noted, spaces are not a valid date. You need to use an 'in-band' null value, an actual date that represents null based on your business rules, say like "12/31/9...

Not all answers come from Ray, although it seems like it some days.

Right, a full path not a relative path. That or 'cd' there first:

Search here for USERSTATUS.

Those are the two ways but you don't need a Sequence job for the first, it can be done 'after job' using ExecSH.

Then you'll need to ensure you pass in a full timestamp value, not just 'a date'. Of course, that timestamp can contain a completely zero time portion, including any fractional seconds (if needed).

A null date is valid as long as the target accepts nulls. Under no circumstances is any number of spaces a valid date.

What is the Oracle column's type? While the job can use a Timestamp in either case, things are different when populating a DATE versus a TIMESTAMP.

Sure, of course you can add it, just wanted to make sure you understood it wouldn't help with this particular run. As to the 'how to achieve' question, there is the Terminator stage you can specifically link to or read up (here and in the docs) on the 'Automatically handle' compilation option. With ...

"%yyyy/%mm/%dd %hh:%mm:%ss"

Post the actual, unedited error plus the exact syntax you used in your job.

Too late now, unfortunately, you'll need to run the jobs manually from 4 on outside of the Sequence job to pick up where you left off. That or copy the Sequence and remove the first three jobs. In the future, build restartability into the Sequence via the 'Add Checkpoints' compilation option. Make s...