Search found 117 matches

by UAUITSBI
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

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
by UAUITSBI
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...
by UAUITSBI
Fri Oct 28, 2011 5:08 pm
Forum: General
Topic: Menu bar display
Replies: 12
Views: 9499

Ray,

True I was checking for the solution and accidentally ended up posting. As there would be no major difference in registry I thought the fix would be same.

I am using DataStage Version 8.5. Is there a separate fix for this problem ?
by UAUITSBI
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 ...
by UAUITSBI
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...
by UAUITSBI
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...
by UAUITSBI
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...
by UAUITSBI
Mon Mar 08, 2010 4:27 pm
Forum: General
Topic: How to delete readonly routines
Replies: 11
Views: 5712

just to confirm, after reading this thread the actual solution was altering the original command to :

DELETE FROM DS_ROUTINES WHERE DSRID='MyRoutine';
by UAUITSBI
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....
by UAUITSBI
Tue Dec 01, 2009 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Job Hangs
Replies: 3
Views: 1916

Personally I think absolutely no point :)

But unfortunately these are jobs delivered by Peoplesoft so changing them might not be in my best interest ( I might need to change over 1000 )
by UAUITSBI
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...
by UAUITSBI
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_...