Archives of the TeradataForum

Message Posted: Wed, 21 Jul 2010 @ 16:45:49 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Guys,

We've just run into a problem with our FastExport approach on one of our Projects whereby we think we need to write (or include) a C Program OutMod program.

Here's the problem ...

We do a FastExport and concatenate the Columns together into one big Varchar field. This is fine but, because the field exported is VARCHAR, we get a binary length field tacked onto the beginning of each line.

This was fine until we found that, depending upon the value of that is contained within the length field, we can get problems once the data hits the file. Sometimes (and many more times than we an accept) the value is interpreted as a Carriage Control Line feed ... effectively we then lose that record.

We certainly don't want to go to fixed width files, so the other thing we can think of is using an OUTMOD C program.

The question is, has anyone already written such an OutMod to remove that width value (which wouldn't surprise me, as this must be a problem encountered elsewhere) ?

Alternatively, is there a simple way of instructing FastExport to NOT put out the binary length field ?

We've never used an OutMod, but we're sufficiently desperate now to have to do it.

Oh, I should mention, we're running on Windows, so I'm told it'd have to be a dll C Program.

Does there have to be a runtime environment deployed to that Windows environment, by the way ?

Any help would therefore be much appreciated.

Regards

David Clough
Database Developer
Database Design Group

	<Prev	Next>		<<First	<Prev	Next>	Last>>