Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cobol like Comp in Oracle

Re: Cobol like Comp in Oracle

From: Keld Nielsen <nospam_at_nospam.nospam>
Date: Fri, 27 Dec 2002 22:28:18 +0100
Message-ID: <WF3P9.15220$Hl6.1741024@news010.worldonline.dk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US