Unable to insert the data to DB

[Shravya Devadiga]

Hi Team,

I need to know how to read the file and insert the data from file to the DB.

I have tried to store the data in static and then insert to the DB, which didnot work.

Please help me with the script.

File Condition:

Reserver_Clearance_499.csv

Query:

insert into reserver_clearance (CARRIER,CARRIER_SERVICE,COMPANY,ERP_ORDER,INTERNAL_SHIPMENT_NUM,ITEM,ITEM_COLOR,

ITEM_DEPARTMENT,ITEM_DESC,ORDER_DATE,ORDER_TYPE,ORIGINAL_ITEM_ORDERED,REQUESTED_QTY,SHIPMENT_ID,SHIP_TO,

WAREHOUSE,USER_STAMP,DATE_TIME_STAMP,CREATEDBY,CREATEDON)

values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Regards,

Shravya

[Markus Embacher]

Hi Shravya,

with the given information it is impossible to suggest a solution. Which platform are you on? Which database are you going to use? How much data are you expecting in the csv?

In general it is recommended using database native tools to insert the data (like sqlldr for Oracle). Those tools are very performant when it comes to large amount of data. It is definitely not recommended to load the data into a static VARA first.

Regards, Markus