DSXchange

The leading zeroes are an artifact of the data viewer. They are not really there when a decimal data type is stored. Ignore them - they are included to prove that the precision and scale are being addressed correctly.

DSG.UTILITYHASHLOOKUP is a DataStage BASIC function, a Build stage uses C++ as its language. You therefore have a language incompatibility issue. Out of the box DataStage BASIC routines can not be called from any form of C. There does exist a mechanism whereby you can create a subroutine object, but...

Nothing changes or needs to be. The ODBC driver you are using does not include support for version 7 of Oracle. End of story. You need to find an ODBC driver that does, if you want to connect to Oracle version 7.

You are claiming that you have written a ".dll". Please confirm that this is on a UNIX platform. You can, if you have a well-formed function, create a parallel routine (a definition of the interlude to your function) and call that from a Transformer stage. If your function is not well-formed, it wil...

Not a good answer in a parallel job.

And it's "hashed" file, not "hash" file.

Yes it could, but you could simply create a second output from the Transformer stage that runs through an Aggregator stage (with no grouping columns) to produce the count.

A custom trigger of the form RoutineActivity.$ReturnValue > 0 is what I had in mind.

Try using the Windows code page for Hebrew rather than the ISO one.

Execute the dsenv script first, and make sure your LD_LIBRARY_PATH variable is correctly set (to include this library's parent directory).

Contact your support provider. There were some issues in version 7.5, on Windows XP, for which a patch was provided. The version 8.0 client is a re-write, but some of the same issues may have crept in. Are you on version 8.0 or 8.0.1? In fact, can you advise your exact version number?

Learning how to write professional English would be a good start. Then you stand a better chance in a collaborative environment when you need to document your work and/or prepare specifications for others to follow.

Basically, let the tool guide you and add notes, classes, terms and policies to the metadata and analysis results. Produce reports at each phase - there are ten available. There are five analyses that need to be performed in turn: column analysis (which is resource hungry, as it ought to examine the...

Click the first. Scroll down. Shift-Click the last. That selects all of them. Then press the Delete key. Respond to the "are you sure?" dialog.

How many processing nodes? For example with 8 nodes that is still only one million rows per node. DataStage parallel jobs are capable of some real "heavy lifting" when properly configured.

Try the same trick again, but this time re-selecting VERSION after the invalid project.