DSXchange

Thank you very very much ray :D :D . Your reply was really very helpfull. It is now compiling properly. I also included all the changes that you mentioned in your observation. You really rock

Thanks ray, I will sure keep that in mind.
:D

Hi Guys, I wrote the following routine which takes Identifier1,Identifier2,Identifier3 values as input and compares them with the values that are already been stored in a sequential file using an earlier routine. Common /StoreVal/ Initialize,LastValue,SeqFile,Flag1,Flag2,Flag3 Equate RoutineName To ...

Hi Craig,

Thanks for the quick reply. I will try to implement your solution.

Hi Ukyrd,

return a value to indicate continue/stop.

what value would you return and how would it stop the next job in the sequence from executing?

Thanks for your reponse.

Hi Guys, I have a requirement where I need to abort the following job based on a value written to a file using writeu in a routine, in the current job. To achieve this, I need to manually set the Jobstatus of the current job to aborted, so that my next job in the sequence does not get kicked off. Jo...

Thanks a lot for the clarification ray. :D

Hi Guys, If COMMON variables cannot be acessed across mutliple transformers (if row buffering is enabled or they belong to different processes) and cannot be accesed in an after job routine. Transformer to transformer, yes - with the caveats about row buffering. Transformer to After-Job routine, no....

Hi Ray,

You exactly hit the nail on the head. When I put in SADD(x,y) in the transformer, it was showing red color. Now, I understand why it did that and how to overcome that.

Thank you very much for clarifying it for me. :D

Hi ArndW, That was a really an ingenious approach. :idea: Thanks for sharing it with all of us. In one of my previous projects, there was a Utility (written using C,Embedded SQL,PERL) that used to generate stored procedures. It also had the capability to generate PX jobs in a .dsx format. We then us...

Hi Arndw, In your recent post titled "Add a "DataStage Project Stories" Folder" thread, you mentioned that we wrote a Server Job which in turn created one PX job per Table using table-driven rules and exceptions Could you please let me know how we can achieve that?. Could you ple...

Hi VasanthRm, I dont think there is any limit on the number of rows the aggregator stage can handle. However, the data you are supplying to the aggregator must be sorted and the sort order must be mentioned in the aggregator. Could you please let me know whether you are sorting the data before you s...

Thank you very much for all your responses. :D

Hi Roy,

Thank you very much for your input. However, I tried to use SADD function in the transformer and it gives an error. Therefore, I assume that it can be used only in the routines and not in the transformer. Could you please confirm whether my assumption is correct.

Hi Guys, Does any one know of any datastage function that converts a given string into a decimal number? For Example :- "1943.100" is the input string that needs to be converted to decimal, so that I can apply further arithmetic operations on it. I know of indirect techniques to achieve th...