DSXchange

Lots of help out there on this subject, here's one example a quick search turned up. Plenty more out there.

I'm not aware of any "split by size" option. Of course you could BuildOp whatever you like and still call it "in DataStage". Otherwise you would have to do something by row count after you figure out approximately how many records will generally equal 1MB. Using the Folder stage ...

Perhaps, but why not simply do it at the command line?

We used Control-M as well. Mine would query the job and status as a pre-check to ensure that the job both existed and was in a runnable state. There was no compilation done, anything that meant the job would not run would result in a fatal error. And yes, it also built -PARAM name/value pairs on the...

pkll wrote:If I tortured you extremely sorry. As per our conversation I am learning something. Thanks for it.

No worries... and good.

I'll have to ponder the reverse though it is 'just another pivot'... and there's no reason for me to go this alone, other suggestions welcome!

Specifically, this post has his wrapper in it, should give you some ideas.

Pretty much everyone with an Enterprise Scheduler has a wrapper script that does the actual call to dsjob with whatever pre/post checks and activities are appropriate in their environment. Kenneth Bland posted a rather comprehensive one here back in the day, from what I recall.

Adam's Apple?

You need to work with your DBA and inspect the trace file Oracle creates with the details of the problem, the Waiter(s) and the Blocker(s). This can help track down the problem.

Some of the information you may want to get directly from the job itself, rather than the log. And we've just had conversations on this subject (actually there are tons on the site), I'll see if I can link in the most recent one.

So where are you supposed to get the old value for the first change that comes along? Your example output isn't making sense to me as it seems to show values derived from going... both directions... through the list of changes. :? ps. Don't use "BBCode" in your post and then disable that o...

Question for the masses - will the Pivot stage support listing ~100 column names in the fields in question? Or does it not really care how many columns are listed as long as they all fit within that property / string?

No, not really. You can do as you noted from the command line or the equivalent functions exist in the BASIC API, so you could also do it via Job Control.

I'm not aware of any way to "turn them off". I've known people to set up periodic scans of their system for core dumps and automatically purge them.

Can you be more specific about what "this error" is that you get for 5 or 6 products? And also specifically point out the differences in the two examples that are the issue? Not really seeing an issue with the "opening and closing tags" themselves.