Danny, Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote: > > Hi folks > > > But repmcli said after executing command.sql "successfull" , > so I guess, the > data is insertet.. > in some way ... > > Ok, after that I want to insert the timestamp data in the > table, existing in the work-database. > And I know no differences between the work and the test > database (only, that there are diffent tables..) > > with repmcli I want to execute the FASTLOAD Statement in the > command file . > But now, the message comes : "not allowed" > Why, I asked the mailing list, today, and one said me, I > should make first a > backup from the work-database. With the Database Manager I > made a backup, > then executed the command file again, but same error-message comes. > So on the test-database, it runs again and again (only the > insert of data, > not the select of it ) , but not on the work - database .. > It would really be helpful to see what exactly you're doing and what exactly error message shows up in the log file. We can hardly help if the only information is "not allowed". I haven't seen an error message like this.
> 1. Question : What might be the reason for this (test > database = writeable , work database = read only)? > Are you able to insert into other tables in your work database? How did you build the work db? TABLELOAD? TABLELOAD brings the tables loaded into 'Read only', too. > After that I tried to insert a easy date value . So I changed > the colum type > to "date" . (test-database) > > With repmcli it worked fine, so then I want to have a look on > that table. > Sql-Studio : simple "select * from table" --> "Datetime field > overflow" > form dialog --> show the date in ISO Format > dbmcli : "table not found" > xsql : shows wildcards instead of date-value > > > Then I want to insert the date-value with xsql (and > sql-file), but there > comes the message "table read only". > So this only work with the repmcli . > > 2. Question : Why only the form dialog (sql studio) shows the > right date > value ? > 3. Question : Why the table is 'read only' with xsql, but not > with repmcli ? > If a table is FASTLOADed it is in state 'Read only' for all other tools except RepMan. That's to make additional FASTLOAD possible. Regards, Steffen _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
