Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 20:32:27 GMT

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

<-- Anonymously Posted: Tuesday, February 03, 2004 15:30 -->

Using MVS, a FASTEXPORT will populate spaces into the output file for a null char value. Sometimes, though, space and null are both valid values for a field. I need to distinguish between what was NULL and what was truly blanks.

Documentation says that MODE INDICATOR is one way to communicate this information. However, I am having trouble finding detailed documentation on how the indicator area is defined. The wording in the FASTEXPORT manual is way too general. My FASTEXPORT file will be used by a COBOL program. So a COBOL example of how to define the area would be absolutely wonderful.

What would be IDEAL is to just be able to have all "NULL" values represented as a certain character in the output file, whether the data was DATE, INTEGER, CHAR, etc., etc. Something similar to the ".set null as '*' " BTEQ command. I've tried to get this command to work in my FASTEXPORT SQL, but can't.

Thanks.

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