DSXchange

As far as I know, it would be a bug that you'll need to deal with. It does all the grunt work to get the columns in and then you'll need to go through the imported metadata and correct the field sizes. The OCI stages used to do something similar... what a pain, but better than banging everything in ...

Just. Lock. It. Is there a dang FAQ 'discussion' anywhere in there? Or perhaps move them down near the bottom as balajisr notes. Then put a new forum at the top called something like The Questions You Can't Bother to Put in the Right Place Forum. Much like a staging table, no actual work would be do...

To change it back, only either the current owner can 'chown' it to someone else or someone with root access can do it. In other words, you can give something away but not steal it... unless you are Super User, that is.

Yup, exactly. And rather than use the 'SQL Builder tool' to create your source queries, I much prefer the 'Generate SELECT clause from column list; enter other clauses' way of doing things. I wouldn't touch the Builder with a thirty-nine and a half foot pole. That long 'Generate' option is what used...

A couple of suggestions: remove the outer parens wrapping the entire sql and remove the trailing semi-colon. Neither are needed and may be confusing things.

It must be something with how you wrote your sql. Post it.

No, RTI jobs do something unique as best as I can tell. No actual log entries are removed, no 'purge' settings are lost, all that happens when you stop a 'forever running' job is the various invocation id specific 'logs' shown in the Director are cleared. As noted, we can do the same thing by recomp...

I too was wondering how this was possible without losing everything, including the "parent" job log. It must be possible, however, as RTI jobs do this. They run as multi-instance jobs and when you stop one via the console, all multi-instance log entries in Director just... go away. Without loss of l...

See? Just lock the darn forum.

Those have been there for... years.

Make sure you upgrade to the latest version of "7.5" and not just literally 7.5 (which is available as far as I know). Latest should be 7.5.2. There should be quite a list of "Changes in this Release" that come with the media... why not just order it and see for yourself? As long as they are under m...

If the stage is anything like the Server equivalent, it will tell you that when you attempt to leave the field blank.

FMT - the 'Format' function.

Ah, Ray's latest crusade.

Probably just an unfortunate choice of an example by Arnd. Usually people want to use job parameters in the where clause, so something along those lines may have been more appropriate.

If it's not a join, then I don't see how Ray's advice applies. So we're left with concatenation which is what your title states and you seem to say you are doing. Typical answer then would be to do the concatenation in UNIX as you certainly don't need a job to stick two files together. If you 'need...