DSXchange

Yes, that information probably should have gone out as a readme on the resource disk. The server (razor) uses a Linux operating system. Well done for resolving it.

Try it with DBMSTYPE = ODBC or even DBMSTYPE = UNIVERSE.

We are performing a new installation of DataStage Parallel Extender, to check the installation we performed some tests and found some problems with dates. One of the tests is the calculation on the number of days between two dates, to do that we are use the iconv function, DaysOcc = iconv (DateEnd,...

BLINK = backward link Records in hashed files are stored as doubly-linked lists, each record in a group having a forward pointer (to the next record in the group) and a backward link (to the previous record in the group). For redundancy and the ability to repair the file, the BLINK is actually the X...

Welcome aboard. This is most easily accomplished, once data have been sorted by the key, in a Transformer stage using stage variables to detect whether a non-null value has already been processed for the current key. As many rows are output as are input, into a Remove Duplicates stage that allows on...

I doubt that DataStage can read IXF files directly (lacking metadata), but is there any reason you can't dump them into staging tables and have DataStage use those as source?

[ Edited to remove reference to Oracle ]

Me too, since there is no way to rename a project.

A project name is a schema name, and the only way to "rename" a schema is to drop it and create it afresh.

BASIC-style functions are used in the parallel Transformer stage and translated into C++ equivalents. You can inspect the generated C++ source code if you wish noting, however, that some of the "translations" involve opaque objects delivered with the product. Source code generated by Trans...

Use -wait OR -jobstatus option, not both.

Without either of these control returns to first.ksh immediately the job starts.

The address of the BLINK error suggests it's not related to the 2GB limit.

Sreenivasulu wrote:Pls us

What is your default date format string? It is is not "%dd-%mm-%yyyy" then you need to specify the date format string - inside square brackets - in the Specification in the Modify stage. date_from_string[%dd-%mm-%yyyy](inputcolumn) Note also that this will not work if your date is not prec...

Unless you change it, 31538 is the port number on which dsrpcd listens and therefore the port number used for all clients to communicate with their agent process (dscs or dsapi_server) on the server, since the latter are child processes of dsrpcd. It's not random. The other port numbers are used for...

Can you check also that all the nodes in db2nodes.cfg are mentioned in the DataStage configuration file?

That is NOT the case. Re-installing is only necessary to change from NLS-not-enabled to NLS-enabled or vice versa. Loading/reloading maps is achieved simply by restarting DataStage. The Administrator client reports which maps are loaded and which are selected to be loaded at next restart.