DSXchange

External functions are documented for c calls. I would think that if you make a library with an entrypoint for this java program and declare c-type parameters and results then it should work. But you need to link your output files to object code and I don't know how to do that with java.

You will need to shell out to UNIX, perform the selection there and then return the results to your job sequence. What utility you use to do this depends upon how complex your selection is.

I should add that just calling up "orchadmin" without parameters gives a pretty comprehensive help that I've always found sufficient.

There is a directory "Configurations" which usually contains the .apt files. It is located at $DSHOME/../Configurations.

I don't recall seeing it described in detail in the IBM documentation. There is some detail in the original Orchestrate documentation, which is still available through IBM and is sometimes handed out with courses.

Since the CFF stage is only for reading and that original SDK cobol routines come from me, I'll supply a COMP-3 conversion routine. I wrote it this morning and used the binary conversion, I could have done it using just the CHAR() and SEQ() functions and a bit of math, but I prefer it this way even ...

DataStage will automagically repartition from any source partitioning amount to any runtime amount of nodes. You can use the UNIX "orchadmin" command to view partitioning information from the command line.

The answer is "sort of"; with the peek stage you can view selected data from each partition at runtime.

"COMP" is usually, but not necessarily, the same as COMP-3 but each COBOL implementation may choose to use another representation. What system is this COMP field for? Going from a DataStage number to COMP-3 is not complicated, but does require a short piece of BASIC code to implement. Basi...

Sainath - I assume the OP did a "cut-and-paste" in the original post, and there it is written with a capital O; I had the same original thought about the ^0. This is also why I want to get the "real" values, either with the grep -v command or with od -x

Oops, I meant 100K records in my original post (I won't edit it). The other direction, reading a 4 node file with a 2 node configuration also works correctly. I switched my read repartitioning to random and have a 4-node file with 25K records per node read with 2 nodes @ 50008 and 49992 records resp...

Yes, in the director use the "Data Set Management" utility to view your data set and how the data has been split into nodes.

The FTP program has done an EBCDIC to ASCII conversion (usually not a problem unless you have packed decimal fields). The EBCDIC Null maps to ASCII null so that isn't your issue.

Use "cat -v {yourfile}" to find out which characters you really have.

Yes, it works. What I was curious about was going the other way and how DS would handle it. I did a quickie 2-node write of 10K records, then did a 4-node read and it did round-robin of 25K records per node.

I agree; at first I thought I should check up on the syntax that I usually use and post an example, then realized that it was too much work both to write and later to do the remote analysis of a stack and in the end it would go to IBM support anyway. But playing with dbx, particularly with a small p...