DSXchange

OK, that's nice... go right ahead. Now, if you'd actually like some help doing that, you'd need to spell out your business rules in words and provide some good / representative 'before' and 'after' examples. Then maybe someone could help or perhaps it will become more obvious what it is you need to ...

That would be controlled by your $APT_STRING_PADCHAR setting. Try searching here for that variable name to see the many conversations we've already had on the topic.

Before what job? I thought this was all happening in a Sequence job via the Routine Activity stage. Sounds like you are making this more difficult (and more hidden) than it really needs to be.

Let's learn to be more specific, please. There are three ODBC stages in the product, which one are you using? That matters as it changes the answer to the question.

Regardless, read the Connectivity Guide for ODBC pdf, it will list your options, including how commits are handled per stage type.

Let's start with what stage are you using?

You now have three posts on basically the same subject.

Where are you doing this?

Do you have a direct link to that pdf?

That "operator" role is severely nerfed / broken in any pre-8.x version and only allows people in that role to see released jobs, something virtually no-one does any longer. The only good news is if you upgraded it would work as expected. Otherwise, you'll need some other mechanism to deli...

This might help get you started, that or a search for "bteq". For 'Sequence failure' a link to a Terminator stage is generallly what is needed but there are multiple ways to skin that cat.

Fine. Doesn't really help answer your question however.

Can you not ask this question of whomever wrote the job? Anything in the Long Description that may provide a clue, any Annotation on the canvas? I'm sure I already know the answer to all those questions but they need to be asked, regardless.

Seriously, you need to spend some time reading the docs and just doing some general study on the subject of web services. There are a ton of resources out there, so it's not like they're hard to find. As Ernie noted, the WISD Input and/or WISD Output stages are for when you want to expose your job a...

1$ is not the same as $1 which is what is in the original post and which can mean something other than "one dollar". However, there's no way for anyone else to know without seeing the job and knowing something about the environment it is running it.

Well...'DS' stands for DataStage and the definition of a macro, function and routine aren't any different here than they would be anywhere else.

If you still need help with this, please don't post "something like" what you are doing - post exactly what you are doing so people can provide the proper help. Also note that saying something "is failing" really doesn't give us anything to work with, always a good idea to post (...