JAVA.SQL.SQLWARNING WHEN IMPORTING SCHEMA

[eonsase]

Hi Team,

I am importing database schema using the SAP recommeded SAP Import schema query "IMPORT "SCHEMA_NAME"."*" AS BINARY FROM 'import_path' WITH IGNORE EXISTING THREADS 10" but when it imports sucessfully I get sql warning "java.sql.SQLWarning: general warning: Variables with the same name as a parameter are not allowed in main block: CURRENCY". What could cause for ti to output the warning. We are on SAP HANA database version 2 SPS 05.

[dvankempen]

Hi Ernest,

IMPORT is a SQL statement. The warning is most likely returned by the JDBC driver for the SAP HANA client (i.e. SAP HANA studio as Eclipse plugin). Have you tried to execute the statement using HDBSQL (or a Node.js client like SAP HANA database explorer)?

Although still supported for SPS 05, note that development stopped for SAP HANA studio with the SAP HANA 1.0 SPS 12 release in 2016. The tool has been deprecated since the SPS 02 release (2018). There could be a mismatch between the client and the SQL.