DSXchange

...take a close look at the DTS Stage --- the Distributed Transaction Stage....it takes advantage of MQ's ability to perform the overall unit of work......so that......"if" you have things correctly configured in MQ to support a x-resource (XA) unit of work between MQ and DB2 or MQ and Ora...

ok... my testing has shown that the xml stage, as it is very dependent upon xml schema definitions, relies heavily on nillable="true" to be IN the xsd specification. When that happens, it seems that the setting is respected and the element is removed, except when it has an attribute that i...

That was just a "gut" reaction...glad it did "something"....not exactly sure yet what it tells us though --- this is a fairly complex subject. I had to look again myself at the xml specification, but it turns out that it's valid to have an element be "null" and still ca...

Yes....it fully supports parallel Jobs.

Do some searching around the forum...there are lots of threads on the use of the WS Transformer. It works in all job types, but it also has requirements for style of input and output payloads and the complexity (or not) of the WSDL that you import.

Ernie

.....this isjust a guess at the moment, but can you do a test where you ensure that the column mapped to the attribute is also null? (State --- instead of the string "created", have it also be null).... or is it a "constant" in the Output Step?

Ernie

Tell us more context about what you are doing with the hash file, what your job is like (transformations, volume, traffic), etc. That will help with any outline or confirmation or definition type and strategy.

Ernie

"if" you imported your db2 metadata via DataStage Connector Wizard, there is an "option" to generate a formal Connection Object. I don't know if there is any other "automatic" way to create the connection, if you already imported your metadata via other means. Just put ...

Think of each repeating unit as though it was its own relational table....this one being "person+email" ....(maybe has 13 rows), and another might be "person+address" ...(maybe has 5 rows).... Each is an individual set of rows having nothing to do with the other, except having th...

Change your validation setting...it's probably on minimal. That may help find the problem.

Ernie

...probably a throwback to InfoSphere Data Architect and its Naming Model...it seems to have a lot of influence on some of the properties....and like I noted in the other thread -- these features are here for "your creativity"....there are no wrong or right ways....use the ones that best h...

There are many relationships you can establish in Business Glossary....things like related terms, assigned terms, synonyms, deprecated, replaced by, etc. Each of them can be used to provide more meaning to a business concept. There is no "formal" meaning to these --- just know that the too...

At the moment I can't think of a better way to do it, unless "maybe" one of the table conversion dialogs "might" drop it along the way....meaning....change the "locator" to something like "Relational", then use the "Create Shared Table from Table" an...

Is this via the ODBC Connector?

...and when you did db2, does that work thru the Connector, or thru the plugin?

The Connectors are the best way, if they are working for you.

Ernie

if you don't have one, you'll need to create one. One way is to look for "trang". ...or use the old xml Stages. If you don't have an excessive amount of volume, or you don't have an xsd or the detailed requirements (like deep validation) that would demand one, then use xmlInput. That has i...

...import the xsd to a Library (not via xml table definitions).