Hi all

I have a database TESTDB with a table 'perso' with some filled Colums and
Rows.
To make an select I go to SQL-Studio7.4 or write a sql-file with content:

 "select * from perso"

To execute the file I take this Command:
 
./xsql -d TESTDB -u dbadmin,admin < /home/sapdb/test2.sql

On this two ways I can see the right table content, BUT:

When I take the third way:

dbmcli -d TESTDB -u dbadmin,admin
dbmcli on TESTDB>sql_execute select * from perso

the table 'perso' can't be found! Very strange: with sql_execute I can
create a new table 'perso' with other values.
"sql_execute select * from perso" shows me the new content, now.

When I do this, I leave the dbmcli and type again the command:

./xsql -d TESTDB -u dbadmin,admin < /home/sapdb/test2.sql

Now I see the old, origin content of 'perso'.

So where might be the error??

Danny

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen!

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to