Re: IDS to DB2 conversion

"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:bvq942$t6qg3$2@ID-64669.news.uni-berlin.de... > Serge Rielau wrote: > > > Schema evolution is coming. > > That's wonderful. What does it mean, though? DB2 currently does not have the same type of inplace alter support that IDS does. Work is underway to expand the inplace alter support to match what IDS has. However, since DB2 has inplace/online table reorg, I suspect that DB2 schema evolution will be considered a bit more powerful than what IDS offers. > > > DB2 Stinger will also bring an onstat like tool (no it won't be called > > onstat of course) > > db2stat? > > > What is a virtual table interface? > > It is a mechanism that allows you to write an interface for _any_ data > source and access it via IDS as though it was a table. A similar mechanism > exists for creating indexes on such data sources. A bit like federation, > except it allows you to access and index *any* data source, the sort of > thing that could only go into a BLOB. > > > DB2 supports table functions and wrappers. Table functions are read-only > > though. A nickname on a wrapper supports full DML. > > Once again, what does this mean? There is a bit of misleading information in what Serge said about the this being read-only. Relational data sources are not restricted to read-only. The wrapper is a combination of what IDS gateways provide plus VTI. The wrapper support includes support for IDS, Oracle, Sybase, any ODBC interface (i.e. MSSQL, teradata, etc.) There are additional wrappers for things like XML, Excell, text files, documents, etc. The wrappers are fairly easy to develop and can be deployed by users. > > -- > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche