DSXchange

Only by writing your own email handling routine, for some silly reason the stage doesn't support this functionality.

In that case you can look at the dsapi.h file that lives in the 'include' directory under wherever your 'Engine' is installed.

Well... those 'Referencing' options can be turned off in the Manager. And it does tend to speed up compiling just a wee bit when 'Warn if compiling referenced routine' is unchecked.

No need to spam multiple threads with this same question. What error do you get? What database are you working with? You've said previously that with the transaction size the same on both links it "runs fine". Are you sure you know under exactly what situations you have problems? Let's start with th...

As Roy notes, I don't see any value in aborting the job just because it has no data to process. If it's important to recognize that situation, do so pre- or post-job. Have something check your input source and branch around the job if it is empty is one option, or check post-job for a processed row ...

If your goal is to have your updates tied together such that an error in one will rollback changes in all, then you must architect a single job solution. And yes, there are known issues with jobs being stopped or aborted leaving their database processes running - and not just with DB2. I see this in...

I'm sorry, but if your UNIX admin doesn't understand what those two redirects are doing - you may need a new admin.

Suggest you take a peek at the dsr_sched.sh script it mentions, that should shed some light on what's going on.

I think you'll find that Ray's answer is based strictly on the OP's question regarding using a sequential file stage as a source in a job. The game plays out differently (as you noted) when using one as a target.

Thanks. Luckily, not really worried about performance as we're only dealing with small sets of data at any one time. For what it's worth, it does seem to be working fine when setting a data field up in the hashed file as a very large LongVarchar and putting up to 16 to 20K worth of "raw text" into t...

Because it's too late then. It must be done as part of the process that runs the job, not by the job itself.

I'll take "Search the Forum" for $100, Alex.

kcbland wrote:Still looking for that CLOB solution?

Umm... perhaps.

I think it's more related to troubleshooting the CLOB issue than using it as part of the solution. I think.

Still curious what the limit is, other than that 2GB limit we all know and love.

I've been asked this question and I can't see to find it mentioned anywhere that I can find...

Anyone know the phyical (or practical) size limit on a single (non-key) column in a hashed file?

Ok, spoke too soon. It's not "working working", it is however longer failing. The CLOB is being silently truncated to 4K as it makes it way through the job and not really sure why right now. We'll keep messing with this and I'll update the post with anything pertinent we discover. Of course, any tho...

Add more disk space?