Good morning > 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.
Ok, sorry for my fractional information. the whole Errormessage was "Error during execution -->SQL error -7050 = Fastload with indexed table not allowed (error position: 1)" > > > 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. > I'm not able to write data to the other tables (work database), there comes the same error I have build the work db with Database-manager, the tables created with sql-studio (both 7.4) So, I guess TABLELOAD is a repmcli function ? then, no. I don't used it .. > > > 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. > Ok, thanks, that anwers my 3. question. The 2. Question: maybe the form-diaglog differs from sql-dialog and xsql in interpreting the date-value? But, what I have to do, to display a date-value in a table with "select * from table" from a linux sapdb tool ? Regards Danny > Regards, > Steffen > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ Bitte l�cheln! Fotogalerie online mit GMX ohne eigene Homepage! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
