DSXchange

Might be worth getting this in front of your official support provider, may turn out to be something they can patch. Or explain.

Seems to me just having an "OK" trigger and setting the option to "Automatically handle activities that fail" might work in this case. No need for any Exception Handler if you don't need to do anything other than stop if they don't run 100% clean.

Well, first off there's no such thing as the "last record" in a hashed file, any more than there is one in any other database table. Why do you ask? What are you trying to accomplish? As to the count, for an account-based hashed file (i.e. one with a VOC record) you can use SQL to count an...

Was your original SQL... "large"? I wonder if it was too long and getting truncated at some point, we've seen that before with other stages but I have no idea what the string limit is on the Connector stages.

So Andrea, can we mark this as Resolved now?

As noted - 'cd' to either DSEngine or a Project and then launch dssh by fully pathing the executable. The latter will remove the need to LOGTO.

1) As step 2.5 then fully path step 3.

2) One dssh call that runs all steps one after the other, all in the same 'session'.

Because it couldn't find it.

That directory is not in your $PATH. Either add it or fully path dssh so it knows where it lives.

Exactly, why start this conversation all over again?

<locked>

As noted, if you 'cd' to the Project directory in question, you don't need the LOGTO. Otherwise, just do both commands in the same dssh session with a proper delimiter between them. Semi-colon?

FYI - the DIGITS transform is a short-cut to that particular OConv function.

So, something specific to Teradata - have you taken that message / code to your Teradata DBA?

It is turning it into a relative path from your 'current working directory' which is the Project the job is in. He did suggest you put your slashes the other way, UNIX style rather than DOS, so that it looks more like an absolute path. See if that change helps at all.

No clue, never played with that ancient verson and because it is so old I doubt there is any level of official support for it. Give whatever you think might help work around the issue a shot and let us know the result. However, I do not believe you can simply 'download' a copy of MKSToolkit, at leas...

Your single quotes are being stripped, which is an unfortunate but standard DataStage behaviour. In the past we would have told you to "escape the quotes" but now there is an environment variable you can set to turn off that behaviour.