How to hardcode a column of value in SQL Loader

[boxzzz]

Hi,

I'm trying to load a file using sql loader. Is there a way to create a column where I can hardcode and assign a specific value.

options (rows=500)
load data
infile '/d04/1249.dat'
badfile '/home/cdb_buslink.bad'
into table cdb_buslink
truncate
(bus_link position(74:89) char,
listcode)


is there a syntax on how I can harcode a value for the listcode field?

Thanks

 

[Dagon]

Use the CONSTANT keyword e.g.

LOAD DATA
INFILE *
INTO TABLE users
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(rownumber, user_string constant 'XXX')
BEGINDATA
1,
2,
3,
4