How to treat NULLs in EBCDIC fields
Posted: Thu Oct 19, 2006 5:16 pm
Hi,
The copy book I have for an EBCDIC file lists a field as being PIC XX. If the database contains a NULL in this field, when the extract occurs does the field contain two characters or one?
Do I need to Convert NULLs with their own filter as part of an EBCDIC conversion? If so, how do you know how many characters to replace the NULL with for a fixed length field?
Many thanks,
Ian P.
The copy book I have for an EBCDIC file lists a field as being PIC XX. If the database contains a NULL in this field, when the extract occurs does the field contain two characters or one?
Do I need to Convert NULLs with their own filter as part of an EBCDIC conversion? If so, how do you know how many characters to replace the NULL with for a fixed length field?
Many thanks,
Ian P.