Hello,
I'm using SAPDB 7.4.3.25 on a Redhat 9 box and I'm stumbled into a strange
problem. So I don't know if this is a bug or I did something wrong.
Here is my situation:
My commandfile for loadercli is very simple (I'm using it for test
purposes):
dataextract for dataload table tbl_staffelteil
outfile 'Anfrage2.control'
outfile 'Anfrage2.data'
I'm starting the loadercli through
loadercli -d <mydb> -u pehu,<password> -b <commandfile>.
No errors so far, but if I look in Anfrage2.control I get:
//
CREATE TABLE "TBL_STAFFELTEIL"
(
"LFD_STAFFELNR" Fixed (10,0) NOT NULL DEFAULT
SERIAL (1),
"ANGEFR_VOLUMEN" Integer,
"LFDNR_TEILE" Integer,
"TEILEPREIS_PRO_STCK" Fixed (5,2),
"BEMERKUNG_TEILEPREIS" Varchar (500) ASCII,
"WKZ_KOSTEN_GESAMT" Fixed (10,0),
"EXT_WKZ_KOSTEN" Fixed (10,0),
"BEMERKUNG_WKZ_KOSTEN" Varchar (4000) ASCII,
"ANGEFR_VOLUMEN" Integer NOT NULL,
"LFDNR_TEIL" Integer NOT NULL,
"TEILEPREIS_PRO_STCK" Fixed (5,0),
"BEMERKUNG_TEILEPREIS" Varchar (500) ASCII NOT NULL
DEFAULT '0',
"WKZ_KOSTEN_GESAMT" Fixed (10,2),
"EXT_WKZ_KOSTEN" Fixed (10,2),
"BEMERKUNG_WKZ_KOSTEN" Varchar (4000) ASCII,
PRIMARY KEY ("ANGEFR_VOLUMEN", "LFDNR_TEIL", "BEMERKUNG_TEILEPREIS")
)
<snip>
If I get the SQL-statement for creating the table through SQL-Studio it is:
CREATE TABLE "ALLUSERS"."TBL_STAFFELTEIL"
(
"LFD_STAFFELNR" Fixed (10,0) NOT NULL DEFAULT
SERIAL (1),
"ANGEFR_VOLUMEN" Integer,
"LFDNR_TEILE" Integer,
"TEILEPREIS_PRO_STCK" Fixed (5,2),
"BEMERKUNG_TEILEPREIS" Varchar (500) ASCII,
"WKZ_KOSTEN_GESAMT" Fixed (10,0),
"EXT_WKZ_KOSTEN" Fixed (10,0),
"BEMERKUNG_WKZ_KOSTEN" Varchar (4000) ASCII,
PRIMARY KEY ("LFD_STAFFELNR"),
)
After I found this strange behaviour I looked again and found out that user
pehu (member of usergroup ALLUSERS and <> DBA) has a table called
TBL_STAFFELTEIL and that my DBA-Account has such a table (it's an older
version with a different primary key). So loadercli is going to mix them
together. Since I don't know if this is the desired execution from
loadercli, I can't say it's a bug. But I would prefer, if I have access to 2
tables with identical names and I want to export them through the loader,
that I get an error like 'The tablename <X> is ambiguous. Please use the
complete name' or something like that.
Regards
Peter
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
