How to treat NULLs in EBCDIC fields

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Ian.Plumb
Posts: 1
Joined: Thu Oct 19, 2006 5:11 pm

How to treat NULLs in EBCDIC fields

Postby Ian.Plumb » 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.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Oct 19, 2006 9:52 pm

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).
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 2 guests