Multi Instance job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nvalia
Premium Member
Premium Member
Posts: 180
Joined: Thu May 26, 2005 6:44 am

Multi Instance job

Post by nvalia »

Hi,

we are using a multi instance job and will be passing values like B and C as invocation ids so that we can read from different source files. I want these to be concatenated to the final outbound files respectively.So what should I add as a part of output filename to be able to do it.
e.g. we want op files to be
<opfilename>B.txt - for InvocationId B
<opfilename>C.txt - for InvocationId C

Thanks
NV
Lotus26
Premium Member
Premium Member
Posts: 48
Joined: Tue Jul 13, 2004 2:09 pm

Post by Lotus26 »

Hi

If you parameterize the invocation id and then use that parameter in defining the output file name then I think you can get it.

Thanks.
Regards
Lotus26
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Should be simple enough to double-check, but I'm not sure if you can have a 'dot' in the Invocation ID. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
nvalia
Premium Member
Premium Member
Posts: 180
Joined: Thu May 26, 2005 6:44 am

Post by nvalia »

Thanks to all for ur reply.

1. We do not need "dot" as part of the file name..that would come anyways as with all file names..we need only B or C dynamically.
2. Yes, I am already doing it using a parameter..but I was thinking if there was any other way where we could directly do it w/o using a parameter
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Use the DSJobInvocationId macro instead, wrapping it in hash/pound signs if you are using it for part of a filename.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nvalia
Premium Member
Premium Member
Posts: 180
Joined: Thu May 26, 2005 6:44 am

Post by nvalia »

Thanks chulett.
This is precisely what I tried and it worked.
Post Reply