Native SQL - How to set the schema and database names
- by icelobber
Im using Native SQL from ABAP language. The query to get data is something like this
SELECT COUNT(ROWID)
FROM <SCHEMANAME>.<TABLENAME>;@<DATABASENAME>
INTO :localvariable
I want to somehow set the schemaname and database name as default so that i do not need to use them in the SELECTs later. Then i can only use the table name in the SELECT.
thanks !!