| urgent [message #21172] |
Wed, 17 July 2002 02:15  |
sha
Messages: 84
Registered: July 2002
|
Member |
|
|
Hi,
If I am using the code below it is working but if my data is in a separate text file then how should I call the file in the code below so that when I used sqlloader
abc.ctl file name is and the code is below for this filename.
LOAD DATA
INFILE *
INTO TABLE load_user_delimited FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(data1, data2, username "USER")
BEGINDATA
( 1111,aaaaa
2222,bbbb) instead of using this data here I will put this data in a text file and I have to call the file here.
thanx
/
|
|
|
|
|
|
| Re: urgent [message #21177 is a reply to message #21174] |
Wed, 17 July 2002 04:09  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
Remove begin data .... your code should be only this
LOAD DATA
INFILE 'a.txt'
INTO TABLE load_user_delimited FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(data1, data2, username "USER")
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
