DSXchange

Run the command by itself, without the head/sed, so you can see the full output. Do this for both running and completed jobs and you'll see that the answer to your question is yes.

Okay, cool. For the record, then it's just a matter of looking them up during the existence check and adding them to the update so only the correct record gets updated.

Again, do you not have something in the table that uniquely identifies each record, some combination of fields? Are you not tracking the effective date / dates of a change, for example?

Even without a surrogate, there must be some combination of fields that uniquely identify each record. For us it is the Business Key Field(s) with a effective date of the change. Plus other things like a current indicator come along for the ride. So we can insert the new record with the new effectiv...

Or just use the SCD stage. I'm unclear what makes it "obvious" that you need them to happen in a certain order... I've never seen a Type 2 where the order mattered as long as both happened.

Yeah, you may want to consider putting the spreadsheet in an encrypted zip file... but then I haven't keep up those protections either.

Without a doubt!

You cannot connect to an 11.5 server with anything other than an 11.5 client and it looks like you are trying to use your 8.7 client.

In my experience, the general answer when Oracle throws that "invalid character" in a tool like this is because you've included a trailing semi-colon. Don't see that here, hence the desire to see the full / actual SQL.

Neither do we... can you post the actual, unedited SQL rather than the redacted version please?

Define "project properties" for us. Otherwise we'll just have to fall back on the generic answer of istool.

Make it nullable.

Error says it all. The format mask you use needs to match the incoming data, not what you think the end result should be. This so it knows how to parse it. It already knows what the end result needs to be.

Create multiple files based on what? Meaning, switch when, based on what, filled with what? And the filenames are simply numbered? This rather than based on input data.

I doubt those zones are time zones, Andy.