DSXchange

DataStage job logs are located on the server. However they are not log files, as you have assumed. They are database tables in the repository. If you determine the job number of your job, from the DS_JOBS table, then the log for that job is a table called RT_LOGnnn, where nnn is the job number. You ...

If you run the job from a job sequence, you can choose the run mode to be "reset if required, then run".
Then you schedule the job sequence.

Doesn't matter. They'd soon enough scream if uninstalling DataStage removed some DLL that's also used by their software (for example mfc42.dll). Therefore Ascential (and any other provider of .NET consuming software) ought to scream if uninstalling Visual .NET takes out files upon which they too rely.

It might be right, but I doubt it. Get a dictionary listing of the hashed file from either the Administrator client command window or a TCL prompt on the servre (you may need to SETFILE first). LIST.DICT hashedfilename Then, if the positions do not coincide with the metadata from MetaStage (what's a...

EXACTNUMERIC is in uvconfig, and so is on all platforms. However, Windoze is one of the operating systems that can deliver time to a granularity no better than milliseconds (at least that's true for NT 4.0 which is what I still run on my laptop). Try a function that returns the result of 2/7 to see ...

Yes, that would do it!

But it's odd that the uninstall did not detect that there were other consumers of .NET resources in the Registry.

Might be worth letting someone in Microsoft know.

Hashed files are navigated by ordinal position of the field within the data record. If you scroll to the right in the Columns grid for a Hashed File stage you will see Position, Type and Assoc columns. Position is the ordinal number of the field within its data record, type is "S" or "M" (single or ...

Since I live in the Asia-Pacific region thanksgiving (in the US sense) is meaningless. But thanks for the thought. Precision of time is only as good as the operating system and the programming language can deliver. DataStage Engine may be able to deliver more than milliseconds, again depending on th...

Ascential purchased Torrent Systems to acquire their parallel execution technology, which Torrent called Orchestrate. Ascential re-named the technology "Parallel Extender". So the answer to the question in your subject is that Orchestrate is the old name of the underlying parallel execution engine. ...

Thanks for posting the solution. Having to install the .NET framework was a new requirement with DataStage 7.1; your problem and solution suggest that the DataStage installation process "remembers" that .NET framework was installed as part of the DataStage install, and removes it when DataStage is u...

You must be a member of the Administrators group to perform any DataStage administrative tasks.

Technically there is only one "data type" in DataStage server engine. It's called a DATUM, and is a pointer to a structure. One of the things in the structure is an indicator of what the current type of the value is; for example NULL, not assigned, integer, decimal, string, cached function start add...

I'm surprised that the message mentioned uvrpc if you're really using 7.x as claimed in your DataStage release information. I'm equally surprised that you claim to be using PX on Windows; you can only design PX jobs on Windows - you can neither compile nor run them on this platform. The RPC mechanis...

The code works, and was properly formatted (by being wrapped in Code tags) when originally published. The routine *DataStage*DSR_MESSAGE is an internal DataStage subroutine that mimics the behaviour of the printf range of functions in C as well as being able to find the "translated" version of the m...

As a general rule, standards are developed in-house. The important thing is that they are consistently followed. Some of the standards I follow include: There is ALWAYS a description annotation (12pt, top, left, no border, transparent background) at the top of the design canvas. Short and long descr...