DSXchange

I don't recall if the 'source' for that utility is available but I assume it is... you may be able to copy it and create a 'Silent' version, much like there exists one for ExecSH for the exact same reason. Copy it and see about not logging some (or all) of the information you're passing in.

And probably disable the display of 'Categories' as well.

Are you sure you really want to change this? That is standard XML and will "show as intended" when the XML is processed on the receiving end.

Never used or evaluated any open source schedulers but I'm sure Google would turn some up for you. I've been involved with both Control-M and Tivoli implementations, both work well but anything 'Enterprise' will be pricey. And from what I recall, the price will depend on how many 'clients' you would...

The only way your DataStage job will be able to process that selected data is if the SP is called from your job itself, not the other way 'round.

We get all that. That's straightforward. What you still haven't explained is what drives your "if my job runs X times" requirement. How is it triggered? What controls running 2 versus 3 or 5 times?

People, we're in the Server forum with the Job Type marked as Server so please stop handing out PX solutions.

EBCDIC is not hex. There should be a routine in the sdk to translate one way (EBCDIC to ASCII I believe) that's the one you'll need to 'reverse'.

:!: As noted, there is no Funnel stage in Server jobs. Please pay attention to the job type when posting. And as normal, Sunitha needs to do a better job of asking questions to get proper answers. What do you mean by "merge" here, especially after making the comment that "they have no...

Are you talking about a static number to indicate the source table? Or a unique sequence or pattern of 'numbers' from each table?

Hmmm... believe we're already got one of those posted.

Best if you posted your error and details rather than saying it is "the same" as someone else's which really doesn't help.

As I said, it's all in the pdf documentation. You can also just type 'dsjob' from the command line without any arguments and it will dump a standard usage statement. You can also do an exact search of the forums here for several examples of the syntax. This post may help as well, but it is rather......

Sainath.Srinivasan wrote:You do not have funnel in server jobs.

But you do have a Link Collector.

Sure! You would use 'dsjob' for that which lives in the DSEngine/bin directory. The Server Job Developer's Guide pdf has a Command Line Interface chapter where it is explained in detail. And while you can use it for simply running jobs (which is what I assume you mean by 'calling DataStage') there a...