DSXchange

I've already posted my thoughts.

chulett wrote:have you established whether you can or cannot connect using it in an ODBC stage in a job?

The more details you provide about what you are doing, the better.

Then you'll need your own routine or script to do this as DataStage doesn't support it 'natively'. Installing something like blat would make this much easier.

Correct. It will look for the parameter in the file and not find it, thus letting the parameter default.

Now search here for "Fault type is 11. Layer type is BASIC run machine." (or individually) and see if any of those posts help.

As noted, I don't believe that you can. What people do is export the entire project and the 'cut' the dsx into individual component files afterwards.

You just need to make sure you can send email from the box using 'sendmail'.

SBSA_DW1 wrote:Problem is only with imported Server Teradata API jobs from 7.5.2 to 8.1.1, if we develop a new server job then there is no issue.

If you develop a new server job that accesses Teradata then there is no issue?

From what I remember, Ray has posted about the Fold() function for requirements like this. Never looked up what it did, however.

We're not talking about parameter sets and value files, if that's what you are referring to, those aren't available in any pre-8 release.

Yes, stage variables are a part of the Transformer stage. And they're not "disabled" for you, they're just not being shown - click the button at the top of the Transformer that says "Show/Hide Stage Variables", it's a toggle.

This is the FAQ Discussion forum.

Please repost your question in the proper forum depending on if this 'routine' in question is a BASIC Server or PX C++ routine. And when you do, provide more details of this issue.

Do you recognize how very (very) dangerous doing something like that is? Are you literally planning on running every job with unlimited errors allowed?

You forgot the % in front of the "dd" token, which is why you got the day of 1 for all dates, I'd wager.

That would have to come from IBM / your official support provider, I would imagine.

Normally, I would say a typical 'here document' script would do the trick for something like this. However, they won't work for passwords in things like ssh or sftp as they just don't allow it. You can do everything else that way, but you'll need to set up authentication (RSA) keys between the serve...