DSXchange

That chulett guy hardly ever knows what the heck he is talking about. :wink: I recall them working fine in triggers but as you've found you have to be precise in how you code them. I would stick with no spaces: Execute_Command_1.$CommandOutput<1>="N" I learned about them from studying and ...

What I recall is messages can only be 'handled' from Parallel jobs, not Server or Sequence jobs.

Right... don't worry about the "from DataStage" part quite yet. Find out what they support, what external access methods / API they have and go from there.

Are we still restricting answers to only the ODBC Connector stage?

Now, having said that, on to your actual question. Sadly, that is default Excel behavior that has driven people nuts from the beginning of time and there are plenty of discussions out there on it for ther Googling. There is no option to disable that, unfortunately. The only "workaround" se...

:!: Apologies in advance, Oracle, but I'm going to use you as an example of something Not To Do, something I "fix" over and over. This time decided to point it out and then do the dirty later. Nothing personal! Thanks for coming up and standing on the stage with me for a moment. :wink: Whe...

I wonder if Andy had any luck last month or perhaps could reach out again?

First you need to find out who is the Official Support Provider for your company. Ask. It could be the vendor your company used to purchase the product or it could be IBM directly. The 'who' will lead to the 'how'.

Ah... okay. I'm set to be 'remembered' so it automatically logs me on every time I come here.

For some reason I can't duplicate the old behavior I was expecting to see when I logged out and then check Premium posts, might be a Windows 10 thing or something. However, I can't make the Premium Content button show up for me, even when I'm logged out. :? Anywho, to the best of my knowledge the on...

I'd still like to see the requirements clarified.

Really? That's completely new news to me. I seem to recall there being plenty of posts over the years where the errors posted using the StringToDate() function were all about using the delimiters incorrectly. Ah well. Certainly seems like something easily tested but I have no such capability. :( Ju...

That's fine... you've lost the ability to capture the value it was allegedly returning that you allegedly needed when you use it as a target like that but if that's working for you. [shrug]

Still doesn't change any of the advice given here, however. Keep that in mind for the future.

I don't recall dsenv living there... logged in as admin, echo $DSHOME and see what it says, if anything.

Of course. I was kind of in a hurry so didn't include all the caveats that you did. They need to be fully aware of the dates they could receive and - if needed - decide on a "century pivot" value so they know what to add if they all don't fall in the two thousands. And yes, those attempts ...