Search found 166 matches

by major
Tue Nov 29, 2011 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Logic
Replies: 7
Views: 5419

how are you deriving the CurRepKey , by the way how are you generating the values for desired End_dt ?

Thanks
Major
by major
Tue Nov 29, 2011 2:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator terminated abnormally: received signal SIGABRT
Replies: 7
Views: 3876

Ahh...finally I found the reason , there is an non-english character in one of the column for a single row out of 30k rows . I have filtered that row and the XML is creating without any issues. Initially, I was pushing the output of XML 2 to a dataset so I can see only SIGABRT error. But when I remo...
by major
Mon Nov 28, 2011 1:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: issue with extral line feeds
Replies: 5
Views: 3461

hi,

Ereplace and Convert functions should work.
Can you post the syntax here and check if there are any other columns wiht extra LF.

Thanks
Major
by major
Sat Nov 26, 2011 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator terminated abnormally: received signal SIGABRT
Replies: 7
Views: 3876

Chulett, I have 3 datasets - Accountline, reinsurance and ult-reinsurance with their own set of attributes . One accountline can have 0-n reinsurers and one reinsurer can have 0-n ult-reinsurers . I need to generate XML in the similar way with accountline attributes under which we should have reinsu...
by major
Thu Nov 24, 2011 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator terminated abnormally: received signal SIGABRT
Replies: 7
Views: 3876

Any suggestions please

Thanks
Major
by major
Wed Nov 23, 2011 1:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator terminated abnormally: received signal SIGABRT
Replies: 7
Views: 3876

Operator terminated abnormally: received signal SIGABRT

Hi all, I'm getting below error message from one of my jobs XML_Output_2,0: Operator terminated abnormally: received signal SIGABRT main_program: Step execution finished with status = FAILED. details of job design 1. Joning 2 datasets using join stage and putting the output in XML 1 2. Output of XML...
by major
Thu Nov 03, 2011 5:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Switch stage
Replies: 3
Views: 1764

Now I'm not using single line selector Still it shows the same error Switch_25: Parse error on case string: "21"=0 "22"=0 "23"=0 "24"=0 "12"=1 "13"=1 "14"=1 "16"=1 "17"=1 "98"=2; multiple `=' tokens w...
by major
Thu Nov 03, 2011 2:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Switch stage
Replies: 3
Views: 1764

Error in Switch stage

Hi, I'm using Switch stage to populate 3 output files I have selected User defined Mapping and put the below in Case block Case="21"=0 Case="22"=0 Case="23"=0 Case="24"=0 Case="12"=1 Case="13"=1 Case="14"=1 Case="16"=1 C...
by major
Thu Aug 11, 2011 9:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "-1 Rows affected"-SQL Server Call Execute Failed
Replies: 5
Views: 2932

Hi Ray, There isn't any previous errors or other logs for the specific run. We are able to connect and retrieve from this data source. Issue occurs during INSERT/UPDATE and while we change the "Transaction Handling" options, the WARNINGS behave differently. We are still to find a resolutio...
by major
Thu Aug 11, 2011 9:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "-1 Rows affected"-SQL Server Call Execute Failed
Replies: 5
Views: 2932

fixpacks up to date

Hi Chulett,

Thanks for the response, we verified the Fixpacks and all are up to date.
We are trying to contact support directly though, any other leeds in this regard ?

Thank you very much again!
by major
Thu Aug 11, 2011 5:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "-1 Rows affected"-SQL Server Call Execute Failed
Replies: 5
Views: 2932

"-1 Rows affected"-SQL Server Call Execute Failed

Hi, After going through different search outputs i am posting this topic, We recently upgraded from DS7.5 to DS8.1 Server edition and facing the below issue. Data is not getting updated properly in SQL Server DB. DSD.BCIPut call to SQLExecute failed. SQL statement:UPDATE IntlHeadCount.dbo.TIFEED_STA...
by major
Thu Jul 28, 2011 9:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look up table temporary Storage space
Replies: 2
Views: 1925

we have modified the resource disc to create the data segments in the /dsProjects/data/xxxxx/(user defined) directory by modifying the resource disk parameter in the configuration file while creating the datasets. now while reading the dataset for lookup the temporary look up lookuptable.20110728.cs...
by major
Thu Jul 28, 2011 7:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look up table temporary Storage space
Replies: 2
Views: 1925

Look up table temporary Storage space

Hi, In our job we are Creating dataset in a user defined path, to avoid size issues in the /dsProjects/Datasets path by modifying the configuration file. our User defined path for Datasets grew to a size of 60GB. While running some of our job the temporary look up lookuptable.20110728.cso50ab is als...