-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Moin,
We did this: save a Database to DATASAVE using dbmcli.
Resored this Database like this, using dbmcli:
db_cold
util_connect $DBM
recover_start restore DATA
util_connect $DBM
util_execute clear log
db_restart
util_connect $DBM
backup_save data MIGRATION
backup_save initial MIGRATION
autosave_on
- ---------------------------------------------
After that action, we can not execute SQL commands like this:
INSERT INTO RESOURCES (RESOURCE_TYPE_ID, TITLE, DESCRIPTION, TEACHER_ONLY)
VALUES (1,'fdsfdfsfs','sdfsdf',0)
//
This refuses to work, whith error code -8 Pos[1] = General Error, Parse
Again, used from SQL Studio 7.3.00.1.
After using this commads (from repmcli -b file)
//
drop table resources
//
//* ============================================================ */
//* Table: resources */
//* ============================================================ */
create table resources
(
resource_id fixed not null default SERIAL,
module_id fixed,
resource_type_id fixed,
special_id smallint,
title char(255),
description char(255),
keywords char(255),
filename char(255),
xlength float,
url char(255),
thumbnail char(64),
start_nc_level smallint,
end_nc_level smallint,
teacher_only smallint,
date_ins timestamp default TIMESTAMP,
date_upd timestamp default TIMESTAMP,
date_del timestamp default NULL,
deld fixed default 0,
admin_id fixed,
primary key(resource_id)
)
//
INSERT INTO RESOURCES (RESOURCE_TYPE_ID, TITLE, DESCRIPTION, TEACHER_ONLY)
VALUES (1,'fdsfdfsfs','sdfsdf',0)
//
All of that worked fine and This works also from SQL-Studio.
How can we fix this awful behavior ?
Any idea what's going wrong here ?
mfG
Jojo
- --
J�rgen Sauer AutomatiX GmbH, http://www.automatix.de
c/o Pearson Broadland, 80 The Strand, London WC2R ORL
Mobile Tel: +49-(0)174-921 6893
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iEYEARECAAYFAjx85I0ACgkQW7UKI9EqarGgqgCfYQDlZOO9297TIwnSz55Hc6XC
FUcAnRK5oVBXdiwJvdQYa4Nm4h6OUWaR
=+q2I
-----END PGP SIGNATURE-----
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
