DSXchange

Giving same name to links in both the containers was the first thing i tried when i could not match the metadata, but i didnt work out. The metadata doesnt match even if the same link names are used in output of first container, input of second container and even in the connecting link of the job. B...

Thanks Sainath it worked.
its really amazing how the matadata could not be matched even thought at both places same table definitipons were loaded.
Is this due to some valid reason or just like that. Thanks a lot for your help.

Hi All, I have a shared container with two output links and another shared container with two input links. In the second container both the input links are used as right links for two joins. I want the output links from the first container to be the input of the second second container. The column d...

Hi Vivek, there is a round about way to do this. Put the two jobs in a container with the output going to the file earliar being the output of the containers. Now use these two containers in the same job and use a funnel stage to collect the output. from the funnel you can take the output to a seque...

Thanks a lot Duke,
it worked by changing the DSLogFatal to DSLogWarn. Actually i want to capture a warning when a job aborts.
Thanks a lot
Mrinal

Hi Duke,
Thanks for the tip. I did remove the "abort" but still the main job thats calling the other jobs is getting aborted. is there anyway i can prevent this.

I am using a job to run several job. This Job has a sequential file as it input which contains the names of the jobs to be run. This job is supposed to run each job from the file. For this i have a transform routine which runs the job and writes the status in a status file. This whole thing is worki...

Larry
Try once by taking the same data from Database into a sequential file and doing Oconv(string,"MCP"). From what i have observed "?" should be replaced by ".". Please Let me know what happens in either case.
Mrinal

Hi Larry, All the unprintable characters are replaced by "?" only for display purpose . But actually theyare not equal to "?". Say the string you got is "27ft?" where the "?" is the replacment for superscript. Try equating it with "27ft?". The two st...

I need to join three files together to get the desired file. currently i am doing this by doing a join twice like File B File C | | | | File A ---> Join-----> Join ---->Output File both the joins are Left Outer. I need some fields from each file. While going through the documentation of DataStage PX...

Thanks Arndw and battaliou,
The point about future maintainace is very valid and one must take care.

Hi i was also doing something similar and am getting "*"'s in result field. Please let me know what should be input type amd length and in which format will this functaion accept date. Also what should be output type and lrngth.
Thanks in advance

So will it be okay to ignore such warnings

If the routine is built and tested, you can create a shared container of the a server transform stage and incorporate the shared container in your PX job. Thats what i am doing now. but i was looking for some better way to get this done. I think calling a Server shared Container in a PX job may hav...

Hi, I have a DataStage Server routine which i need to call from a PX job. I tried using everything including using transform for the same but nothing worked. can there be a round about way to call a routine from the PX job. Currently i am using a server shared container for the purpose but would lik...