Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cobol like Comp in Oracle
s9(4) comp(utational) is not compressed (in half?)
in any way.
it's just a 2 byte bit by bit setting until
you reach 32767, -32768
"Adam Hapworth" <hap_at_mikomi.org> wrote in message
news:a6cb04db.0212230534.4584e724_at_posting.google.c
om...
> 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
Received on Fri Dec 27 2002 - 15:28:18 CST
![]() |
![]() |