DSRoutine

[dspxlearn]

Hi,

I am new in writing routines .I am wondering if,a routine can return more than one value or not.
In my requirement, i am getting a string delimited by commas.I have to extract each string delimited by comma.I am using string[] function for attain this.
Or is there any other way to do this.

[balajisr]

Use Field Function.

[dspxlearn]

Hi balajisr,


Thats fine..My problem is, can a routine return more than one value.
Eg:
I am getting a string,

Hi,How,Do,You,Do

So in the string i have to extract the strings dilimited with commas.i.e,
Hi
How
Do
You
Do

I have to pass these values to my next Jobactivity as parameter..

[kumar_s]

It may be possible with Start and End loop activity.
Pass on a value thorough a parameter say 'I' from the looping activity and fetch the Ith value of the given string and pass as parameter to the next job activity.

[bchau]

Thats fine..My problem is, can a routine return more than one value.
Eg:
I am getting a string,

Hi,How,Do,You,Do

So in the string i have to extract the strings dilimited with commas.i.e,
Hi
How
Do
You
Do

I have to pass these values to my next Jobactivity as parameter..

Can you provide more details about what you are trying to do?

If you are setting the job parameters in the job activity stage, you can use the "field" function to extract the target value. In your example you can use field("Hi,How,Do,You,Do",",",4) to extract "You" from the string to set the parameter.

[balajisr]

As kumar mentioned you can use start loop activity. Pass the comma delimited string to the loop activity.Choose delimiter as comma.
The job will invoked for each item in the comma delimited string.

It would be better if you can give some more details of what you are trying to do?.

[chulett]

My problem is, can a routine return more than one value.

To answer your question - No. You need to do exactly what it sounds like you are doing, returning some kind of delimited value and then breaking it up into its component parts after the fact.

[dspxlearn]

Hi Kumar_s,

My requirement is i will be getting a seq file in which, there will be multiple lines which are comma delimited.Each line is a set of parameters to the job activity.
So, i have to read each line and divide them based on the delimiter (,) and pass these list to the job activity which has the job.
After this, i have to proceed to the next line and so on....

[kumar_s]

As mentioned use Start loop activity to pass the value of n to the funtion field("Hi,How,Do,You,Do",",",n) which lies in routine acitivity. The output of the routine activity for each loop can be passed to the subsequent job activity as a parameter.