datastage server edition

prasad.bodduluri · Post by **prasad.bodduluri** » Sat Jul 07, 2007 7:02 am

in keymgtgetnextvalue in this funtion what parameter is used
please give answers.
thank you[/b]

chulett · Post by **chulett** » Sat Jul 07, 2007 7:10 am

Locate any routine in the Manager and double-click on it. You'll be able to read the Long Description which usually explains everything you need to know about the routine. You can also examine the source code to get a better understanding of how it works.

This would be true for the KeyMgtGetNextValue routine. Pop it open, read all about it and then let us know if you still have any questions.

Teach a man to fish...

chulett · Post by **chulett** » Sat Jul 07, 2007 9:03 am

Ok...

Prasad, in an email, wrote:hi, in keymgtgetnextvalue funtion what parameter is used if i used this funtion in job, whenever i run the job, sequence value is used can you give me solution for it. thank you

First off, email is for private matters, not to continue a forum posting.

Secondly, did you do as I asked and look at the routine in question? It states a couple of salient points there:

"Routine to generate a sequential number"
"The routine argument is the name associated with the sequence"

So, for every discrete value you pass to the routine, a sequential number will be maintained, incremented and returned to you. Pass the same name in again and get the next number associated with that name. You will need to maintain a logical naming standard for Sequence numbers you'll need for any job in the Project as they are available project-wide.

If you still need help, post back here.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 07, 2007 9:29 am

I don't mind private email, provided it is a request to engage my professional services - in this case as a paid consultant.