batch SID

mohanraj · Post by **mohanraj** » Mon Aug 07, 2006 1:17 am

hi

Can anyone tell me how can we generate batch SID for the datastage jobs. If there is any routine then plz send it across it to me.

Thanks in advance

Regards
Mohan

mohanraj · Post by **mohanraj** » Mon Aug 07, 2006 2:22 am

hi

why no reply

What is batch SID ? and what is the use of creating it?

Ray.wurload r u there

mohan

ArndW · Post by **ArndW** » Mon Aug 07, 2006 2:24 am

What is a Batch SID? If you could explain that then perhaps someone might answer. Could it be a "Session ID"?

loveojha2 · Post by **loveojha2** » Mon Aug 07, 2006 2:48 am

Can anyone tell me how can we generate batch SID for the datastage jobs. If there is any routine then plz send it across it to me.

I guess you are talking in terms of peoplesoft related product EPM!!!!

It is nonthing but the sequence number genarated per run, i.e., for one run of a job one particular number, that's all.

The purpose could be tracing the runs when say a particular table (e.g. error table) was populated.

The routine is as simple as KeyMgtGetNextValue.

loveojha2 · Post by **loveojha2** » Mon Aug 07, 2006 2:52 am

hi

why no reply

What is batch SID ? and what is the use of creating it?

Ray.wurload r u there

mohan

You got a response from ArndW in less 2 hours time, what else you want?
Hey Ray, sombody is calling you.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 07, 2006 3:14 am

My priority is always to those that pay me. Misspelling my name and using SMS-style abbreviations reduces my desire to help. If you were paying for my time you would be in a better position to demand help from me personally. I post on the forum as and when I can, and I am probably in a different time zone than yours (see Location in my profile - it changes from time to time).

As others have noted, you have not explained what you mean by your term. Clearly it is not one with which we are familiar, otherwise we would not be asking. Do you mean a "guid" from SQL Server? (If so, search for GUID - this has been answered in the past.) Otherwise there are lots of ways of generating unique values within DataStage, including the SDK Key Management routines.

mohanraj · Post by **mohanraj** » Mon Aug 07, 2006 3:16 am

Actually my problem is that how can we generate unique batch SID for the particular job and next SId for next run of the same job.

mohan

ray.wurlod · Post by **ray.wurlod** » Mon Aug 07, 2006 3:26 am

Nobody knows what you mean by the term SID - to us it's just another TLA.

ArndW · Post by **ArndW** » Mon Aug 07, 2006 3:26 am

Even though you haven't told us what you are using as a "Batch SID", I'll assume that loveojha2 gave the correct interpretation of what it might be. In that case, what is wrong with using his suggestion of implementing KeyMgtGetNextValue()?

mohanraj · Post by **mohanraj** » Mon Aug 07, 2006 3:35 am

I mean batch SID(serial id)

mohanraj · Post by **mohanraj** » Mon Aug 07, 2006 3:36 am

I mean how can we generate batch serial id of the datastage job

kumar_s · Post by **kumar_s** » Mon Aug 07, 2006 4:46 am

Why do you want batch SID for jobs. Job are uniquly named, so no need to serialize it. If you are using any multiple instance job, and if you are expecting the invocation id to be serialized, you have several option.
Or if you are expeting the jobs to have release no, it is done by version control.
Help us to help you...
What exactly you need?
What are you trying to do?

chulett · Post by **chulett** » Mon Aug 07, 2006 6:42 am

mohanraj wrote:hi

why no reply

Good Lord... you complain you've had no reply after an HOUR?

What was wrong with the KeyMgtGetNextValue() suggestion? That's one of the easiest way to do that in a DataStage job. If that won't work - as noted, tell us why not, make your needs clearer.

mohanraj · Post by **mohanraj** » Mon Aug 07, 2006 7:16 am

I am really sorry I was in urgent need of answer for the doubts so I just asked why no reply
Nothing else than that
Sorry again to all

mohan

mohanraj · Post by **mohanraj** » Tue Aug 08, 2006 12:37 am

My actuall problem is like this

My job sequence contains 10 jobs and all the jobs contains 10 tables with one common column batch_SID.If I run this sequence then all the tables should get same batch serial number.
How can I achieve this?

Thanks in advance

Mohan