DSXchange

Turns out Progress was a red herring, and that describing the P-E as a "mainframe" probably wishful thinking. It's the Perkin-Elmer port of TOTAL only. Had a meeting with them today; they have three utilities that can dump the data from the hierarchical database into flat formats as well as COBOL pr...

I defer. 768 is the maximum key size supported if GROUP.SIZE is 1.

I think the original error was probably caused by trying to write a NULL key, which is invisible in the error message of course, so the maximum key size is not relevant if I'm right there.

ulimit is a UNIX setting, normally set in the user's login profile. You need superuser privileges to increase it; we usually specify unlimited for at least file, data and stack.

I have a new challenge, to get data out of a (hierarchical) TOTAL database running on Progress on a Perkin-Elmer mainframe. There is no ODBC access nor any "native API". There is only server edition of DataStage available. FTP access is available. Has anyone ever successfully achieved this? I'm sure...

TELL US whether this query works in sqlplus or TOAD.

Help us to help you! Ultimately this is an Oracle error, not a DataStage error.

If you do change a Shared Container you will need to recompile every job that uses it. Usage Analysis can reveal which jobs these are.

768 is the maximum allowable value. You can only reduce it.

Delete the .developer.adm and .operator.adm files from the project on the server. These files store the lists of group names associated with each role.

Why not just use a lineage analysis? (You need MetaStage for this, but that's now being pushed as the reporting tool of choice, so you may as well buy now - resistance is useless!!)

I fear that you may be relying on a behavior that might be fixed in a later release.

There are also good examples in on-line help for Oconv.

This article is also informative.

Disable row buffering for this job. You can then process as many rows as you like. 15000 rows is not many.

Neither the Sort stage nor the implicit sort (by which I assume you to mean sorting specified on the input link of a stage) goes out to UNIX sort command - at least by default. If you want to bring UNIX sort into the mix why not bring third-part sort utilities such as SyncSort or CoSort in as well? ...

V = view. The basic top-level design of a job is always V0. A local container is V1, the next local container added to the job is V2, and so on. S = stage. The numeric part is the order in which the stage was added to the job. P = pin. A pin is the intersection between a link and a stage. Again the ...

Can you be more precise about what processes you are seeing? Are they DataStage Resource Service (which is the only thing that could accurately be called "DS Server")? Or are they dsapi_server and dsapi_slave, which can indicate that there were connected clients when you stopped DataStage?