Archives of the TeradataForum
Message Posted: Tue, 03 Feb 2004 @ 20:32:27 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|