DSXchange

The XML_Parser error will only occur during parsing of data to match the xsd during testing or execution of the stage.

Sounds like it is a mapping issue to me.

Can you share the xsd for this data?

You can use command line parameters or are you looking for something like using a parameter file?

http://www-01.ibm.com/support/docview.w ... wg21578165

Paul, The Oracle data type is "NUMBER" The DataStage column definition is NUMERIC[32] The table is not partitioned in this environment(dev), it is partitioned in PROD. The plan is for the SQL to have a WHERE that limits it to a single partition at a time when run in PROD. The challenge on ...

The Oracle Connector works when set for sequential read. Changed the stage to parallel, Partitioned reads:Yes, Partition reads method: Modulus, Table name: schema.table alias, column name: Number_key I get the following: Oracle_Connector_0,3: The OCI function OCIStmtExecute returned status -1. Error...

When processing several million line items I hit a limit also. Eventually found a set of optional java arguments that worked. The final configuration for the hierarchical stage was: Usage/Java/Heap Size (MB): 1024 Usage/Java/Stack Size (KB): 2048 Usage/Java/Optional Arguments: -Xjit:dontInline={com/...

You're welcome! Use it in good health.

To achieve independent documents for XML from the Composer step, we use a Regroup step prior to the Composer step in the assembly. The Regroup does a great job of separating the XML into appropriate levels/files. I would like to use the waves through the first 95% of the job and then do the last 5% ...

We took a perfectly fine working job that uses hierarchical stage to parse transactions. We broke it by adding a Wave Generator stage in an attempt to get the Hierarchical stage to parse a single file at a time rather than an entire batch of 5000 files. Our favorite error is currently: Xfm_EOM_Group...

I would recommend getting all of the data columns assembled before the Hierarchical stage.

In the Hierarchical stage Assembly Editor try a Regroup step to cause the incoming rows to be broken into desired XML elements in a following Composer step.

THANKS!

Got everything to show up correctly!

Hello, I am a co-worker with Jennifer. What is the syntax for a "search on DS.TOOLS"? The LIST.INDEX DS_METADATA ALL" returns information on four indexes: ACCESSTYPE ACCESSCAT PLATFORMTYPE CATEGORY I am guessing that the CATEGORY one is the one that needs to be rebuilt. Is there a way...