DSXchange

That too.

Sorry, but you've been here long enough to know that "Hi All" is not an acceptable subject for a post. And this looks like, almost word for word, a work assignment given to you and then passed along to us. :? What have you tried so far? What are your thoughts on how to approach this?

Oracle's COALESCE? It doesn't generate anything, it returns the first non-NULL expression in a list of expressions.

This seems like something you should report to your official support provider...

Told yah.

Did you apply the patch?

What does this show?

You can't. You need to look at doing a full outer join between the two sources to determine what lives where.

You need to talk to whomever setup the distribution list and ensure it has an externally accessable email address, sometimes they are just setup as internal groups.

It's a pattern, the UniVerse equivalent of a regular expression. The MATCH operator is fully explained in the UniVerse BASIC pdf. I don't believe in posting entire chunks of manuals here, so suffice it to say it matches any number of any characters followed by one numeric character followed by any n...

First cd to the directory in question, then zip. In other words, zip using a relative path.

Contact support, this may very well be something that should always have aborted and they fixed it in the latest release. And Server jobs don't support message handlers.

Solution would be to not cause the warning/error in the first place.

Hmmm... I don't think either solution posted requires all weeks of data be available. Construct each record with whatever days you have and put zeroes in all of the others.

Then perhaps you have an anti-virus problem or your infrastructure folks are pushing something that interferes with this or removing something from your machines... seen that before.

A 1 minute idle timeout? Sheesh. No, there's no ability to defer the target connection until the source data is ready in any sense.

Look for some kind of a 'keep alive' parameter in the connector, pretty sure I've seen people here mention the fact that at least some of them have this capability.

I would suggest uninstalling and reinstalling your client, but that depends entirely on if this is happening just to you or to everyone?