Re: SQL*Loader - negative numbers

From: Aram Meguerian <aram_at_unisys.com.br>
Date: 1997/02/15
Message-ID: <01bc1b18$296cea20$5b03dcc8@psaphos>#1/1

---

> De: smp
> Grupos de notícias: comp.databases.oracle.server
> Assunto: SQL*Loader signed data
> Data: Quinta-feira, 30 de Janeiro de 1997 06:39
>
>
> I'm having to load data from a cobol(VRX) system into a new oracle
 database
> (7.1.3). I've used SQL*Loader before but have never had to load negative
> numbers. I can't find out how to load them! I.ve looked in the Utilities
> manual but can't see anything for character (ie not binary) data. Any
 clues on
> what datatype to use in the .ctl (zoned external? decimal external?)
> TIA
>
>
> Sally Pearce
> Financials DBA(for my sins)
>

      Usually we work around this problem declaring the SQL*Loader    column as CHAR on the control file and applying an sql statement    to that column as in "TO_NUMBER (:load_column, 'format')".

      It is better explained on chapter 5 of Oracle7 Server Utilities    Guide.

      Hope it had helped.

                     Aram Meguerian
                     aram_at_uninet.com.br

-------------------------------------------------------------------
   "There's no such a thing as a free lunch in the Universe."
          Lazarus Long Notebook's, Lazarus Long
		from Time enough for love, by Robert A. Heinlein
-------------------------------------------------------------------

I don't work at Unisys, it is just my Internet Provider, so don't blame it for anything I have just said.

---

Received on Sat Feb 15 1997 - 00:00:00 CST