Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to check whether HANA(Secondary database) schema having table name from ECC

Former Member

‎04-04-2015 6:49 AM

0 Kudos

Hi,

I am working on a scenario,Fetching data from HANA database(Secondary Database) Using ADBC query with Connection name.I am checking ADBC_TEST_CONNECTION ,if it is successfully opened then fetching data from HANA otherwise from Primary database.

Query:Some times Schema is active but table is not exist in schema,It is giving dump.How to check the table availability in HANA schema  from ECC?

1 REPLY 1

amol_samte
Contributor

‎04-04-2015 1:09 PM

0 Kudos

Hi Ramesh,

Have you checked in CX_SQL_EXCEPTION, you will get message like that if table is not available

invalid table name:  Could not find table/view "TABLE NAME"  in schema ECC: line 1 col 51 (at pos 50).

-Amol Samte