| Sql Loader [message #619667] |
Thu, 24 July 2014 05:01  |
 |
vatsav
Messages: 2
Registered: July 2014
|
Junior Member |
|
|
Hi
Im trying to use the sql loader functionality to load the data from a flat file separated by '|' delimiter.
Im struck with a scenario where i have the data which looks like the below
1234|a1|a2|a3|a.xml,b.xml,c.xml,d.xml|a4|a5|a6
could you please help me out here
|
|
|
|
|
|
|
|
| Re: Sql Loader [message #619675 is a reply to message #619669] |
Thu, 24 July 2014 05:47  |
|
vatsav
Messages: 2
Registered: July 2014
|
Junior Member |
|
|
I have used the below and trying to insert the sample data shown below
OPTIONS (ROWS=64)
LOAD DATA
characterset UTF8
INFILE '/amp/prosurv/sam/data/stats_customer.txt'
PRESERVE BLANKS
INTO TABLE NUPPAL1.STATS_CUSTOMER
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(col1,
Col2,
Col3,
Col4,
Col5,
Col6,
Col7)
Sample data
1234|a1|a2|a3|a.xml,b.xml,c.xml,d.xml|a4|a5|a6
In col5 i have data with a.xml,b.xml,c.xml,d.xml whihc I'm unable to insert in a singlecolumn
[Updated on: Thu, 24 July 2014 05:50] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
