DSXchange

kumarjit wrote:I do not want to use any sort stage/inline sort feature to sort the column.

Why the heck not?

As noted, you can ignore what was actually sent and just generate a sequence from min to max.

It needs to be sorted and then the gaps filled in.

There is no "source file", Andy. The input in the job is an ISD Input from a web service call that is pushing the gzip file down as binary data. Therein lies the rub.

Show us how you "tried all of the above" and what didn't work about it as there's no evidence of trying anything like that in your first post. At the very least your "command not found" error should be gone and we can move on to the next errors / questions. Okay, snuck that in wh...

Clarify something, please. You receive this gz file from a web service and then need to process it in the same stream? Or do you have a chance to land it first? Asking because (as you've found) there are ways to stream them into jobs by doing a gunzip to stdout and then reading that stream as a sour...

Transformer looping.

Decided to move this out into GenPop with all of the unwashed masses.

A hidden file no less.

Typically, one would search here for their error message to see how others have dealt with it in the past. So, an exact search for "APT_BadAlloc: Heap allocation failed" would seem to be in order. I'd start by cherry-picking any of the 67 results that are marked as Resolved and if there's ...

If you're not sure what "fully path" means, it means supply the explicit path to the executable starting from "root" or the base of the drive, i.e. it will begin with a forward slash. For a generic example: /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -logsum <projectname...

Sorry but that's just UNIX 101... without going into a long lecture, fully path the dsjob command and you'll be fine. Or at least more fine.

Discouraged. If you have something to add to the conversation, add it. If you have an interest in the subject or some aspect of it, state it. Just saying "bump" to get it back to the top of the forum? No. Ray - I'm unclear why this is in this forum. Knowing you it was intentional but I don...

Hard to know what to search for sometimes... but an exact search for "disable combination" or "disable operator combination" turns up some examples. Basically you add APT_DISABLE_COMBINATION to your job parameters and set it to TRUE.

Yes indeed. And if you disable operator combination, it will tell you what actually threw the error - although it seems like you already know the answer to that.

Well been awhile but something like this, fleshed out: IF IsNotNull(Column1) THEN Column1 ELSE IF IsNotNull(Column2) THEN Column2 ELSE IF ... ELSE Column15 Based on your stated rules you don't even need bother to check the last one, if you get there and haven't found a non-null yet it must be the one.