Native SQL - How to set the schema and database names

Answer 1

There's no abap statement to do this. The only possibility I can think of is to use your database provider's command to set the default schema. For example, if you're using DB2 you could try something like:

EXEC SQL.
SET SCHEMA SCHEMANAME
END EXEC.