DSXchange

Can you rename the job you are tring to overwrite? If so, does the import give you the same error? Does your userid have RW access to the DS_AUDIT file in the project directory? If yes, then the error might lie in a corrupted DS_AUDIT hashed file, but I would say that the access rights are a more li...

As Craig has already stated, one cannot treat a dataset like a table and selectively delete or modify records. If you need to do that, you would need to write a job to selectively perform these actions while copying to a new dataset.

The two are independant of each other and do not need to be used as a pair.

You cannot rename jobs from UNIX. You could change the name in the DS_JOBS entry for that job but would need to do so from within the ds shell or from the admin tool. Your best bet would be to find someone with GUI access to rename the job for you.

Do you get the error if you don't update the job but create a new one? this means renaming the original to something else before running the import.

Yes, while a link collector stage performs no SQL "join" functions, it does perform, in effect, a "UNION" of n-input links into one output link regardless of values as long as the columns are identical.

By using a UNIX level delete of the directory you have corrupted your project and no longer can delete it normally. Try creating a new dummy project, then copying that directory contents to your old project directory and re-trying your delete. Ahh, I just saw that you have version 8, that method may...

first, don't look at the remote file, look at the file on the UNIX box after transfer. If the characters are still correct then you have removed a possible error source. The sequential file read stage will use the project default NLS setting. Assuming this is "UTF-8" it will read this file...

Almost every single NLS thread here on DSXChange which deals with transformation or mapping problems has at least one post that explicitly says not to use the "view data" from the designer to detect or check multibyte character. This thread is now no longer an exception. Use your favorite ...

There is a big difference between a "NULL" and an "empty" column value. In your case you want an empty value, which is easy to generate as server edition is not really type-bound. Just declare it as a string in the output and, if necessary, put in a derivation of "IF In.Numb...

Yes, you need to ensure that both files "open"ed point to the same physical file. You can replace the "OPEN" command on one project with an "OPENPATH" command and use the full path to the hashed file in the other project.

What is the DB2 database NLS setting - both within DB2 and from your DataStage ENVironment's settings?

It is possible for the jobs to only contain executables and no design-time information. You can edit the .dsx files to check.

Yes, you can find and edit it's default value in the Administrator, then insert and include the variable as a parameter in your job(s).

Sreeni - could you explain? I have been using waves in this project at V8.0 for over a year with great success. I am specifically looking for a manual method of triggering or processing waves; when done through the normal wave mechanism this is 100% transparent but unfortunately the sequential file ...