Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cobol like Comp in Oracle
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
Received on Mon Dec 23 2002 - 09:25:04 CST