Create table with sqlstudio

[Former Member]

Hi all,

I try to use a created tabel in my webdynpro, but when I run my application I the following error: contains the semantics error[s]: table "BE_DEPARTMENT" unknown. When I create the table by using NWDS then I the error is solved.

In sqlstudio I used CREATE TABLE. What must I do after this statement so that I can use the created table in my NWDS

I use a JDBC connection in my Webdynpro

Regards,

Richard

[Former Member]

Please have a look at these

/people/kathirvel.balakrishnan2/blog/2005/04/16/how-to-manipulate-a-maxdb-database-using-jdbc--part-1

/people/kathirvel.balakrishnan2/blog/2005/04/22/how-to-manipulate-a-maxdb-database-using-jdbc--part-2

https://pwdf1209.dmzwdf.sap.corp/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/... to create tables in maxdb using sql studio.pdf

Cheers

Kathir

[Former Member]

Hi Richard,

did you remember to commit the create statement? Is auto-commit turned on in SQL studio?

Thanks,

Ashwath