DSXchange

Any warnings?

I note that the table name in the DELETE statement is #DBSchema#.ADDRE while in the INSERT statement the table name is #DBSchema#.ADDRESS

This certainly would cause the symptom you describe, and should generate warnings about "invalid table name" for the DELETE statements.

Welcome aboard! :D As Roy mentioned, you could search the forum and find one or more solutions. Internal format dates in DataStage are integers, so all you need to do is to convert your start date to internal format, identify your stop rule, and go for it. An easy solution involves a Transformer sta...

There is NO interactive debugger for job sequences.

There is no interactive debugger for parallel or mainframe jobs, either.

Not sure why you want to know, but you determine the prefixes by inspection of the VOC hashed file. If you attempt to change the prefixes the routines will cease working. It's more complex than just the prefixes.

As Wolfgang stated, the BASIC progamming language can access fields in hashed file records without any metadata needing to be defined. Indeed this is how DataStage Engine can access the Repository tables without the full metadata being defined. Metadata are only needed for queries. Most databases in...

I think you need to restrict the requirement to production environments.

I write, and encourage others to write, small jobs as part of the learning experience, experimenting with different ways of doing things. I feel that this would bias any results.

A brief search on the forum would have found exactly this quiestion having been discussed comprehensively over the past two weeks.

These relate to the corresponding concepts/properties in MQ Series, for more details read the IBM documntation on MQ Series. In oversimplified terms: priority is the message priority - a number that indicates how important the message is sequence is simply a unique number of the message, but can als...

Adds a whole new meaning to DCS, doesn't it?!!

Ya hafta have a three letter algorithm otherwise IBM doesn't understand what you're talking about.

Or just cite the DSXchange Complexity Scale, which ranks complexity on a scale from 0 to 50. And the answer is (naturally) 42.

Depends which forum you're posting on! Generally we only talk about the major and minor numbers, so we say we're on 7.0, or 7.1 or 7.5 or 3.3 (eek!). At this level, both engines are compatible irrespective of the third component of the version number. Indeed, the third component may not exist on eve...

NLS is not needed for EBCDIC to ASCII mapping.

You can disable NLS easily. Set NLSMODE in uvconfig to 0, regenerate and re-start DataStage.

You can not uninstall NLS without totally uninstalling DataStage. Search the forum for more on this.

You alternative is to create your own mailer routine and invoke it through a Routine activity rather than a Notification activity. This approach gives you complete flexibility as to what you include in your email. Within the routine you call DSSendMail to send the mail. There is an example of how to...

One of my main differentiators is high quality documentation of everything I do at the customer's site, another is that I try always to mentor at least one person in my techniques so that anything I leave can be maintained. Elegantly simple designs aid in this. One of my main success criteria is tha...

What data type have you assigned to the column that is to receive the message you're trying to read?