DSXchange

Dsquestion,

no, you cannot. All jobs are executed exclusively on the DataStage server machine.

There are ways you can make a UNIX server execute a .BAT script on a windows machine, but they are outside of the scope of the DataStage product.

If you used the canvas and added a new DB/2 stage and dragged the link across then the stage information will also be transferred over; this is different from the link information. If you were to drag your link to a dataset and then drag it back to the DB/2 stage your table and DB/2 connection infor...

The c++ compiler license limits the number of concurrent compiles that you can do; if you try to exceed this limit the warnings that you are seeing are issued. This is only a warning message; perhaps the error about inability to find a license is just an artefact.

Many people have answered that question in this forum before. Doing a search will return many helpful threads, including this one.

sansan, I think that instead of addressing your actual problem with the sort stage you should try to do this sort step using the windows "sort" command - it might give you somewhat better performance. The sort stage doesn't have any problems with 500K rows normally. If you watch the processes in Win...

rkdatastage, I did a quick search of this forum using the terms "config" and "file" and got 292 hits; that would make a good starting point. The question is far too broad and sound suspiciously like an interview question. The "config file" you are referring to doesn't exist directly. You have a "uvc...

Are you fully qualifying the table name with {schema}.{tablename}?

Can you give us exact values for your 3 variables? Put an output link to a dummy text file with the 3 columns, plus you can also add 2 extra columns containing your derivations "stageVariable1 >= StageVariable2" and also "stageVariable1 <= stageVariable3"; these will have the value of either 0 for F...

This "condition" is part of the OCI stage attributes and is not done in a transform stage. From your description you would want to do a "update existing or insert new" in the OCI stage.

Ragu,

if the lookup on the reference fails you can also get null values in the columns. Have you checked the NOTFOUND variable in the constraint?

The method you use depends upon the target database stage. If you are using Oracle then there is a "update or insert" as well as a "insert or update" option.

The "Before/After" subroutines for both server and PX jobs are the same, they are coded in the basic language. If you wish to use another programming language for these routines can can do that, but they still need to be called through a piece of BASIC code.

No, once the job is deleted all information about that job is irretrievably gone and no recovery is possible.

koolnitz, in your case the error message is most likely generated by a misconfigured c++ compiler - it is used when a job has transform stages and would explain that other jobs are correctly compiling. But you also seem to have an installation using more CPUs than you have licensed. I trust that thi...

A dsx file will contain two lines that denote the beginning of a new job:



You can search for the string "BEGIN DSJOB" and then use the string inside quotes on the next line to get the job name.