DSXchange

Hi Arndw, Thanks for your help. It works partially. When I set variable using your suggestion it does transfer data between two files but it stopes after it finds once the CRAP and CRAP1. I need to reset the variable again and again as the file might have 'CRAP' and 'CRAP1' again and again and I nee...

Hi kcbland I tried defining stage variables like (If FoundRow OR (DSLink3.Field001 Matches 'CRAP') Then 1 Else 0) but it is not helping much. Can you give me example of stage variable condition based on my requirements I can try ? I appreciate your help Just a few stage variables and a couple of con...

Hi, I have a file A (.csv) which has let's say 100 rows. I need to read this as a source and create two output files B & C based on the data inside. For explanation purpose the files has 10 columns. I need to trasfer data from A to B & C both until column 1 hits word "CRAP", then I...

Hi ArndW,

It works. Thanks a lot for the help.

VSanghvi

Hi, I have reading data from .csv and I need to only strat transfering data when column 1 value is "XYZ" and all afterwards. Let's say the document is 1000 rows and the XYZ is at 150. So I need to copy starting 150 to 1000. It is not always 150 where the XYZ is. How can do that ? Any help ...

Ray,

This is certainly not a TX question. I have added under Server Edition. I don't know why it got added here. Thanks for pointing it.

VSanghvi

Hi I am using stored procedure stage to read data from DB2 calling a specific stored procedure and writing to a seq file. SP takes 12 parameters and returns a cursor with 25 colums. In designer on my parameters tab of the sp stage I have listed first 12 parameters and then 25 output column names. No...

Hi I am using stored procedure stage to read data from DB2 calling a specific stored procedure and writing to a seq file. SP takes 12 parameters and returns a cursor with 25 colums. In designer on my parameters tab of the sp stage I have listed first 12 parameters and then 25 output column names. No...

Thanks Ambuj743 and others. This works great.

Ambuj743 wrote:In the transformer stage use this line e.g I want to put # in the filed which is varchar datatype. if your datatype is integer use 0. It will work.

if isnull(DSLink1.Code ) then '#' else DSLink1.Code

I tried this and it did not like the syntex. For e.g. I wrote If DSLink1.Code = NULL Then DSLink1="NONE" Else DSLink1.Code = "NONE"

Let me now if this is not correct. Or how do i correct it ? Thanks a lot

logic wrote:IF THEN ELSE.........

Hi, I have job where I am reading data from DB2. Now the column I am reading can have null as well. I need to replace that null to "NONE". I did try with CHANGE function but it only works with empty string and not NULL. Is there any inbuilt function or do I need to write custom. Any idea ?...

Thanks Manoj and Kumar. I did add column with unique row ID (@OUTROWNUM) and it does work. Thanks for you help.

Kumar, I am not sure how I will be violating a business rule doing this ? Can you explain what it could be?

Thanks
V

Thanks Manoj. I think you have good suggestion but i am not very clear on implementation. If i understand it correctly. Add a colum in the first output has file which will look like this, ROWNO, ITEM 1, ITEM2 Then do a look up on row numer and write ITEM 3 and ITEM4 to the same hash file ? or differ...

Thanks Ray. The jobs are not running at the same time it will run one after another. When you mentioed about an extra table ? do you mean Hash File ? Not possible if the jobs are running at the same time. This is an O/S restriction, not a DataStage restriction. If the jobs are run consecutively, use...

Hi, I have two jobs and I want to write to same seq file after running both job. I know i can append at the bottom of the file but I want to add to the next colum instead rows. For e.g. I am writing ITEM 1 and ITEM2 from job 1 and ITEM3 and ITEM 4 from job 2. Now I want to see result like below. ITE...