DSXchange

If you insist on treating it like a stored procedure, why not make it a stored procedure? Otherwise, study up on how to properly leverage functions, there are lots of examples out there - here as one example.

Doesn't really answer the question, I'm afraid. Can you post your actual, unedited error message?

In your post, "termination character" means what? An extra comma on the end of the loop list or a trailing Field Mark there from the Execute Command?

Hey, there's no "kind of" correct there, Mr Hester. It's just plain old correct correct.

Assuming the problem is creating it, look into the use of the Trigger Column option, value changes there will trigger a switch to a new output filename.

Like you need an excuse.

Windows or UNIX, doesn't really matter, the compiler would function the same way in either environment. I don't know the gory details, but an exact search for object file returned 130 matches, something in there should help answer your question.

No need for a 64bit server, 64BIT hashed files are supported on any platform as the limit is the addressing used internal to the hashed file itself. An exact search here for -64BIT will turn up quite a number of conversations on this topic. Note that your O/S may very well limit files of any kind to...

You're still out of space there. You would need to monitor that while the job runs to see the problem.

Nicely done.

Making an assumption on how the SCD stage works, but do you have an index over the business key in your target it would be using for the lookup existence check / retrieval of the surrogate key needed for any updates?

That's PL/SQL, not a script... and I have no idea what this has to do with your original question. :? Is 'GET_INFORMATION' your stored function? If so, as noted, you would include it in a normal SQL select as if it were a column in a table. If you don't have a need for a table, use DUAL. For example...

Plus you'll notice that the "and" I mentioned was actually " and " - the spaces are there on purpose. Not a trivial task, regardless.

and by the way, while I'll need to use these functions a lot, I tried to get documentation on how they work , but I can't find it. Would you have a link about that ? You should have a BASIC manual amongst all of the pdf documentation delivered with the product, they would be explained there. Or in ...

That's what it does, every word. All I can think of is to do a series of EReplace() calls afterwards, setting ' And ' back to ' and ', etc. Hopefully someone has a better idea.