DSXchange

OK, exactly what I was wondering, thanks for the clarification.

You could, I suppose... but the answer could be as simple as two triggers coming from whatever checks the date, a Routine Activity as one example. One trigger is the 'success / thumbs up / why it *is* the right day' trigger and goes to a Job Activity stage and the other is a 'thumbs down' trigger th...

From a private email sent to me. :!: Roydanlobo, please do not do that again, post all responses and questions in the proper forum and/or thread, save the private emails for actual "private" stuffs. Thanks. --------------------------------------------------- I have 4 inputs which are ODBC ...

Really? That's... interesting. News to me.

Jury will disregard the witness's previous testimony.

Can you not discuss your confusion with regards to the stored procedure with whomever wrote it? If not them, then whomever has taken over support of it? You want to check in the job and then do what if the day is wrong? In my opinion, that check should be done in a Sequence job and then only run the...

:idea: Rahul, please stop endlessly quoting entire posts just to reply. There's a perfectly good Reply to topic button at the bottom of every page that you should learn to use rather than the dang Reply with quote one you've been pushing. Save it for when you need it, when it's not obvious to whom o...

Or just "dsjob -ljobs <Project>".

Sorry for my ignorance, but does all this talk of NLS settings imply that the installation is "NLS enabled"? I don't see that explicitly stated anywhere and this all seems do-able to me with just proper handling of the NLS related environment variables... but I may be wrong. Anyway, bonne ...

No, you don't - use the 'dsjob' command line API instead.

Note that Arnd said to not touch 'this setting' while support said not to touch 'this command', two different things. And if you change something in uvconfig you must execute uvregen for them to take effect. But I agree that you should be able to 'fix' this without touching anything at the installat...

He meant -jobinfo rather than status.

Perhaps an exact search for uvregen is in order?

The trim() worked and the NOTFOUND worked, so we're basically done here. The last question seems to be regarding where these "extra" trailing spaces may have come from, not why they caused the issue. I think.

Proper forum most welcome as well. i> What does a "null" integer value in your fixed-width file look like? Make the "null value" property for the field match. ii> I have no idea what that means. Are you saying that in a fixed-width file you are getting only two characters in an e...

More like brain pains. But mostly it lets me know where to split it out to.

Hopefully now that we know exactly what we're dealing with, someone will have a helpful suggestion.