Re: SQL Loader - How to load userid without hardcoding

From: Quek Keng Cheng/CC/SP_SF <QuekKC_at_SP.AC.SG>
Date: Fri, 1 Mar 1996 08:56:09 WAT
Message-Id: <9603010114.AA13637@alice.jcc.com>

ChorLing,

try this :

LOAD DATA INTO TABLE TABLE1
when field1 != ' '
( USERID "USER",
 TABLECOUNTER SEQUENCE(MAX,1),
 FIELD1 POSITION(01:12) CHAR) Enter 12 spaces between 2 quotes.

Keng Cheng
QuekKC_at_sp.ac.sg

>Hi Tony & Tim !

>Thanks 4 your replies regarding the above qn.

>Solution fr Tony :
>> LOAD DATA INTO TABLE TABLE1
>> ( USERID "USER",
>> TABLECOUNTER SEQUENCE(MAX,1),
>> FIELD1 POSITION(01:12) CHAR)
It works. HURRAY ! :-)

However, even empty lines from the data file will be loaded.

Eg.

LINE 1 => 123456789012
LINE 2 =>
LINE 3 => End Of File

In the table, there will be 2 rows =>

USERNAME , 1, 123456789012
USERNAME , 2, Does anyone have a way to prevent empty rows from loading into table ?

TIA ChorLing
chancl_at_nievax.nie.ac.sg

PS: More details

My table Table1 contains field :

1) userid varchar2(30)
2) Tablecounter number(4)
2) Field1 varchar2(12)

My data file contains only Field1 data from 1 to 12 position eg 123456789012
222222222222

My ctrl file,
LOAD DATA INTO TABLE TABLE1
( USERID "USER",
 TABLECOUNTER SEQUENCE(MAX,1),
 FIELD1 POSITION(01:12) CHAR) Received on Thu Feb 29 1996 - 20:14:25 CST