Skip to Content
avatar image
Former Member

How to insert a row in SAP HANA using SQL openrowset

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')

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers