Search found 6 matches

by rob47329
Thu Feb 04, 2010 6:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Consuming xml
Replies: 1
Views: 799

Please disregard post. In my sequential file, I did not define a delimitter between fields. Putting in a pipe delimitter seperated columns appropriately. My bad. Thx :oops:
by rob47329
Thu Feb 04, 2010 6:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Consuming xml
Replies: 1
Views: 799

Consuming xml

Hello All, I am reading a couple of xml records from a sql server database(using a DRS database stage). I pass each xml rec(as a single field - longvarchar 99999) to an xml input stage. In my xml input stage(input tab), I select the xml source column and check the radio button XML_document(setting c...
by rob47329
Wed Jan 06, 2010 6:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: disables stages in designer - DS 7.5.1a
Replies: 3
Views: 1551

Thanks for the info Craig. I checked that the client software and server software are in sync. Looks like not having ".net framework 1.1" on my workstation is the problem. Every peer that has the datastage client installed can use the xml stages(if they have .net 1.1 installed). Those with...
by rob47329
Wed Jan 06, 2010 4:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: disables stages in designer - DS 7.5.1a
Replies: 3
Views: 1551

disables stages in designer - DS 7.5.1a

Hello all, I recently tried to drag an xml stage to a parallel job, but I got a message saying "40906 - unable to create new object". All xml stages give this same message(no other stages though). I tried re installing the client software and I noticed a message box appears prior to the in...
by rob47329
Fri Jan 23, 2009 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key stage in Datastage 8.0
Replies: 3
Views: 2103

Sounds like 8.x will still require a routine to get the result of query to the surrogate stage.

thx
by rob47329
Fri Jan 23, 2009 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key stage in Datastage 8.0
Replies: 3
Views: 2103

Surrogate Key stage in Datastage 8.0

Hello all,

I currently work with DS 7.5.2 and am wondering if the surrogate key stage in DS 8.x accepts a table name as an option.

In 7.5.2 it only accepts a 'starting value'.

Thanks