DSXchange

Brad,

as long as you and/or the customer is aware that this method will cease to function (without modification) at some point in the next release then go ahead.

Can you use the positional matching instead? Also, as a last resort you might be able to create a .dsx export file and use a global replace in that text file and re-import it.

In your project directory there is a folder called DS_ROUTINES which contains a DATA.30 and a OVER.30 file. The source code of any routines and functions in your repository. If you edit this with notepad/wordpad/word and save it you will have corrupted your project and will need to restore from a ba...

Well, it is on the server, just not in a file you can view using cat/more/vi. It is just like data in your Oracle database... it is there but not accessible from the OS.

If your name field always has just one space in it (which is highly unlikely) then it would be FIELD(In.ColumnName,' ',2):' ':FIELD(In.ColumnName,' ',2)

Hashed file columns are accessed from DataStage jobs by using their column position as opposed to their name. So adding additional columns to an existing hashed file will not require you to change any of your jobs.

The DataStage repository objects are not stored in any single files that can be read from UNIX or Windows. They are stored in hashed files that can be accessed using TCL or even from within DataStage jobs. The repository is intentionally undocumented to allow DataStage to change internal formats wit...

So far you've described what can be done in a transform with constraints going to different stages in a job. Could you explain what you've tried that didn't work?

Latha, I would like to know, what happens when Job Aborts? When a job aborts it stops running. If it is started from a job sequence that job may or may not also stop running, depending on the sequence settings. See Chapter 6 of the DataStage Designer Guide. It also details restartability, exception ...

Are you doing a simple derivation in a transform stage? If your first column is empty, what output are you getting that is wrong?

(Hallo Klaus!)

Sumit - you really need to tell us a bit more about your problem. Did it used to work? Is it a new installation? Can you load data to or read data from DB/2 (i.e. are you certain your installation is clean)?

Identical post, although under a different userid. With so little information it is not surprising that nobody has responded.

Moderator - please remove duplicate post.

Latha, since IBM/Ascential prices vary by region and customer the last question can only be answered by yourself. The differences between version 6.0 and its predecessor can be found detailed in the readme for version 6.0; I don't have access to that anymore so unless someone who is still on 6.x has...

The obvious is to see if you are monitoring the job in a director session. If that is not the case, then perhaps a previous designer session aborted or another user is actively editing the job. I feel that it is important to have your DataStage administrator (the person, not the program) activate th...

Prashant - a job has so many possibilities that nobody here can answer your question directly. If your job specifications detail inputs, rules and outputs then you can create a test set of data (and lookups) and outputs and compare that to your job run. This is just an example of one possible test s...