DSXchange

Looks very simple.

Use the String function "Index" on the "first" and "last" columns of the input in order to get the desired output in col2,col3...

Refer the developer's guide for syntax on the "Index" function.

Its kind of difficult to understand your requirement. Can you please elaborate more or put the records and result in a orderly manner?.

Well, For those who are astonished or surprised as to why Bharghav inspite of being "New" to DataStage is being assigned such a responsible task. You will probably get a much clearer picture as to the exact situation he is in if you try and understand the system most companies have incorpo...

Thanks a lot!!

What am I trying to achive?

Very simple, to get an answer to the question.

And yes it is.

Thanks Kunal.

Thanks for the quick reply Kris :D

Hello Everyone,

Just a simple question (May sound like an interview question though).

Is there any other stage in DS that is equivalent to the Transformer Stage (Where in we can do the same kind of transformations like that of Transformer)?

Hello Everyone,

Just a simple question (May sound like an interview question though).

Is there any other stage in DS that is equivalent to the Transformer Stage (Where in we can do the same kind of transformations like that of Transformer)?

You need to give more details on this job, what are the different stages used? Is it reading from a sequential file or a database? What stage is the data being written into? Are there any hashed files used in this job? By what you have mentioned its very clear that the job runs slow mainly because o...

Ray,

I did verify in the job log and the parameters are same as the ones passed from the script when the job is succesful, however when the job fails I notice that the parameters picked by the job are of default hardcoded value.

Ray, So when should these variables be present in the dsenv file? Recently we had an "Status code = -14" Timeout error and IBM Support advised us to add DSWaitStartup, DSWaitResetStartup as user defined variables (besides running few patches) at the project level, after adding them I check...

Kim,

Its a batch job, and I beleive all this is due to Timeout factor.

Please do share your views if you think otherwise.

Kim

I noticed that the defaults were used by simple observation, I know for sure that when the job fails the default parameter values are used, what baffles me is that how does it pick two different sets of parameter values.

Dear All, There is a job in a sequence which we run using a shell script and also pass the parameters to it using the script. But, here is the situation, I have been having issues with the sequence aborting and hence did some investigation, upon which it was found that the job whenever it fails is a...