Re: Data conversion
Date: 1995/07/06
Message-ID: <lfeges.27.2FFC10C2_at_hookup.net>#1/1
In article <3tcmj2$hfb_at_newsbf02.news.aol.com> melendez_at_aol.com (Melendez) writes:
>From: melendez_at_aol.com (Melendez)
>Subject: Data conversion
>Date: 4 Jul 1995 20:32:34 -0400
>Trying to load data file (using SQL*Loader) which originates at IBM frame
>(model unknown) into Oracle. Conversion to ASCII, which is done before
>transfer, improperly converts signed decimal field - characters and braces
>'{ or }' appear at the end of the number.
>The error in the loader log file complains about the improper numerics and
>I'm looking for suggestions toward a resolution. If possible, please mail
>me on site: melendez_at_nosc.mil . . . TIA.
>Angelo Melendez
Just a guess, the IBM numeric fields are in EBCDIC with an 'overpunch' on the last character indicating the 'sign' of the number. The simplest solution is to ensure that the IBM/EBCDIC numbers are in 'display numeric' format where the sign is a character by itself and not part of the last digit. This is a holdover from the 'tight-for-space-lets-compress' days beginning some 40 years ago. Ah.... the good-old-days!
\louis Received on Thu Jul 06 1995 - 00:00:00 CEST