DSXchange

Thanks chulett. 1) The jobs continue to throw this warning. How can I get the jobs from throwing this warning? Can I just restore the files? 2) What are these files used for? 3) Can I redirect what drive and folder the files are written to. There were about 10 gigs worth when I deleted them. 4) Is t...

Apologies to the forum. The comments and link is for version 8.0.1

there is a patch that addresses the problem I described. See link below

http://www.ibm.com/eserver/support/fixe ... 5499_sapr3_*

Thnaks priyadarshikunal. The information on the link resolved the warning

Hi all. I have a lookup stage that is displaying the following message: Look_Up_Stage_Name: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0. [api\operator_rep.C:3448] Does anyone know how to r...

Thank you all for your suggestions.

ray, I use the 2 sort stages and a transform to generate a lookup file. That lookup file is used to filter out the records that I need.

chulett , the expected output is:
001 AAA
001 AAA
001 AAA
001 BBB
001 BBB
002 BBB
002 CCC
002 CCC
002 AAA

That is because there are 001s with AAA abd BBB. There are 002s with BBB, CCC, and AAA.

Sorry for the confusion guys. 001 and 002 is in the keyed field1. AAA, BBB, and CCC are in field2. When field1 is a duplicate the data in field2 should have the same value. I need to capture all the records that have duplicates in field1 where field2 is different. In the following example input: 001...

I have a file that has a primary key that is duplicated. The file also has a field1 and field2. I need to capture the records that have the same primary key and field1 and/or field 2 is different. I tried searching for "capture duplicate" with no luck for this situation. Example input 001 ...

Thanks ray. I started with http://www.dsxchange.com/viewtopic.php?t=118685 and ended up with the following: svColId = If Link_In.keyChange Then 1 Else svColId + 1 svConCat = If Link_In.keyChange = 1 Then Link_In.Fld1 : "," : Link_In.Fld2 : "," : Link_In.Fld3 Else svConCat : "...

Hi all. I have a file where the data is listed horizontally. Each row has a composite key, i.e., Key1 and key2 and the columns of data. The keys can be in the file 1 to 5 times. How can I list the data vertically one key followed by the repeated data? Thanks in advance for any help Key1 Key2 Fld1 Fl...

Apologies to the forum. I should have included some detail. In a batch job (PrintSequence.bat) I have the following dsjob -logdetail ProjectName SequenceName_1 dsjob -logdetail ProjectName SequenceName_2 dsjob -logdetail ProjectName SequenceName_3 . . In a Execute Command stage printed the sequence ...

Thanks ray. A print to file (dsjob -logdetail...) of the job sequence logs and a quick datastage job to pull and organize the information from the log file did the trick. Thanks again.

Thanks ray. I mean run from the job sequence.

Hi all. I have 2000+ jobs and 400+ sequencers in a project. I need to be sure that no job is called from multiple sequencers. How can I generate a report that shows what jobs are called by what sequencer? The goal is to have the report in the following format Job_01 Seq_01 Job_02 Seq_01 Job_02 Seq_0...