Yes, it's not very well documented, but SAPDB internaly converts all table names to uppercase. So, instead of 'person', use 'PERSON' However, it's not a great idea to use dbmcli to execute SQL statements... -Andris Spruds
----- Original Message ----- From: "Chengjie Wang" <[EMAIL PROTECTED]> To: "Andris Spruds" <[EMAIL PROTECTED]> Sent: Thursday, March 20, 2003 8:43 PM Subject: RE: how to create a table and display the definition thanks for your quick answer. but it doesn't work for me. my work procedure is : 1):using the dbmcli to connect the demo database "TST" : dbmcli -u dbm,dbm -d TST 2:)issue the command sql_connect dbm,dbm 3:)sql_execute CREATE TABLE person (cn FIEXED(4), firstname CHAR(7)) there is no any problem with the commands above. Then I send the command: sql_execute select * from columns where tablename='person' the reply is "ERR, row not found' Any problem with the procdure? Thanks -----Original Message----- From: Andris Spruds [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 1:09 PM To: Chengjie Wang Subject: Re: how to create a table and display the definition For the first, use your favourite tool to connect to the SAPDB database and execute CREATE TABLE statement. I guess, you must be connected as dba user. As for the second, there is a system view named COLUMNS, simply execute SELECT * FROM COLUMNS WHERE tablename='YOURTABLE' -Andris Spruds ----- Original Message ----- From: Chengjie Wang To: [EMAIL PROTECTED] Sent: Thursday, March 20, 2003 6:58 PM Subject: how to create a table and display the definition A quick question: how to create a table in the demo "TST" database and display the definition? Thanks, Chengjie Wang Software Designer/Developer Kanatek Technologies Inc. <mailto:[EMAIL PROTECTED]> <http://www.kanatek.com/> Office 613.591.1482 ext 456 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
