Hi all

Here are two subjobs in one father job.
one of the two named "Waiting for Rank"(call it job_a ),the other named "Rank"(job_b).

job_a—(onsubjobok)—>job_b

job_a write data into a csv file,and job_b will read and process it.

in job_b,there are three tmaps,each of them  do the same operation ,adding sequence cloumn for the tables order by different cloumn. so,here I used Numeric.sequence()  three times .( to distinguish them,i use "s1","s2","s3" as the string parameter).

when i run the father job directly,I get wrong sequence number for table1 which use the "s1" as the string parameter for the function. However ,if I run the two subjobs one by one,the result is ok.

I don't know why..

I change the "s1" to "s",and then ran the father job,the result is ok again.

Could any one give a in-depth expression about the function Numeric.sequence(string,int,int)  for me? especially the string parameter.

Thanks very much.

BestRegards,
Joe