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 -> Cobol like Comp in Oracle

Cobol like Comp in Oracle

From: Adam Hapworth <hap_at_mikomi.org>
Date: 23 Dec 2002 05:34:24 -0800
Message-ID: <a6cb04db.0212230534.4584e724@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 - 07:34:24 CST












Original text of this message













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