DSXchange

Please advise what "not working" means in this context. Accompany your post with any error/warning message that is logged.

Data Set preserves internal format, partitioning and sorting, and is therefore ideal for staging data between parallel jobs. File Set preserves partitioning and sorting, but is exported into human-readable format. It is useful when other parallel applications may need to read the data. The Sequentia...

Thank you so much it worked out, Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31. How shall i implement this. Start with a clearer specification. Are you looking for a "year to date" figure starting f...

I assume you mean "executable" jobs. How is it you have lost all your job designs yet preserved these? That is quite a good trick. Can you be more specific about what you have actually got left? If you have the OSH scripts (whether the original generated script or the score) then it would be possibl...

The orchadmin command has an option for dumping a Data Set's contents, however none for controlling the format thereof. You would need to pass its output through an additional command (perhaps an awk script) to generate your required CSV format.

Create your integer with leading zeroes into the Char(5) (or whatever size) field. Right(Str("0",5):MyValue, 5) will handle length 5.

We do not attempt to diagnose errors from APT_CombinedOperatorController. Please disable operator combination and report the actual error message produced afterwards.

For data type errors we would also need to know the record schema (table definition) and a sample of data.

Hashed files do not support multi-column indexes, though two indexes (one on each field) may still help this particular problem. The BUILD.INDEX command can build more than one index at the same time; it starts phantom (background) processes to build all but one. To deploy multi-column indexes, the ...

All sort methods (explicit (Sort stage), implicit (input link) and inserted) use the same tsort operator. It's just that an explicit Sort stage gives you access to more of the operator's options.

I don't believe a new SDK has been issued.

Ask your support provider to obtain for you a copy of the Plug-In Writer's Guide - a manual that does not ordinarily ship with DataStage but which is (ought to be) available from IBM.

Server job (as marked) or parallel job (as posted) or both?

So a two-job solution may be preferable, or a script to do the FTP to a local file that you can then process through the XML Input stage.

Or or , either of which is more efficient than EReplace(), though for one single execution you probably would not notice the difference.

You might also try using forward slashes as pathname delimiters. But I suspect that it's the space(s) in the pathname that are the root cause of the problem that you are seeing, so the "8+3" name may be your solution.