How to use BIGINT literals in SQL Query in SAP Business One for Hana?

[josedvm]

I just wanted to run a query using literal BIGINTS (843529180000 and 843529190000) in SAP Business One  and I got this error:

1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10811 Numeric overflow for parameter/column 'Job de programación back end' (OBSJ) (1) source type BIGINT, target type INT4, value '843529180000'
2). [SAP AG][LIBODBCHDB DLL] Numeric value out of rang

Reproducible using:

SELECT 843529180000 FROM DUMMY;

In DBeaver it works,

Here I read about using suffixes for bigint but it did not work neither, I got syntax errors:

https://help.sap.com/docs/SAP_HANA_PLATFORM/f381aa9c4b99457fb3c6b53a2fd29c02/72955c729448436ab826919... 

Version info: SAP Business One 10.0 version for SAP HANA (10.00.180) FP 2111 (64-bit)