DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 11 matches
Author Message
Resolved
 Topic: XML Hierarchical Stage Produces No Rows
wpkalsow

Replies: 9
Views: 2408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 22, 2018 10:46 am   Subject: XML Hierarchical Stage Produces No Rows
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 da ...
 Topic: Altenate way of parameter passing to a sequence job
wpkalsow

Replies: 5
Views: 797

PostForum: General   Posted: Fri Jun 22, 2018 10:37 am   Subject: Altenate way of parameter passing to a sequence job
You can use command line parameters or are you looking for something like using a parameter file?

http://www-01.ibm.com/support/docview.wss?uid=swg21578165
 Topic: Oracle Connector from sequential to partition read fails
wpkalsow

Replies: 6
Views: 2464

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 15, 2017 1:06 pm   Subject: Oracle Connector from sequential to partition read fails
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 SQ ...
 Topic: Oracle Connector from sequential to partition read fails
wpkalsow

Replies: 6
Views: 2464

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 15, 2017 11:05 am   Subject: Oracle Connector from sequential to partition read fails
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Oracle Connector Partitioned Read
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_ke ...
 Topic: Hierarchical Stage XML transformation aborts
wpkalsow

Replies: 12
Views: 6772

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 27, 2017 3:15 pm   Subject: Hierarchical Stage XML transformation aborts
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/Jav ...
Resolved
 Topic: XML An invalid XML character (Unicode: 0xffffffff) was found
wpkalsow

Replies: 9
Views: 5096

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 27, 2017 3:05 pm   Subject: XML An invalid XML character (Unicode: 0xffffffff) was found
You're welcome! Use it in good health.
 Topic: Waves with Hierarchical Stages
wpkalsow

Replies: 4
Views: 1849

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 02, 2016 9:15 am   Subject: Waves with Hierarchical Stages
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 ...
 Topic: Waves with Hierarchical Stages
wpkalsow

Replies: 4
Views: 1849

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 01, 2016 2:52 pm   Subject: Waves with Hierarchical Stages
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 fil ...
 Topic: Hierarchial Data
wpkalsow

Replies: 2
Views: 2974

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 20, 2016 11:03 am   Subject: Re: Hierarchial Data
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 ...
 Topic: System Crashed - can't restore table defs
wpkalsow

Replies: 4
Views: 1479

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Jul 02, 2004 8:30 pm   Subject: System Crashed - can't restore table defs
THANKS!

Got everything to show up correctly!
 Topic: System Crashed - can't restore table defs
wpkalsow

Replies: 4
Views: 1479

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Jul 02, 2004 3:07 pm   Subject: System Crashed - can't restore table defs
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
PLATFORMT ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours