DSXchange

And that, in turn, implies that you must have APT_ORCHHOME and DSHOME set. You also need APT_CONFIG_FILE set to point to the configuration file that was in use when the Data Set was created, or to a compatible configuration file. The dsrecords executable, as koolnitz implies without being specific, ...

Yes, but what client access is possible? Is there a specialized ODBC driver? Is there a specific API? You see, DataStage doesn't actually "support" anything. As far as Oracle is concerned, DataStage is just another client application. If there is an API, then you can write - for example - a Build st...

Answer this: what client and API support exist for OREDB ?

UniVerse and UniData are multidimensional databases. DataStage can extract from them. You need to get more information about the structures involved, probably from someone outside of the DataStage milieu.

Forget rows/sec!!! It's meaningless, and it's a "red herring" in the present context.

My guess is that there's a blip in your network causing these disconnections. Get your network administrator to investigate.

It's been no big deal - non-administrator tasks, such as creating projects, are disabled if the login is not that of a DataStage Administrator. I imagine that the same is true if the DataStage Administrator role (or not) has been allocated through the IIS security mechanism. Indeed it's sometimes us...

What I really meant was to create a separate "test bed" containing main(), a bit like the server routines test environment but in C and at the O/S level.

DSguruji, where's the FAQ ?!!

From memory we installed Powerplay and were able to use its metabroker.

That would have been useful to have in Aug 2006 when I needed it!

Tell us how you are deriving your stage variables.

Have you considered other stage types, such as Remove Duplicates (which allows for First or Last of each group)? That way you would need no stage variables at all to fulfil your requirement. Simply group by SN.

They already have. This thread and the one referred to have excellent, best practice advice.

Separate your inserts from your updates.

APT_COMPILER and APT_LINKER can be pathnames.

If the record schema is simple, the Sequential File stage also has the ability to "read as EBCDIC" or "write as EBCDIC".

Are you able to re-start the XMETA database (the common Repository)? Non-existent categories should be created as part of importing.

Every time I've seen it it's been a licensing issue on the compiler. Some C++ compilers are licensed for only one user at a time, and they behave differently if a second compile is attempted while one is occurring. You might also like to disable operator combination to find out exactly the source of...