> 1) In ADABAS-D I had some scripts for creating the > tables/users. For this I > piped the sql-commands in a program called "xquery" - this > seems to be not > available with SAPDB. How would someone do this with SAPDB? I > saw that "xsql" > is "back" (this tool was available in former ADABAS-D > distributions and we > used this before xquery) but I don't know if "xsql" will > remain in future > SAPDB-verions. So - should I use "dbmcli" instead? Or the new > "loader"? Or > write python.sql/loader scripts?
The official batch tool is the loader. xsql will remain in the distribution for some time, but isn't really dsigned for batch sql. dbmcli shouldn't be used for SQL at all because it uses a special SQL mode. Python scripts would be your choice if you have to to something fancy like elaborated error handling, variable substitution or creating ALTER TABLE statements on the fly. > > 2) I use python a lot for scripting etc. and want to use it > with SAPDB. There > seem to be 2 SAPDB interfaces: sapdb.sql and sapdb.dbapi. What is the > difference between these two interfaces? Which one should I > use? It seems > there is no documentation for sapdb.dbapi? Is there some > tutorial or some > example scripts? sapdb.sql maps more directly to the actual behaviour of SAP DB and is somewhat more efficient (because sapdb.dbapi is implemented as an additional layer). sapdb.dbapi is an implementation of the Python DB API and should be used if database portability is a goal. See http://www.python.org/peps/pep-0249.html for the documentation. Unfortunately, the specification allows important details to be implementation defined, so that it is difficult or impossible (depending on the databases targeted) to write truly portable scripts. It seems as if projects targeting several databases write either their own abstraction layer or use the commercial mxODBC, which can be used with SAP DB as well. > > 3) As I don't use Windows and sometimes prefer a GUI over a > command line tool > I tried to do some some tasks with "webdbm". Basically it > works but when I > try to alter parameters, I cannot press the "OK" button, in > other words, > nothing happens when I press it. Maybe there is some > JavaScript problem? I > use Mozilla 1.3. With Konqueror it seems that webdbm does not > work at all. This is a known bug which will be fixed in the next release. > > 4) When loading data, which tool should I use? The new > "loader"? Or the > replication manager? Use the loader. The name of the tool changed from Replication Manager to Loader between 7.3 and 7.4. > > 5) The Documentation is good, although it is somehow confusing in the > beginning. What I (and probably others) would like to see are > examples, like > example perl/python scripts, sample database setup scripts, > loader scripts > etc. Some kind of tutorial/HOWTO/first steps that proves that > setting up a > SAPDB is not that complicated as it seems in the first place. ;-) That's one of the many things we don't find the time for. Something like that is currently being written. In the meantime, everyone is invited to extend the Wiki (http://sapdb.2scale.net/moin.cgi/FrontPage) Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
