DSXchange

Nearly everything is in the RT_SCnnn subdirectory in the project, where nnn is the job number. Dump and read the score to see what's really to be executed - it may be materially different from your ... Ray I can't read other. Anyway I understood. just another little question. What is Orchestrate? D...

Ok, I found it. I selected a Job DS PX, I query the repository to retrieve its jobno and i view the related RT_SCnnn. There are several files but two of this have captured my attention. OshExecuter.osh and OshScript.osh When DataStage schedule to run the Job I think that it execute one of this two o...

Hi

May anybody indicates to me how to view the objects generated by DataStage after the compilation of a Job PX???

Thank you very much in advance

Umberto

Try "StringToDecimal(Trim(InputField))".......

Hi I need to look for a Job referencing a stage, Teradata export Stage, with a particular name. I think to do that using dsjob utility in a Windows Shell Script. It list all jobs existing in my project and for each of them it list all stages. I qualified the stage interesting me filtered them by the...

You can usa a normal text editor to view a dsx file. It is a normal text file. Anyway you have to import into you project, using datastage manager, to see the job. The job, named "test0001", is saved in "Test" category. Tell me if you are not able to do that. In this case I send ...

I send you an email and a dsx file with an example.

Hi I resolve a similar problem with a trasformer Stage. It receives one input link, the data red from the table, and put the output in three link. In the first you put in the first colunn "aaa", in the second "bbb" and in the Third "ccc". Merge this three links using th...

Hi I resolve a similar problem with a trasformer Stage. It receives one input link, the data red from the table, and put the output in three link. In the first you put in the first colunn "aaa", in the second "bbb" and in the Third "ccc". Merge this three links using th...

Hi I resolve a similar problem with a trasformer Stage. It receives one input link, the data red from the table, and put the output in three link. In the first you put in the first colunn "aaa", in the second "bbb" and in the Third "ccc". Merge this three links using th...

Good morning to everybody I have developed a PX Job, with DataStage 7.5.2 installed locally on my notebook (windows XP SP2), reading a flat file and writing the data in an another flat file. I use only a Trasformer stage mapping the input fields in the output one without any type of trasformation. T...