| control file options [message #153041] |
Wed, 28 December 2005 10:26  |
sikyala
Messages: 33
Registered: May 2005
|
Member |
|
|
Here is my control file
LOAD DATA
INFILE 'c:\DACS\dacs_bad.txt'
APPEND
INTO TABLE bib_holdings_interface
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(IAC_REPORT_ID char(20),
CATEGORY char (70),
AD_ID char (4000),
PUBLICATION_DATE char (255),
TITLE char (2000),
ABSTRACT char(4000),
ABSTRACT2 char(4000),
SUBJECTKEYWORDS char (4000),
AUTHOR char (4000),
EXTRA_TEXT_FIELD1 char (4000),
PUBLISHER char (255),
ORG_PERFORMING char (4000),
CONTRACT_GRANT_ID char (255),
SUPPLEMENTARY_NOTES char (4000),
COMMENTS char (255),
EXTRA_TEXT_FIELD2 char (255),
EXTRA_TEXT_FIELD3 char (255),
SITE char "DACS"))
I am trying to assign a value to the last field: SITE char "DACS"
I don't even know if that is an option. Could someone tell me if that is an option and if so what the syntax is for assigning a value during a load? (Note: all other fields have values in the data file)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
