DSXchange

It's probably easier to do in a DataStage parallel job, using one of the change detection/capture stages.

AuditStage, like ProfileStage, is really about determining what's in a file, not about comparing two files, until you get to analyzing for potential foreign key relationships.

The job sequence's log summary will include the exit status of each job invoked from the job sequence. If you have a hierarchy of job sequences you may need a more complex script using either iterative or recursive techniques to search the entire tree of control.

You are connecting to SQL Server through ODBC. Dates must be in ODBC-legal format. However, your error message appears to indicate that you are using some kind of function in the SQL. This is not permissible for INSERT, only for SELECT. Can you post your SQL statement as well as the exact error mess...

It's "hashed" file, not "hash" file. What's changed since it worked? ("Nothing" is not the correct answer.) Is/was the disk full at the time? Does the user have appropriate permission to all the directories in the path, all the way from the root of the file system? Once you find what changed, don't ...

In summary: 1. Projects are completely independent of each other. 2. Operating system permissions (in combination with DataStage roles) can specify who can do what in projects. That's all you need. You do not need the hassle of -itag installations, which is how multiple versions of the server are ru...

You may find it easier to use an ODBC driver for text files and throw an appropriate SQL query at it. SELECT column_list FROM filename T1 WHERE column = (SELECT MAX(column) FROM filename T2 WHERE T1.key = T2.key); Or you could use two streams, as others have suggested, or two jobs. T...

It's "hashed" file, not "hash" file. Because of the mechanism that locates records in a hashed file it is impossible (unless the hashed file is damaged) to have duplicate keys in a hashed file. Please check that your key is defined only on these six columns. What you are seeing is possible if there ...

Is there to be an upper limit on how long you are prepared to wait? On the other UNIX machine, does the application write the file to the other directory as it's being processed, or only once it's fully processed? If it's the former then you still have a problem determining that processing is finish...

Which XML stage?

Can't you import "via ODBC"? Your ODBC DSN definition can specify tilde as the delimiter character.

Don't neglect to get the data types correct. From your example I assume that name (the input column) is a string and the output column is an integer of some kind. Therefore the comparisons will need quoted constants, and the default value must be an integer. If InLink.Name = "a" Then 1 Els...

This post from today may help.

Anything you want to do with an input column in the Transformer (or Modify) stage you need explicitly to name that column in the stage input link.

You seem to have very many nodes in your configuration file; perhaps there is a timing issue getting all the nodes to respond in time to the licensing score. Involve your support provider.

Is it the Transformer or the SQL Server stage? To answer this question lose the SQL Server stage and replace it with a Sequential File stage.