DSXchange

The Connectors are what you should be using. All of the other stages have been 'deprecated' and for all we know IBM will drop support for them in a future release.

Have you read the docs on the MQ Connector stage? I would imagine it replaces the pieces you think are missing.

If there is a consistent number of days they consider to be a 'month' then a mod() is a simple solution. The example is a little... odd... to me as the first 31 days are considered a month, then 28 then 29 and then who knows.

Just Ray.

I've seen how the documentation calls it Job Sequence or Sequencer Job interchangeably so it doesn't really bother me as long as you include 'job' in there... there is a Sequence stage after all.

Sure seems like a Mod() might come in handy here...

It's helpful to present multiple options especially when the requirement is not clearly defined. I don't know what to make of the suggestion of using a loop. I actually find it annoying. Seriously. :wink: Usually the answers are all over the place and the vast majority are irrelevant. I prefer to g...

You might want to throw in a "grep -v grep" for good measure.

It may not natively support them, but any stage should be able to execute one in its OPEN/CLOSE or Before/After SQL areas.

That's not a DataStage question, can you take it to your Teradata DBA?

Read Eric's post.

There are not a lot of SAS related postings here, especially lately. You may need to hit up your official support provider for this.

An empty string "" is not the same as null. Sounds like you need to explicitly check for that.

Or that.

You are missing the job number from the clear command. Each job has a unique number assigned to it that all of the internal structures are tagged with: CLEAR.FILE RT_LOG1234 You can get the number by querying DS_JOBS: SELECT JOBNO FROM DS_JOBS WHERE NAME = 'YourJobName'; I'm not aware of any command...

No... setting it bigger just means DataStage will allow it to 'overflow' and get rejected by Oracle if anything turns out to not fit. And the limit is in bytes, not characters.