Search found 7 matches

by joetan
Tue Jun 23, 2009 4:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Increment count of working day for month
Replies: 4
Views: 2126

Increment count of working day for month

Hi all, I have a requirement to calculate the incremental working day for the month. An example like below Cal_Date Day Col1 Col2 01/01/09 Thu N 0 02/01/09 Fri Y 1 03/01/09 Sat N 1 04/01/09 Sun N 1 05/01/09 Mon Y 2 06/01/09 Tue Y 3 07/01/09 Wed Y 4 08/01/09 Thu Y 5 09/01/09 Fri Y 6 10/01/09 Sat N 6 ...
by joetan
Mon Oct 29, 2007 8:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference Stage inserted rows not displaying result
Replies: 3
Views: 4410

Be consistent throughout with the Unicode extended property. I had removed the unicode for all and still encounter the same problem. However, having a different log warning for each field now. Difference_71: When checking operator: Dropping component "SRC" because of a prior component wit...
by joetan
Mon Oct 29, 2007 7:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference Stage inserted rows not displaying result
Replies: 3
Views: 4410

Be consistent throughout with the Unicode extended property. I had removed the unicode for all and still encounter the same problem. However, having a different log warning for each field now. Difference_71: When checking operator: Dropping component "SRC" because of a prior component wit...
by joetan
Fri Oct 26, 2007 1:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference Stage inserted rows not displaying result
Replies: 3
Views: 4410

Difference Stage inserted rows not displaying result

I use the Difference Stage to output inserted, changed and deleted records from 2 dataset files. There are two problems with the output files. Inserted records(0) - showing up as null or no value in the output file Changed records(3) - the before data was display instead of after data The following ...
by joetan
Thu Oct 25, 2007 3:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference stage is gives out empty or Null values
Replies: 2
Views: 1624

How are you setting the options? Are you doing something like this. Drop Output for Insert = False Hi, I've the setting above and hitting the same problem with new rows inserted all coming out as null. In addition, I have the following warning msg for each field TestP: When checking operator: When ...
by joetan
Sun Oct 02, 2005 9:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IDOC stage keep running(stuck)
Replies: 7
Views: 4741

Hi netland, The log file shows the usual stuff of '...NLS map ISO8859-1'. After that it is suppose to show sending rows to IDOC but didn't. Connection to R/3 is ok and when validating the link, it shows all link connected. I can choose different idoc type from the stage, so i think there should be n...
by joetan
Tue Sep 27, 2005 7:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IDOC stage keep running(stuck)
Replies: 7
Views: 4741

IDOC stage keep running(stuck)

Hi all, I have search through the forum but no concrete answer. I encounter this problem everytime the idoc jobs are export to a new server. My IDOC load stage would be stuck and no records updated into it. It would hang and be unable to stop. Have anyone encounter this problem before? Need to resol...