Skip to Content
1
Feb 14, 2014 at 11:48 AM

recordset and SAP HANA ERROR

763 Views

Hi,

I have a trouble when i execute this query with sapbobscom.recordset (The query is ok on HANA Designer).

What is wrong ? Is Recordset support SEMICOLON ?

The error message is 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near ";": line 4 col

My Test Query

create Local temporary table #Table (
    TRANSPCODE nvarchar(15) ,
    TRANSPNAME nvarchar(100) 
);


INSERT INTO #Table (TRANSPCODE, TRANSPNAME)
SELECT 
    T0."CardCode", 
    T0."CardName"
FROM "SBO_TEST".OCRD T0 
where T0."GroupCode" = 101;


select * from #Table;
drop  table #Table;

Kinds Regards