Symptom
- When you execute a a table function, which uses a date variable whose value is initialized to NULL, from the SQL editor as follows:
--------------------------------------------------------------------
DO BEGIN
DECLARE AS_OF_DATE DATE = NULL;
SELECT *
FROM <table function qualified name>;
END;
-----------------------------------------------------
- This gives an error as follows:
---------------------------------
Could not execute 'DO BEGIN DECLARE AS_OF_DATE DATE = NULL= ...' in 6.157 seconds .
SAP DBTech JDBC: [339]: invalid number: "SAPSUPPORT"."DO": line 7 col 1 (at pos 233), line 2 col 9 (at pos 18), line 3 col 9 (at pos 68), line 5 col 9 (at pos 174): [339] (range 3) invalid number exception: invalid number: search table error: <table function>: line 39................................... line 31 col 5 (at pos 1718): [339] (range 3) invalid number exception: invalid number: [6930] attribute value is not a number (please check lines: 31, 52, 72, 91, 114) (please check lines: 39, 78, 124, 141, 147, 153, 168, 298)
Could not execute 'SELECT * FROM ...'
---------------------------------------------
Read more...
Environment
SAP HANA PLATFORM 1.0
Product
Keywords
NULL date value, empty date , KBA , HAN-DB-SCR , SAP HANA SQL Script , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.