DSXchange

This may be an issue with the internal representation of the Euro symbol clashing with DataStage's internal representation of NULL (Char(128)). Can you please check your file to see whether that symbol is 0xA0 ?

Then you're probably on an operating system that does not support the DataStage shared memory interrogation commands (even though use is still made of shared memory by the software).

Or just do the appending in a Transformer stage. Follow the Transformer stage with an Aggregator stage that captures the last row of each group.

Forget about parameters. They're not relevant here. Your issue is purely one of resolving a host name to its IP address, probably via gethostbyname() function internally.

What happens if you execute C:\IBM\InformationServer\Server\DSEngine\bin\dsjob
(a) alone
(b) with only the -run option
(c) with -domain, -user, -password, -hostname and -lprojects options
(d) with -domain NONE, -user, -password, -hostname and -lprojects options

Welcome aboard. This particular forum is about ideas for the DSXchange site itself - your question probably should have been posted in the General forum. That said, we (I, at least) will not answer questions when the complete answer is readily available in the public domain, in this case the IBM web...

There should be no trailing backslash on the executable name.

One is part of InfoSphere, the other isn't.

When's the interview?

Use a server job, or a server Sequential File stage in a server Shared Container that you can put into a parallel job. This stage has a "contains newlines" property that's not available in its parallel equivalent.

What do you need to DO with a,b,c,d[,e,f] ?

For example, if you need to generate a new row for each value in the list, this is a great candidate for the (new at 8.5) Transformer stage looping feature.

Are the columns quoted?

If auto-purge is enabled, then the job log is purged according to the auto-purge specifications whenever the job finished successfully (with no errors). Warnings are not errors. An event is logged if this occurs, reporting the number of items that were purged from the log. These have gone forever. Y...

The sample test was there - indeed still is - for the DataStage 7.5 certification exam. For the newer versions you can do a "ten dollar" trial exam - more items, taken under proper exam conditions (through Prometric).

The solution is to resist stupid requirements. This is not what the orchadmin utility (note spelling) is intended to do. Yes, of course, it can be done, but it is going to cost double the volume of data in disk space compared to the volume of data to be merged (a total of three times the volume at o...

Looks to me also like Aggregation, grouping on the first three columns and then min/max on the other two.

Don't forget to get your partitioning (and sorting, if you need it) correct.