DSXchange

One trick is to treat it as xml....could be really ugly, but it depends on which tags you are looking for. The tags are far more generic, but of the same structure as a normal xml "chunk". Either that or use a nested set of UV/Basic functions. FIELD and such come to mind, but there are a m...

Looks like you are trying to do a classic pivot? do you want multiple rows --- one for each of the "B's" (each 3 character value to have its own row)?

Ernie

Good points, if one is comfortable with Oracle and can easily get a license. I have also been to many sites who can't spell "DBA" and are doing fine with DB2 as nothing more than a metadata storage space. It may as well be flat files. The model is not changed manually, and there is no &quo...

Ok.. missed that you weren't able to get into the Administrator. I would have hoped that it would just choke on "that" project when trying to put it into the list. Keep us posted.

Ernie

It would be practical to determine if (a) you can still create a "new" project and (b) if you can get into it and use this new project. ...and then forget about the old project that won't delete. Ignore it. Spend your time on building the new jobs that you are working on!

Ernie

...of course, you can still do the deletions of BI metadata inside of Workbench, but not in a bulk fashion... and any Host/Database/Table type information can be deleted using FastTrack or DataStage, assuming you have those elements Information Server installed.

Ernie

Find out where you get your patches. The delete capability is a separate patch of its own.

Ernie

License for DB2 comes with Info Server for its limited use as the repository....it may as well just be a "black box". It's a check box and you are done. Otherwise there are installation instructions, etc. for Oracle and SQL Server... choosing DB2 for this limited purpose would certainly se...

I stay out of the licensing rules because they tend to change, so it's best on that issue to contact your sales person..... however, you are correct that the REST API lets you code your own "zero footprint" solution for accessing Business Glossary for search, query, and even update --- muc...

It's a formal patch that you have to download and then run using updater.jar. It is a significant patch, so it should only be done on your test server first, etc., as you would with any patch. Contact your support provider to find out how to get it.

Ernie

A better statement would have been that in v8, "there may still be some stages" that are not wave aware. Most have been wave aware since 7.x, when RTI was first introduced, but there certainly were some that were missed. Most have been updated by this time.

Ernie

:) No, it uses the formal xalan and xerces xslt processor and parser, respectively. The C++ versions. XML tends to be slow.... what is more problematic for performance is the fact that xslt is used, and for very large documents, it uses a DOM "like" method of reviewing the document, meanin...

(in the first paragraph above, I am implying that you are passing the "name" of the whole single file document via External Source)

Ernie

The External Source is the "safest" way to pass xml downstream when you want "the whole file as a single document". This is because you don't want any stray CRLF's or LF's in the document (which are just "noise" for xml parsers) to impact the retrieval. The sequential f...

I thought it might be blanks or something at one point earlier. Congrats. Those things aren't always easy to find.

Ernie