Hi J�rgen, "Juergen Sauer (by way of Juergen Sauer )" schrieb:
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Moin, > is it possible to load tablecontents from Adabas D "xload tableextract" ? > > Did anybody did this before ? > > TIA ... > mfG > Jojo > > - -- > J�rgen Sauer - AutomatiX GmbH, +49-4209-4699, [EMAIL PROTECTED] ** > ** Das Linux Systemhaus - Service - Support - Server - L�sungen ** > http://www.automatix.de to Mail me: remove: -not-for-spawm- ** > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.6 (GNU/Linux) > Comment: For info see http://www.gnupg.org > > iEYEARECAAYFAjxwrCUACgkQW7UKI9EqarFC0QCguVe0odcdGRGmWaGTFelZtLjC > vqIAoNpx3i7CMslO75borxyWad/3DJ6p > =YBzi > -----END PGP SIGNATURE----- > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general The problem here is the user/groups passwords. I did not find a way to extract the passwords and then load into SAP DB. So that you have to enter each user/groups password by hand (if you have 100 users - shit happens...) *** Has anybody an other solution?!?!? *** For the tables use "DATAEXTRACT FOR DATALOAD" in Adabas. For the import use "DATALOAD TABLE" in SAP DB. I wrote an tool (JAVA), which copies the users/groups via SQL-commands ( see obove). I create a batch file for Adabas to export the tables. I scan all files an prepare them for the import into SAP DB (incl. LONG-columns) Create a batch file for repmcli to import the tables. The grants i copy via SQL-commands. My tool copies only tables, no triggers etc.... With Steffen we needed 1 week to make it work. HTH... Andreas ------------------------------------------ Andreas Ernst Publishing & Software Hauptstra�e 71 65614 Beselich Germany Tel: +49-6484-81789 Fax: +49-6484-81790 ------------------------------------------ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
