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.
How to treat NULLs in EBCDIC fields
Moderators: DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2230
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Hi Ian,
A PIC XX field will be converted to two output characters.
A binary 0 on EBCDIC input gets converted to binary 0 on ASCII output. Is a NULL binary 0 in your field? (ie hex 00 00).
A PIC XX field will be converted to two output characters.
A binary 0 on EBCDIC input gets converted to binary 0 on ASCII output. Is a NULL binary 0 in your field? (ie hex 00 00).
Regards,
Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads