Search found 31 matches
- Sun Dec 07, 2008 10:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash Size Limit
- Replies: 4
- Views: 2710
- Sun Dec 07, 2008 9:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash Size Limit
- Replies: 4
- Views: 2710
Hash Size Limit
Hi All, We have a static hash file that we clear and re-create every month in our production cycle. I think the hash file limit is up to 2GB. I am wondering if we are close to the size of hash file or did we exceed already? What will happen if we exceed 2GB does the job fail or does it overwrite the...
- Tue Jun 07, 2005 12:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: filter commands
- Replies: 4
- Views: 1984
- Tue Jun 07, 2005 11:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Finding the specific stages
- Replies: 1
- Views: 880
Finding the specific stages
Hello All,
Is there a way we can find out the category and job names in which a specific stage is used? For example can I find out all the job names which used a pivot stage or row merger stage in a specific project? Any administrator commands which can solve this?
thanks
Is there a way we can find out the category and job names in which a specific stage is used? For example can I find out all the job names which used a pivot stage or row merger stage in a specific project? Any administrator commands which can solve this?
thanks
- Tue Jun 07, 2005 11:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: filter commands
- Replies: 4
- Views: 1984
filter commands
Hello All, I need some help in understanding the filter command option on the seqfile stage. When do we use these filter commands and what kind of filter commands we can use in the Filter command text box. Can we use any kind of UNIX commands? I tried to use the sort command using the -t"|"...
- Mon May 16, 2005 12:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: merge Column level
- Replies: 2
- Views: 1018
merge Column level
Two input flat files with two columns each File 1: Rec_Cnt Total_Amount 125 5000.00 File 2: Rec_cnt Total_Amount 275 15000.00 OutputFile: Record count from the second file and total amount from the first file. Rec_cnt Total_Amount 275 5000.00 There are no keys in the two files. The way I tried is to...
- Thu May 12, 2005 10:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Design help on Multi Instance job
- Replies: 2
- Views: 1309
Design help on Multi Instance job
Hello All, I saw many posts about the divide and conquer rule and I am planning to follow the same for the performance of my job. My job design is, reading a seq file with 30 million records and writing it to four different files based on the constraints. I need some ideas in building a multi instan...
- Thu May 12, 2005 10:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Write Error
- Replies: 3
- Views: 1510
- Thu May 12, 2005 8:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Write Error
- Replies: 3
- Views: 1510
Write Error
Hello All, I was using a ExecSH as a before routine in which I used a sort command to sort the specific columns. In development it worked perfectly well and in UAT it failed leaving the error. sort: A write error occurred while sorting. The command I used is sort -k5,5 -k10,10 -k1,1 file1 file2 > fi...
- Fri Apr 15, 2005 2:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine Fix Repeat
- Replies: 6
- Views: 3272
- Thu Apr 14, 2005 11:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine Fix Repeat
- Replies: 6
- Views: 3272
Ray, Thanks for the quick reply. I am taking all the column as arguments in the routine and trying to implement the logic. Ex: the InLink.MBNR will be stored in a stagevariable as sv1 and my routine arguments will be the InLink.MBNR, sv1 to compare the current and previous MBNR column values. But so...
- Thu Apr 14, 2005 9:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine Fix Repeat
- Replies: 6
- Views: 3272
A routine must return its result through a variable called Ans - your routine code does not appear to assign a value to this variable. Ray, Sorry I forgot to copy the Ans. The routine should return the count. Here it is Ans = Count Here is an example and CNBR( 3 rd column is the key) MNBR PNBR CNBR...
- Thu Apr 14, 2005 4:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine Fix Repeat
- Replies: 6
- Views: 3272
Routine Fix Repeat
Hello All, I am repating this post http://www.dsxchange.com/viewtopic.php?t=92268&highlight=routine+fix as I tried my best to fix but no luck. So guys I need some help here. Below is my routine and it works like a charm.(The database count field is '0' upto this point and I have to populate the ...
- Wed Apr 13, 2005 4:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine Fix
- Replies: 6
- Views: 2583
The initial count value will be equal to 0 and the count should return values based on the conditions below with a flag where the current and previous row are equal or not. If (CurrMCol <> PrevMCol) AND (CurrPCol <> PrvPCol) and Code 20,29 then count = 0 else count = 1 If (CurrMCol = PrevMCol) AND (...
- Wed Apr 13, 2005 9:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine Fix
- Replies: 6
- Views: 2583