DSXchange

Add a reject link to the Sequential File stage. Direct rejected rows wherever you will.

FTP is a good solution provided the Windows machine is open to FTP requests (DataStage does support Secure FTP). Otherwise some form of remote copy command, or use technology like Samba to mount the Windows disk on the UNIX machine.

If you sought my professional opinion I'd advise getting a definitive answer from IBM through your official support provider. UTF16 is, however, a superset of UTF8 (that is, UTF8 codepoints are exactly the same codepoints under a UTF16 regime), so leaving the metadata repository set at UTF16 ought n...

Welcome aboard.

The structure of the common metadata repository is not documented, and IBM reserves the right to change it at any future release. Therefore whatever you discover might only be useful for one version. Or you might be lucky. I'm happy enough with the tools now in the clients.

How have you set the SCALE ?

Exactly the same error, with exactly the same CLASSPATH settings?

If not, do start your own thread. Indeed, you should do that anyway, because you are on a different version than prasson_ibm.

There's no call to Terminate in your TestConnection class.

This may explain why the second attempt to connect fails.

I would prefer that you take up the issue of the possibly wrong answers with IBM directly. After all, the most that I could do is support your assertion that none of the options is correct; I could not do anything about fixing that situation.

Is there an empty line at the end of your source file, column heading, comment lines, anything like that?

Keep in mind the horrible weather currently besetting the eastern USA.

Can you show us exactly how you are attempting to build the header string?

DS_JOBOBJECTS, as its prefix suggests, contains only design-time information, not runtime information. Runtime information is stored in tables with RT_ prefix, particularly RT_STATUS. Structure of these tables is not documented, but may be inferred from inspection of various header files. It is not ...

That is both correct and annoying. Rest assured that IBM has been made aware of the requirement (though an enhancement request from you wouldn't hurt; the more the merrier).

On the other hand, you should be backing up the repository (and the staging repository) in any case.

By "the official one" I mean
http://www-03.ibm.com/certify/tests/sam421.shtml or its earlier incarnations.

How are you reading them now?

Assuming it's an ls command, just add to that - maybe sort in date/time order and pipe the result through tail -3 command.