Nachfolgend finden Sie eine Zusammenfassung aller MDB-Anpassungen, die für Release 9.08 erforderlich sind. Zusätzlich finden Sie hier eine Liste mit Verweisen auf die betreffenden Themen im Forum.
Rochade-Timestamp für EdbCheck
NonTAA-Aufrufe in Modulschnittstelle
EdbCheck für Meldungsgruppen-Nutzung
Um die Durchführung der Anpassungen zu erleichtern, sind diese hier in SQL-Blöcken zusammengefasst. Sie können den gesamten Block als Datei herunterladen, indem Sie auf den Reiter am Anfang des SQL-Blocks klicken.
UPDATE [edbTdef] SET [länge] = 24 WHERE [edbint] = 301 AND [feldname] = 'CHECKDATE'
-- Add value for nontaa INSERT INTO EDBCLTPMAP ([INTERNER_WERT], [EXTERNER_WERT]) VALUES(4, 'NONTAA') -- mark bstntype as not callable by taa UPDATE EDBBSTN SET [AUFRUFBAR] = 0 WHERE EDBINT = 79 OR edbint = 509 OR edbint = 506
---Sicherstellen, dass korrekte Längen für Meldungsgruppenliste angegeben sind (Ums, Appl, Typ): UPDATE [edbTdef] SET [Länge] = 71 WHERE [edbint] = 314 AND [Feldnummer] = 1 UPDATE [edbTdef] SET [Länge] = 6 WHERE [edbint] = 314 AND [Feldnummer] = 2 UPDATE [edbTdef] SET [Länge] = 4 WHERE [edbint] = 314 AND [Feldnummer] = 3
DELETE FROM [edbBstn] WHERE [Name] = 'WGNR' INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TW-WEBST', 'WEBSERVICE-TYP') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TT-EXTN', 'EXTERNER-NAME') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TT-NMRM', 'NAMENSRAUM') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TL-NWDT', 'NUTZT_WEBDATENTYP') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TW-WEBDT', 'WEBDATENTYP-TYP') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TL-BAWDT', 'BASIERT_AUF_WEBDATENTYP') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TL-BAWE', 'BESTEHT_AUS_WEB-ELEMENT') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('TL-BAWA', 'BESTEHT_AUS_WEB-ATTRIBUT') INSERT INTO [edbRmap] ([MapName], [RoName]) VALUES ('DV-WEBDT', 'DV_WEBDATENTYP') INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 0, 'NAME', 1, 0, 32, 1, 1, NULL, NULL, 0, 0, NULL, NULL, 'Name', 1) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 1, 'UMS', 2, 0, 71, 1, 3, 'TT-DEF', 'TT-DEF', 0, 0, NULL, NULL, 'Bezeichnung', 1) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 2, 'APPL', 1, 1, 6, 1, 4, 'TL-GEHZU', 'TL-GEHZU', 1, 0, NULL, NULL, 'Anwendung', 1) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 3, 'STVS', 1, 2, 6, 1, 2, 'TW-STUFE', 'TW-STUFE', 0, 0, NULL, NULL, 'Stufe', 4) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 4, 'IMPL', 3, 0, 0, 4, 9, 'TB-IMPL', 'TB-IMPL', 0, 0, NULL, NULL, 'Implementierung', 0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 5, 'SHORTNAME', 1, 3, 32, 1, 2, 'TW-WEBSK', 'TW-WEBSK', 0, 0, NULL, NULL, 'Kurzname', 5) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 6, 'WEBSERVICETYPE', 4, 0, 10, 1, 2, 'TW-WEBST', 'TW-WEBST', 0, 0, 'WEBSERV', 'WEBSERV', 'Webservice Typ', 0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 7, 'EXTERNALNAME', 5, 0, 256, 1, 3, 'TT-EXTN', 'TT-EXTN', 0, 0, NULL, NULL, 'Externer Name', 0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 8, 'NAMESPACE', 5, 1, 256, 1, 3, 'TT-NMRM', 'TT-NMRM', 0, 0, NULL, NULL, 'Namensraum', 0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (249, 9, 'WEBDATATYPEUSAGE', 6, 0, 32, 1, 4, 'TL-NWDT', 'TL-NWDT', 253, 0, NULL, NULL, 'Nutzt Webdatentyp', 0) UPDATE [edbBstn] SET [Anzahl_Felder] = 10 WHERE [Name] = 'WEBK' UPDATE [edbBstn] SET [Anzahl_Felder] = 10 WHERE [Name] = 'WEBS' UPDATE [edbBstn] SET [Anzahl_Felder] = 10 WHERE [Name] = 'WGSR' DELETE FROM [edbTdef] WHERE [edbInt] = 250 DELETE FROM [edbTdef] WHERE [edbInt] = 252
Der WEBSERVICETYPE Attribut verweist auf eine WEBSERV Mapping-Tabelle, die folgende Einträge haben soll:
| Interner_Wert | Externer_Wert |
|---|---|
| WEBS | KLASSISCH |
| WGSR | GENERISCH |
-- Move ExtName and AltExtName to the parent of Services UPDATE [edbBstn] SET [ExtName] = 'DV-WEBS' WHERE [Name] = 'WEBK' UPDATE [edbBstn] SET [AltExtName] = 'DV-WEBS' WHERE [Name] = 'WEBK' UPDATE [edbBstn] SET [ExtName] = NULL WHERE [Name] = 'WEBS' UPDATE [edbBstn] SET [AltExtName] = NULL WHERE [Name] = 'WEBS' -- Introduction of WGDT (EdbInt 253) fields INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 0, 'NAME', 1, 0, 32, 1, 1, NULL, NULL, 0, 0, NULL, NULL, 'Name', 1) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 1, 'UMS', 2, 0, 71, 1, 3, 'TT-DEF', 'TT-DEF', 0, 0, NULL, NULL, 'Bezeichnung', 1) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 2, 'APPL', 1, 1, 6, 1, 4, 'TL-GEHZU', 'TL-GEHZU', 1, 0, NULL, NULL, 'Anwendung', 1) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 3, 'STVS', 1, 2, 6, 1, 2, 'TW-STUFE', 'TW-STUFE', 0, 0, NULL, NULL, 'Stufe', 4) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 4, 'SHORTNAME', 1, 3, 32, 1, 2, 'TW-WEBSK', 'TW-WEBSK', 0, 0, NULL, NULL, 'Kurzname', 5) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 5, 'WEBDATATYPE', 4, 0, 10, 1, 2, 'TW-WEBDT', 'TW-WEBDT', 0, 0, 'WEBDT', 'WEBDT', 'Webdatentyp Typ', 0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 6, 'EXTERNALNAME', 5, 0, 256, 1, 3, 'TT-EXTN', 'TT-EXTN', 0, 0, NULL, NULL, 'Externer Name', 0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 7, 'NAMESPACE', 5, 1, 256, 1, 3, 'TT-NMRM', 'TT-NMRM', 0, 0, NULL, NULL, 'Namensraum', 0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (253, 8, 'WEBDATATYPEBASE', 6, 0, 32, 1, 4, 'TL-BAWDT', 'TL-BAWDT', 253, 0, NULL, NULL, 'Basiert auf Webdatentyp', 0) UPDATE [edbBstn] SET [Anzahl_Felder] = 9 WHERE [Name] = 'WGTC' UPDATE [edbBstn] SET [Anzahl_Felder] = 9 WHERE [Name] = 'WGTL' UPDATE [edbBstn] SET [Anzahl_Felder] = 9 WHERE [Name] = 'WGTS' UPDATE [edbBstn] SET [Anzahl_Felder] = 9 WHERE [Name] = 'WGDT' UPDATE [edbBstn] SET [ExtName] = 'DV-WEBDT' WHERE [Name] = 'WGDT' UPDATE [edbBstn] SET [AltExtName] = 'DV-WEBDT' WHERE [Name] = 'WGDT' -- Set missing paths UPDATE [edbBstn] SET [Path] = '$R' WHERE [Name] = 'WEBK' UPDATE [edbBstn] SET [Path] = NULL WHERE [Name] = 'WEBS' UPDATE [edbBstn] SET [Path] = '$R' WHERE [Name] = 'WGDT' -- Delete WEBDATATYPEUSAGE field from Services because it is now ist own bstn (see WDTU below) DELETE FROM [edbTdef] WHERE [Feldname] = 'WEBDATATYPEUSAGE' UPDATE [edbBstn] SET [Anzahl_Felder] = 9 WHERE [Name] = 'WEBK' UPDATE [edbBstn] SET [Anzahl_Felder] = 9 WHERE [Name] = 'WEBS' UPDATE [edbBstn] SET [Anzahl_Felder] = 9 WHERE [Name] = 'WGSR' -- Introduction of WDTU (EdbInt 258) INSERT INTO [edbBstn] ([Name],[Bezeichnung],[Suffix],[Präfix],[Zielsystem],[Aufrufbar],[Baustein_Kategorie],[Parent],[EdbInt],[Path],[Version],[Interface_Version],[Header_Record],[Anzahl_Felder],[Table_Mode],[AltPath],[ExtName],[AltExtName],[Sequenz],[Flags],[Picture],[ListBy],[ListFor],[Settings],[Interface_Dialog]) VALUES('WDTU','Webdatatypeusage',NULL,NULL,NULL,0,4,'WGSR',258,NULL,0,0,0,1,4,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (258, 0, 'NAME', 1, 0, 32, 1, 4, 'TL-NWDT', 'TL-NWDT', 253, 0, NULL, NULL, 'Name', 1) -- Introduction of WDTE (EdbInt 259) INSERT INTO [edbBstn] ([Name],[Bezeichnung],[Suffix],[Präfix],[Zielsystem],[Aufrufbar],[Baustein_Kategorie],[Parent],[EdbInt],[Path],[Version],[Interface_Version],[Header_Record],[Anzahl_Felder],[Table_Mode],[AltPath],[ExtName],[AltExtName],[Sequenz],[Flags],[Picture],[ListBy],[ListFor],[Settings],[Interface_Dialog]) VALUES('WDTE','Webdatatypeelement',NULL,NULL,NULL,0,4,'WGDT',259,NULL,0,0,0,1,4,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (259, 0, 'NAME', 1, 0, 32, 1, 4, 'TL-BAWE', 'TL-BAWE', 253, 0, NULL, NULL, 'Name', 0) -- Introduction of WDTA (EdbInt 263) INSERT INTO [edbBstn] ([Name],[Bezeichnung],[Suffix],[Präfix],[Zielsystem],[Aufrufbar],[Baustein_Kategorie],[Parent],[EdbInt],[Path],[Version],[Interface_Version],[Header_Record],[Anzahl_Felder],[Table_Mode],[AltPath],[ExtName],[AltExtName],[Sequenz],[Flags],[Picture],[ListBy],[ListFor],[Settings],[Interface_Dialog]) VALUES('WDTA','Webdatatypeattribute',NULL,NULL,NULL,0,4,'WGDT',263,NULL,0,0,0,1,4,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0) INSERT INTO [edbTdef] ([EdbInt], [Feldnummer], [Feldname], [Cluster], [POSITION], [Länge], [Typ], [Rochadetyp], [ExtName], [AltExtName], [LinkBstn], [Redundant], [ExtMap], [AltExtMap], [Bezeichnung], [Flags]) VALUES (263, 0, 'NAME', 1, 0, 32, 1, 4, 'TL-BAWA', 'TL-BAWA', 253, 0, NULL, NULL, 'Name', 0)