DSXchange

Does the sequence job itself abort or the server/parallel job that you are calling in your sequence? A) If it's the sequence job itself that aborts: Create a wrapper sequence that calls your current sequence. Then you can capture the abort the same a you would when calling a server/parallel job. B) ...

If you do not insert a sort operator then datastage will insert one for you behind the scenes. It will sort on the keys that are being merged. It is best to insert the sort operator yourself because that way you know exactly what it is sorting on and you have control over other aspects of the sort. ...

I think you would have to setup an ODBC connection to it and access it throught the ODBC stage. You may need to download a MS Access ODBC driver for UNIX.

The Operator role can only run released jobs. I'm prepared to bet you have none of these.

Ray, I'm runing parallel jobs in windows. As far as I know there is no such thing as releasing parallel jobs. So, the operator can run them.

Any other ideas?

view the production job log, but not be able to run the jobs. So granting operator access is not an option

An operator can run jobs. I do not want the user to be able to run jobs.

Is there any way to limiting access in director to only be able to view the job log? We want our developer to be able to view the production job log, but not be able to run the jobs. So granting operator access is not an option. Does anybody know if this is possible? I can't think of any way to do i...

You can call the command from within a shell. The input box that takes in the command would execute a command to create a new instance of a shell and the parameters would be the path of the command that you want to run. I do this in windows. For example if I want to execute c:\var_path\mike.exe wher...

In windows both CuteFTP or WinSCP support scripting which you can call from a datastage command activity. DataStage v8 has an SFTP stage.

If you're running DataStage on Windows then you must be quite familiar with runaway jobs. These are jobs that don't complete. They just keep running even though they are not doing any processing. Most of the time this happens because of bad design or limited resources. To deal with this I created a ...

This is how I did it: Using a sequential file stage: 1) Create a longvarchar (or longnvarchar) column that will hold your xml. 2)set format properties as follows: record level->Record type = implicit field level->Delimiter=none NOTE: Make sure that you remove all other record level or field level pr...

Maybe you can optimize the compare part of this task. That is, do you really need to compare with every record or can you limit it somehow? You can try doing the parsing in SQL if it helps you get a direct join with the lookup table. You can do a sparse lookup if you can find a way to limit you resu...

You can set the APT_NO_SORT_INSERTION parameter and in the sort stage set the "don't sort previousley sorted" option. You also need to make sure that the job runs in sequential mode. Otherwise partitioning may mess up the order. If you need to run it in parallel mode then you will need to ...

I just use the User Variables Activity instead of the Routine activity. I call the routine in the User Variables Activity. This way I can call many routines in the same stage and I don't need to deal with that disable auto-handle errors bull sh**... since I need that feature on for other reasons and...

did you use the kill command from datastage or command line? in Windows I use TASKKILL to kill the processes that are running under my userid and the job Aborts. Sometimes the job says that it is running when it is not. Just recompile it and the status will be reset. You can also stop and restart DS...

I just go certified yesterday. It was difficult, but do-able. I found that there was not much time to think about the questions. I used up 2/3 of my time when I got throught the first half of the questions so I had to rush the rest of the questions... But I passed with an 85%. The marking is strange...