Re: Cobol like Comp in Oracle

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 23 Dec 2002 14:36:33 -0800
Message-ID: <3E078FF1.C87691C3@exesolutions.com>

Karsten Farrell wrote:

> An "s9(4) comp" is a signed integer of 4 digits (comp = computational, not
> compressed).
>
> "Adam Hapworth" <hap_at_mikomi.org> wrote in message
> news:a6cb04db.0212230534.4584e724_at_posting.google.com...
> > I am working on a conversion of some Cobol transaction formats where
> > the receiver is looking for a string which normally comes from Cobol
> > as an "s9(4) comp". from what I have gathered this compresses the
> > data in half. I am trying to replicate this using PL/SQL. Is there a
> > procedure of some kind that will allow me to compress an Oracle Number
> > or Char to half its size and then place it into a string.
> >
> > Adam

But in answer to your question ... no. And I can't imagine any situation in which compression would be either necessary or desirable.

Dan Morgan Received on Mon Dec 23 2002 - 16:36:33 CST