ca.portal.admin

Changing binary zeroes to comp-3 on database record

Discussion created by ca.portal.admin on Feb 9, 2005
Latest reply on Feb 10, 2005 by ca.portal.admin
For reasons I have not yet been able to ascertain, we have database
records with binary zeroes in an element defined as s9(11) comp-3. The
element was added several months ago using restructure and was
initialized correctly at that time. Records stored since then have
binary zero while older records have packed zeroes. I suspect the
records were added using a batch program and an old subschema (without
this element in the record) so the element wasn't initialized correctly
before the store. I will be quizzing the developer for more details
tomorrow. Meanwhile, I am hopeful that this esteemed body can offer
suggestions for changing the value from binary to packed.

Any ideas?

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Changing binary zeroes to comp-3 on database record
"The best approach is probably to create an exit for the restructure
utility.
This exit can check the value, if it contains binary zeroes it changes it
to packed zero, otherwise leave it alone. Of course if none of the records
contain anything but zeroes you can just change everything to packed zero
without the exit.

You could use a Cobol batch program and check for non-numeric value, but
time constraints may prevent that from being an ideal solution.

Tommy Petersen
110 Cokesbury Rd
Room 542H
Lebanon, NJ 08833

Phone:
Internal 200 - 3699
External (908) 236-3699
Fax: (908) 236-3692




Roger Lawrence
<RLawrence@SEMINOLE-EL To: IDMS-L@LISTSERV.IUASSN.COM
ECTRIC.COM> cc:
Sent by: IDMS Public Subject: Changing binary zeroes to comp-3 on database record
Discussion Forum
<IDMS-L@LISTSERV.IUASS
N.COM>


02/09/2005 06:12 PM
Please respond to IDMS
Public Discussion
Forum





For reasons I have not yet been able to ascertain, we have database
records with binary zeroes in an element defined as s9(11) comp-3. The
element was added several months ago using restructure and was
initialized correctly at that time. Records stored since then have
binary zero while older records have packed zeroes. I suspect the
records were added using a batch program and an old subschema (without
this element in the record) so the element wasn't initialized correctly
before the store. I will be quizzing the developer for more details
tomorrow. Meanwhile, I am hopeful that this esteemed body can offer
suggestions for changing the value from binary to packed.

Any ideas?

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Changing binary zeroes to comp-3 on database record
"If the field really contains only zeroes, so there is no need to save
individual data, you can use the restructure utility to initialize the
field to packed zeroes in every record.

Outcomes