DSXchange

Replace Field Delimiter property with Field Delimiter String property. The former accepts only a single character; the latter accepts an arbitrary string.

Where did the original question mention Oracle?

Please strive for a professional standard of written English on DSXchange. SMS-style abbreviations are inappropriate, particularly because they make it more difficult for those whose first language is not English. The second person personal pronoun in English is spelled "you", while the p...

The compiler needs to be installed before DataStage server.

It has already been provided, as a Search would reveal.

Don't forget to allow about 2 years to overcome the politics involved in executing (becoming allowed to execute) "foreign" code on "their" mainframe! Expect to have to walk through your code no fewer than five times.

Can you change the Execution Mode property? It may be still that you can't read in parallel - certainly this is true for non-partitioned Oracle tables.

EReplace() is a DataStage BASIC function. It continues to exist in version 8.1.

There is a C++ equivalent for parallel jobs written by one of our posters. This is not provided with the product, but could be found via a Search of this forum.

Help yourself. Search DSXchange. Asking a more specific question might yield more specific answers. The best I can do with your given question could you pls help some body to know about the data flow in datastge? is that "yes, data flows in DataStage". And probably to reprimand you for usi...

7.1 does support NLS. It was probably not installed at your site.

There will be no change to date and time formats - system defaults are always taken from ISO 8601. These can, of course, be changed in Administrator but, unless you do, there is no change.

Welcome aboard.

This is a perfect example of something most easily resolved using a time "dimension" (lookup) table at day granularity.

Assuming that the JCL is on a mainframe, almost certainly not. On the other hand, if you are using EE MVS edition, then you can edit the JCL templates therein so that they can invoke other JCL after the generated JCL has been transferred to the mainframe. But that transfer is not effected under Data...

Don't forget the Cross Project compare tool. This needs design objects in both projects.