DSXchange

You'll need to check for these empty "tags" and assign a default value it seems to me.

Next time, start your own topic please.

That's too much data for the Aggregator to process, you'll need to sort your data first based on the grouping keys and then assert that sort order in the Aggregator stage. Do that properly and it should be able to handle pretty much any volume.

And that 'official IBM support channel' means you need to ask for it from Support and they will make it downloadable for you. It will not be generally available.

As djm used to say here - try "man paste", it will cure all your ills.

No, it's not going to have any kind of native drivers for that. I would imagine you'll either need to purchase ODBC drivers or perhaps an iWay Adapter. I would also ping your official support provider if I was in your shoes.

Talk to your DBA, make sure he lets you in on when multiple processes writing to the same table can deadlock. Adjust the job accordingly.

Well... worst case... brute force... use Convert() against an uppercase version of your field and strip all non-numeric values: Convert(" ABCD","",upcase(YourField)) Shorter list than reality 'cuz I'm lazy. :wink: I seem to recall someone posting a very clever and automagic way t...

If the 'After job' section where you are running this from is the Sequence job itself then you don't need to attach to it, use DSJ.ME for the handle to mean the current job. And don't forget all of the other child stuff - wait for job, check status, detach.

OK. How exactly are you running the job after job? Script, routine, something else? Do you really need to pass anything, i.e. can it not just default in the child job? Pardon my ignorance as I don't have any parameter set experience to speak of, can you please detail what exactly it is you need to p...

I haven't done anything like this, but you're looking to target multiple 15 minute time blocks per clock record, yes?

This has been asked and answered many times. Please do an Exact search on "error while loading shared libraries" to find those discussions.

Sorry that I'm not going to answer your question but instead ask another. Why would you not simply have the Sequence job run both jobs rather than running a job 'after job'? [shudder] If it's because the child needs information from the parent, that could be landed, picked up by the Sequence and pas...

NO. That's too late as the job has already started. You need a Sequence job to gather the values and then pass them in to the Job Activity stage to run the job.

If this is truly a Server job question as marked rather than a TX question per the forum of choice, then you've posted in the wrong forum and you need to repost it over in the actual Server forum.