DSXchange

also in case of run time error, can you please post the error message? I am getting problem while running the job, compilation is fine . I am not passing the InvocationID as parameter. I am ticking the check box 'Allow Mutiple Instance' in the sequence job properties. When I click the Run button it...

chulett wrote:What's your exact "7.x" version of DataStage? ...

7.5.2

also in case of run time error, can you please post the error message? I am getting problem while running the job, compilation is fine . I am not passing the InvocationID as parameter. I am ticking the check box 'Allow Mutiple Instance' in the sequence job properties. When I click the Run button it...

priyadarshikunal wrote:

pklcnu wrote: The problem is with the Dot ('.').......if i remove Dot from slname.counter then it will take the whole thing as a text ........

It should be specified like a parameter. Use it like

Code: Select all

#StartLoop_Activity.$Counter#

Same thing not accepting #

Sreenivasulu wrote:The erromessage is straighforward. Do not include alphanumeric values in the slname.counter.

Regards
Sreeni

The problem is with the Dot ('.').......if i remove Dot from slname.counter then it will take the whole thing as a text ........

You can use the datastage sequence generating routine as the invocation id. Regards Sreeni Hi Sreeni Thanks for your reply, I was unable to pass the routine to Invocation ID field, the routine name is taken as text and the same routine name is appearing as Invocation name in log, basically DataStag...

Use slname.$Counter as the invocation ID, where slname is the name of the Start Loop activity. ... Hi Ray Thanks very much for your reply, I tried what you said but I am getting an error warning as soon as I enter the slname.$Counter in to the InvocationID field. The error warning is ' InvocationID...

there are two options 1. use counter of start loop activity as Invocation ID, because of that you will have 20 different instances in your director and it will also show you the instance was for which value. 2. use userstatus space/or store it in a file(/any where you want to store it) to store the...

Sorry i realised that .................after the submission.......

priyadarshikunal wrote:you can just use counter as invocation ID if they are unique. else you need to store the count somewhere and increment it after every run.

Hi priyadarshikunal

Can you please elaborate bit more.....how exactly to use the counter.....

Thanks very much

Dear Experts I am using StartLoop_Activity ,Job_Activity and EndLoop_Activity stages in a Sequence job. The Job_Activity stage is linked to one particular job which runs for each delimited value in the loop definition list mentioned in the StartLoop_Activity stage. I used the List Loop option in the...

charanyadr wrote:Hi,

My Menu bar display in designer is hidden . I am not able to see the menu bar details in the display[ File,View,Repository,Windows etc...]

Can anybody help how to enable menu bar display.

Go to View and then Select the Repository option.

bobyon wrote:Do you have any filters set when diplaying your log? Are you seeing any informational messages?

Hi bobyon

There are no fileters been set. All I can see is the Log that I posted in my earlier post.

Thanks

Craig's comment there is interesting - only close examination of the log reveals anything. Back to my earlier post, pklcnu, have you checked every entry in the log to ensure there is no mention of data leakage, whether it's informational or otherwise? Hi All I am posting the log. Your input will be...

Is your Array size and commit set to 1? Strange behaviour indeed - the reject link should be receiving rows. Are you certain that is correctly specified? Can you force a different type of error to see if that works, i.e. put an invalid date into a date field? Hi ArndW The Array size was set to defa...