DSXchange

It is not the function of the Exception Handler to do anything. Its only task is to detect that one of the activities has not completed successfully and - when that happens - to trigger its output(s). Whatever happens downstream of that is entirely up to the developer. (That's you.)

Welcome aboard. :D Code? That's not how these products work. They each have a graphical user interface. Audit Stage (formerly known as Quality Manager) collects a sample of data and performs various metrics. Best advise is to get in touch with your vendor and ask for some marketing collateral - glos...

That's why there's a trial - to work out the best way to go. I believe that a number of ideas about how the premium posters should work have been fed back - ultimately someone (Editor?) will make the call. Without prejudicing that decision, my preference is for the premium posters themselves to be a...

"They" took it out. But the underlying command (DS.CHECKER) is still there. Search the Forum - Arnd posted something about it recently.

patonp wrote:Is it as simple as concatenating multiple dsx files into one, or is it more complex than that?

It's more complex than that. Each DSX file has its own header. You need to make sure that the result has only one header.

As far as I know there's no documentation for DS.TOOLS. "They" expect you to work through the client tools; DS.TOOLS is really there for the convenience of "their" consultants. However, DS.TOOLS is documented in some third-party training packages. One, at least.

If you drive all your security through group, user ID is largely irrelevant. Anyone can own the files. You can, of course, use chown to replace the owner. But - and it's a big but - some of the files in the DataStage engine directory (particularly in the bin subdirectory) have very specific owner re...

Compared to the cost of the software, even the "official" IBM training would be regarded as affordable. Check out their website, or your vendor, for dates and times (and costs).

SQL Server expects milliseconds. Concatenate ".000" to your timestamp.

Welcome aboard. :D

Is that a trailing "-" on your filter command?

Filter command is execute and its stdout becomes what is read onto the Sequential File stage's Output link.

The answer is still NO in the batch file. Just can't be done - in the batch file.

The best you can do is hide the password in a shell variable or in an environment variable. The /P switch requires a clear password. Maybe

Even though you have server edition, you do get the Parallel Job Developer's Guide in the Docs folder; the first couple of chapters give a pretty good overview.

Yep, that's one of them.

Thanks for posting quick solution. The other thing people sometimes forget is to be logged in as qsadm before starting qsrtmngr. The netstat command can help to find ports in use.

Check all the optional properties (in the "available properties to add" area). You can change the encoding and the disposal of particular categories of difference.