Skip to Content

How to insert a row in SAP HANA using SQL openrowset

May 12 at 06:33 AM


avatar image
Former Member

hi i am getting error with the insert statement .I am trying to insert a row to table in SAP HANA using SQL procedure openrowset.Kindly help me on that please.

insert OPENROWSET( 'MSDASQL', 'Driver=HDBODBC;;UID=***;PWD=****;CS=BODS_CSW;', 'select "SalesOffice" as "SalesOffice" ,"TechID" as TechID,"TechName" as TechName,"PersonelNumber" as PersonelNumber ,"ActionBeginDate" as ActionBeginDate, "ActionEndDate" as ActionEndDate from "BODS_CSW" ."BSNA_iPerform_Tech_Mapping" where 1=0 ' ) values( 'xt','test','xx','14','2017-01-01 00:00:00.0000000','2030-01-01 00:00:00.000')

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers