Thanks for the reply Ray.
Here are the XPath expressions I am providing in the description field:
/Batch/Number/text()
/Batch/Vendor/text()
/Batch/Code/text()
/Batch/Amount/text()
Thanks
Search found 117 matches
- Thu Sep 05, 2013 12:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Grouping in XML stage
- Replies: 14
- Views: 5271
- Wed Sep 04, 2013 11:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Grouping in XML stage
- Replies: 14
- Views: 5271
Grouping in XML stage
Hello Experts, I am new to XML seeking an advice on the issue I am having: My input is a fixed width file, I am using XML stage to to generate the XML file. Here is the requirement: I have 4 columns coming from the source: Number Vendor Code Amount 1 XYZ 04 100 1 XYZ 04 200 I mentioned Number, Vendo...
- Fri Oct 28, 2011 5:08 pm
- Forum: General
- Topic: Menu bar display
- Replies: 12
- Views: 9499
- Thu Oct 27, 2011 5:35 pm
- Forum: General
- Topic: Menu bar display
- Replies: 12
- Views: 9499
I also faced similar problem sometime back ...you have to go to registry edit and remove some of the entries ... HKEY_CURRENT_USER\Software\Ascential Software\DSDesign\DSDesign* ie DSDesign, DSDesign-Summary, DSDesign-Bar0, DSDesign-Bar1, DSDesign-BarN etc. I got this from this forum .. Hi, Though ...
- Mon Jul 18, 2011 12:11 pm
- Forum: General
- Topic: Sequencer is getting aborted with Code=-99
- Replies: 0
- Views: 1360
Sequencer is getting aborted with Code=-99
Sequencer is getting aborted with Code=-99 [General repository interface 'other error']. Here is the complete error: Controller Problem: Error calling DSRunJob(Load_Job_Statistics.Job_Name), Code=-99 [General repository interface 'other error']. This particular sequencer is calling another sequencer...
- Tue Nov 09, 2010 3:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CombinedOperatorController,0: *** glibc detected ***
- Replies: 3
- Views: 2719
APT_CombinedOperatorController,0: *** glibc detected ***
I am staging a table and I get the following error message APT_CombinedOperatorController,0: *** glibc detected *** /opt/IBM/InformationServer/Server/PXEngine/bin/osh: malloc(): memory corruption: 0x09d8be80 *** and after a very long error log the job finally fails with this: APT_CombinedOperatorCon...
- Fri Oct 01, 2010 5:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25202
similar requirement
Or even in a simpler way, create a stage variable like this: sv1 = sv1 : ',' : InputColumn and map it to the target column derivation. The last output row will have all the values... This doesn't works . The output is coming as 0,0,0,0, Hi, Can you tell me how did you define your Stage Variable exa...
- Mon Mar 08, 2010 4:27 pm
- Forum: General
- Topic: How to delete readonly routines
- Replies: 11
- Views: 5712
- Wed Dec 16, 2009 12:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Handling comparison of effective dated rows
- Replies: 1
- Views: 1237
Handling comparison of effective dated rows
I have a set of lookups and these continue to add data to my stream that will eventually create the Profile table. On one lookup I need to add some descriptions depending on the row in my source table that has the maximum effective date less than or equal to the current effective date in the stream....
- Tue Dec 01, 2009 9:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Job Hangs
- Replies: 3
- Views: 1916
- Tue Dec 01, 2009 8:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Job Hangs
- Replies: 3
- Views: 1916
Datastage Job Hangs
Hi We have created a job that is designed as follows DRS - IPC - XF - XF - IPC - DRS The jobs in Director shows it is still running where as the first link from the DRS to the IPC and the last link from the IPC - DRS show that they are finished (Only these 2 links are green, all others are Blue) Any...
- Tue Oct 13, 2009 9:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Job Error - Value to Large for Column
- Replies: 0
- Views: 1356
Datastage Job Error - Value to Large for Column
We are running in to the issue mentioned below with almost all our jobs at some point in time or the other. Sometimes when we run an ETL job we get an error like the one below J_STAGE_Cus_PS_UA_DW_LOAD_STATUS..Trans_Assign_Values: The value of the row is: STATUS_LD = LOAD - OK10-12 22:28:29 J_STAGE_...