DSXchange

Naren12345babu wrote:Also, you have mentioned about Java Integration stage,
Is Java Integretion Stage available in Datastage 11.3 ? I could not find it. help me to know this.

The documentation link for your version. Not that hard to find out there.

Here is a link to the (easily searched for) IBM InfoSphere DataStage Java Pack documentation.

Then do it there if possible, only bring the records into the job that you actually need to process.

Depends on your source... can you do the filter directly there?

Your example doesn't seem to match up to your words. "1 out of 2 records" means what exactly - every other record? Every even? Every odd? Something else entirely? All your example shows are the first two records being 'selected'. I don't know about anyone else but I for one would like to ...

The above logic would definitely work !!! They would stand a better chance of working if you order the stage variables properly. And you only need two: svCount: If InputValueFromLink = svPrevVal then svCount+1 else 1 svPrevVal: InputValueFromLink Your sorting will affect this as will your partition...

Let's start by moving this to the correct forum... hang on... here we are.

Yes.

Honestly? Reread all of the previous replies. Try something. Then come back and ask specific questions based on the results, if you still have any. Questions, that is... not results.

So... $Counter is an integer that comes from the Start Loop stage and shouldn't need any special handling or trimming. And in spite of what Arnd said, what I've found is the string parameter is typically what throws the "is not appropriate" error when there are non-string characters like a...

Interesting... no such thing came up when I searched for it last year, other than "Luminosity Mask" and I figured that wasn't it.

Do you actually mean "umask"?

ScottDun wrote:how can I run multiple files in the command execute stage in a sequence job

I don't understand the question. What do you mean by "run"? You can certainly use the Execute Command stage to return a list of all filenames that match that wildcard pattern, is that what you are after?

Assuming this post is the one: viewtopic.php?t=113429

What APT variable, exactly? And not sure how that would affect loading multiple files, can you post the actual error message(s) from the failed job?