Changing from COMP-3 to COMP

Discussion created by ca.portal.admin on Mar 11, 2009
Latest reply on Mar 11, 2009 by ca.portal.admin
I have a schema record with a numeric field defined as PIC 9(07) COMP-3

I want to change the definition of the field to be PIC 9(09) COMP
(BINARY still 4 bytes).

Can I use IDMSRSTC to do this, if so, how.

If not, what are my other options?

Buz Williams
IDMS 3rd-party providers forum


Re: Changing from COMP-3 to COMP
"There is no need to use IDMSRSTC if the data item is remaining the same
length - you can just do an area sweep with an application program to
read the PIC 9(97) COMP-3 field into a work field - them move it back to
the PIC 9(09) COMP field - you will need a redefines of the record
layout to do this.

There is a way of using IDMSRSTC whereby you add in a database procedure
that does this for you - but you end up with the same result (area sweep
with data conversion logic) - except you need to remember to take the
database procedure off after the conversion.

Oh - BTW - make sure you only do this once otherwise, as the IBM manuals
used to say, ""results may be unpredictable"" 8-)

HTH - cheers - Gary

Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original
transmission and its contents. Confidentiality: This e-mail may contain
confidential information which also may be legally privileged. Only the
intended recipient(s) may access, use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are
those of the sender, not Justice Technology Services. Computer Viruses:
It is the recipient's responsibility to check the e-mail and any
attached files for viruses.