DSXchange

The number of records don't matter... do you know the maximum number of columns you'll have?

Horizontal pivot followed by Aggregation.

We start by not hijacking someone else's post, so I've split your question out into one that you now own and can control. Note that I had to guess your version and O/S, correct those if they are wrong. Can you post more details for your issue? What you are attempting to load, the ctl file it is gene...

I would put my money on "indexes corrupted".

Tell us what you tried and what the abort was, then maybe people can help.

Tell us what "did not work" about it as it certainly should have as that's exactly what it is for.

You should be fine.

I shouldn't have let the original hijack go on as long as it did. Split now, welcome to your own post on the subject.

Did you get this working? It has been bugging me, I finally got a chance to dig thru the 8.5 docs and see how it was explained. Turns out... poorly. For an Output (reading) link: First Line is Column Names Specifies that the first line of the file contains column names. This property is false by def...

No clue. Have you run this by your Teradata DBA? Official support provider?

The 8.0.x release was notoriously buggy, have you checked to see if there are any fixpacks available for this?

Ray made the suggestion based on the error you posted. At this point, I would imagine you are firmly in the hands of your official support provider.

My assumption was that this update_date_time column was a "SYSDATE" style column since they asked what timestamp they would receive but still... regardless of how it is derived Transaction Size has no affect on it.

Simplest way to find out stuff like this is to try the function. Build a 'test harness' routine that just calls the routine and passes back the output, then 'Test' it in the Manager passing in various values. As to your questions: Arg2 states "Hash Key Value", so no not the column name but...

That makes some sense, sorry I feel like I should have suggested that.