Re: How to write signed numeric?
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/04/07
Message-ID: <Pine.SUN.3.91.950407084852.26428A-100000_at_seatimes>#1/1
Date: 1995/04/07
Message-ID: <Pine.SUN.3.91.950407084852.26428A-100000_at_seatimes>#1/1
On Thu, 6 Apr 1995, Spencer H Moore wrote:
> mainframe system. Several of the fields are "signed numeric". I believe this
> means that the last byte of the field is an alphanumeric character such as
> "A", "J", "}", etc., depending upon the sign and value.
>
> Does anyone have an algorithm to convert a number to a "signed numeric"
> string in PL/SQL? I searched the FAQ and couldn't find anything (probably
You will have better luck fixing things up on the COBOL side. COBOL allows the use of SIGN IS SEPERATE [LEADING/TRAILING] so that the fields can be signed without having the sign overpunch the last digit [harking back to punched card terminology].
--Steve
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Fri Apr 07 1995 - 00:00:00 CEST