Handling constant values on control file (sqlldr) [message #69224] |
Sun, 25 November 2001 18:37 |
diaz
Messages: 58 Registered: October 2001
|
Member |
|
|
Hi,
I want to have a control file like this :
LOAD DATA
INFILE *
append into table tes02
( id sequence(max,1),
nama POSITION(5:10),
status CONSTANT '1'
)
BEGINDATA
xspundiaz
diazxspun
the table is described like this :
tes02
Name Null? Type
ID NOT NULL NUMBER(2)
NAMA NOT NULL CHAR(10)
STATUS NOT NULL CHAR(1)
i altered the table modifying the status into char(10)
hoping that i can put STATUS CONSTANT 'UNPAID' ..
but it doesn't work..
can you give me hand so that it could work ?
thanks
----------------------------------------------------------------------
|
|
|
|