Hi folks
Because of my problems with repmcli and commandfiles to insert data
(especially date- , timestamp values) I have testet the other tools with some strange
results .
1. the initial situation :
I have a SAPDB 7.4 and all tools (sql studio, database manger, repmcli, xsql
and dbmcli) in 7.4
I have two databases , a work-database and a test-database. Both run in
ORACLE Mode
In the work-database I have a table with a timestamp colum, and I want to
fill it . (I have already depiced that problem totday morning) .
To fill the data, I must use the Fastload, so I must use the repmcli-tool.
So I have a command-file(command.sql) and an input-file(input.sql) .
in the input.sql stands the timestamp value in internal mode
YYYYMMDDHHMMSSMMMMMM
before I make changes on the work-database i copied the table-definition to
the test-database.
There I can insert the timestamp from input.sql .
After I have inserted the timestamp data in the table in test-database, I
can't make a "select * from table" .
Sql-Studio says : "Datetime field overflow" with sql-statement and with form
dialog
dbmcli says : "table not found"
xsql says : "invalide type: 13"
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 ..
1. Question : What might be the reason for this (test database = writeable ,
work database = read only)?
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 ?
regards
Danny
--
+++ 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
