Create New Table in the default datasource

[Former Member]

Hello Experts,

When I tried to create a new table using the default datasource ${com.sap.datasource.default} through a EJB Project, I got the following exception:

com.sap.sql.log.OpenSQLException: "CREATE TABLE" statements cannot be executed with Open SQL.

Does it mean that a DDL statement cannot be executed using the default datasource? Isn't there any workaround to create the table using the default datasource without creating a NEW SCHEMA.

Any pointers in this regard will be highly appreciated.

Best regards.

[Former Member]

Hi Balakrishna,

The DDL command statements are not supported in the Open SQL mode used by the default data source.

Following is an excerpt from this page on help.sap.com.

Open SQL supports the following subsets of statements:
·        Queries
·        Data manipulation language

Regards,

Alka.