Hi all again
I searched out, that my problem (i couldn't fill a table with timestamp)
might have another case.
I have a test database on SAPDB 7.4 in ORACLE mode
with sql-studio7.4 I created the table
CREATE TABLE fasttest
(
type_key VARCHAR2(30) NOT NULL,
attribute_key VARCHAR2(30) NOT NULL,
mod_stamp DATE NULL,
mod_flag CHAR(1) NULL,
mod_user VARCHAR2(20) NULL
)
the colum "mod_stamp" has the type timestamp after creating.
To fill the table I use the repmcli tool on linux, with the fastload option.
thats my command-file :
FASTLOAD table fasttest
type_key 1
attribute_key 2
mod_stamp 3
mod_flag 4
mod_user 5
INFILE '/home/sapdb/input.sql'
SEPARATOR ','
DELIMITER ''
the input.sql has the values of two rows :
Cover,HEIGHT,200104121723326000,I,user06
Cover,HEIGHT_UNIT,2001041217094504000,I,user06
as you can see, it's the internal sapdb timestamp format. No ISO or Oracle
format, and it works !
But after I have filled in the data successfully, i CAN'T read the
timestamp-values with sql-studio, xsql oder dbmcli !
there a message comes "Datetime field overflow"
That must be a problem of timestamp-values itselfes, because, when I have a
colum-type "date" insteat of "timestamp", and have a value 20010412 in my
input-file, there are no problems to show them in sql-studio... (i have tested
it ! )
So my first question : How can I make that values visible ?
The other point is, that I have another database, in which I want do the
same thing. But there i can't fill data in tables, because message comes "table
read only" (sql studio) or "not allowed" (repmcli), though I connected as
admin user.
Second Question : How can I chance the read/write rights on tables ?
--
+++ 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
