DSXchange

There is no reason to use any KeyMgt calls, that would slow a job down immensely. The MODulo will give you a group number, but won't split output files automatically. By far the easiest on UNIX is split. If it must be done in a DataStage job I would put the logic into some short BASIC code, since a ...

" " is a string and doesn't need conversion; so I am not sure in which stage or where in your server job you are getting these errors. Could you explain in a bit more detail where this error is occurring?

When debugging code it is helpful to print out intermediate results and, when in doubt, check the manual for functions you are not sure of. I used the "DCOUNT" instead of the "COUNT" inadvertantly, so the postiion of the last space or dash was reported incorrectly. If you wish to write this as a fun...

They effectively do the same thing as specify inter-process buffering and you can leave them in, they will not impact performance.

Yes, you can use the syntax of In.ColumnName[6,14] or even a RIGHT(In.ColumnName,14).

Not that I know of.

The sequential file stage only supports one delimeter character per file. If you have several characters then the best way is to read the whole record as one long column and change the different delimiters into a single one, write this to another sequential file and then read that file with the corr...

Actually, the hyphen contains the error. Replace the ' ' with '-' in the hyphen derivation, I made a typo.

Please look at your Parallel Job Advanced User Guide and search for "message handler" to get details on how to implement this functionality.

At version 7x you don't need to insert IPC stages if you specify in your job's "performance" settings that jobs are to use interprocess buffering and/or your project defaults are set to do so. Splitting a job to run in separate processes will only give you a performance benefit if the job is CPU bou...

I would not use DataStage to do this, but would use the UNIX split command, which is quite efficient and does exactly what you want.

It isn't quite as complicated as you think. You can do it with a couple of stage variables: LastSpace INDEX(In.String,' ',DCOUNT(In.String,' ')) LastDash INDEX(In.String,'-',DCOUNT(In.String,' ')) Then the derivation for the left part would be : LeftPart In.String[1,M...

DataStage jobs shell out with a current attach point / working directory of the project that the job runs in. Check there for the output file.

DataStage jobs shell out with a current attach point / working directory of the project that the job runs in. Check there for the output file.

It would be very helpful if you could actually tell us what the error is. You should also include the contents of the variable Output in your error message.