DSXchange

Space issue?

They did. Skyboy, best to stick with your own post. Let us know if you continue to have issues there, please.

How? With the syntax Ray posted, hence the 'in other words' comment.

Sounds like a problem to me. :wink: You can use the Notification Activity stage in a Sequence job to send emails with attachments and not worry about any sort of 'syntax'. If for some reason you feel you really need to use the DSSendMail routine for this, simply locate the DSSendMailTester routine i...

Short answer? Yes.

That's the way a pivot works, I'm afraid. In your case, 1 row in will always equal 15 rows out and then as you said you need to filter out the ones you don't need - typically the ones where the non-key field(s) are 'empty'. There really shouldn't be any kind of 'buffer' issue here and as long as the...

Not that I am aware of... and besides, you don't want to "preserve blanks". Perhaps some Teradata experts need to weigh in here but I'd wager it works like any other database - if you send the field over with spaces in it, that's what you get. If you don't want them you need to trim them b...

If you do an exact search for "Controller problem: Unhandled failure" all will be revealed. You'll also note that all the posts regarding this are examples of how to use it in the Transformer of a Server job, not the Routine Activity stage of a Sequence job. What exactly are you trying to ...

Create a work table, load the list of values there, join with your table.

So actually I'm not right and the exact opposite of what I said is what you need.

Trim() or TrimB()

You need to be more specific. You "got an error" - where? What error? Do you mean your DataStage job actually ran and logged an error or there were errors logged by AutoSys when it attempted to start the job? :? Best if you post the unedited text of the error message here so we have some i...

What do you mean by "ignore the last spaces"?

I'm guessing from your subject that you want to preserve the trailing space and it gets removed during the load?

In other words, just chop off the last three "s" bits.

Yes. An Oracle client must be installed on the DataStage server for DataStage to be able to use any 'native' Oracle stages. And it must have a valid tnsnames.ora file in order to connect anywhere. As noted, chat with your DBA if you have specific questions on Oracle setup and configuration. If you w...

Does this job run correctly from the Director and the only time you have an issue is from the command line?