sqlloader

From: james <james_at_perigee.net>
Date: 1997/08/28
Message-ID: <01bcb34f$7fde61c0$733ceecf@oemcomputer>#1/1

Does anyone know how to test a fiels in sqlload without it being a column in the database?

ie:

table is as follows.

create table test (

	num	number(7,0),
	sign	char(1)

);

input file has 2 fields, a number and a sign.

100-
200+

sqlload script is as follows:

LOAD DATA
INFILE '..\data\call_details.dat'
REPLACE
INTO TABLE call_details
TRAILING NULLCOLS
(

        sign                      POSITION(4:4) char,
        decode(sign, '-', (num * -1), num) POSITION(1:3) INTEGER EXTERNAL

)

If I remove the sign column I can no longer perform this test. I need to get rid of it somehow. Received on Thu Aug 28 1997 - 00:00:00 CDT