|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
insert csv data in table |
« View previous topic :: View next topic » |
Author |
Message
|
RaviKrG |
Posted: Fri Apr 10, 2009 4:58 pm Post subject: insert csv data in table |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
Hi how can we insert csv data in to a table.
my input message is as
id,name,status,code,description
12,abc,F,1A2,filtered
10,xyz,R,5Rw8F,fixed
----------
----------
thanks |
|
Back to top |
|
 |
elvis_gn |
Posted: Fri Apr 10, 2009 10:12 pm Post subject: |
|
|
 Padawan
Joined: 08 Oct 2004 Posts: 1905 Location: Dubai
|
Hi RaviKrG,
What have you tried ? What was the error ?
Regards. |
|
Back to top |
|
 |
WMBDEV1 |
Posted: Sat Apr 11, 2009 1:36 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009 Posts: 888 Location: UK
|
Insert it as a clob?
Model each field in the DB and insert using SQL?
Basic stuff really |
|
Back to top |
|
 |
|
|
 |
|
Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|