Search found 22 matches
- Thu Oct 27, 2005 7:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequential file parsing.
- Replies: 5
- Views: 1781
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...
- Wed Oct 26, 2005 7:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequential file parsing.
- Replies: 5
- Views: 1781
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...
- Tue Oct 25, 2005 3:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequential file parsing.
- Replies: 5
- Views: 1781
Sequential file parsing.
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...
- Fri Oct 21, 2005 2:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Text file read from a particular row.
- Replies: 2
- Views: 1236
Thanks
Hi ArndW,
It works. Thanks a lot for the help.
VSanghvi
It works. Thanks a lot for the help.
VSanghvi
- Fri Oct 21, 2005 12:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Text file read from a particular row.
- Replies: 2
- Views: 1236
Text file read from a particular row.
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 ...
- Mon Oct 17, 2005 8:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Stored Procedure Stage help
- Replies: 2
- Views: 1340
- Mon Oct 17, 2005 8:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Stored Procedure stage help
- Replies: 0
- Views: 824
Stored Procedure stage help
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...
- Wed Oct 12, 2005 12:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Stored Procedure Stage help
- Replies: 2
- Views: 1340
Stored Procedure Stage help
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...
- Wed Sep 14, 2005 2:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to replace null to something.
- Replies: 9
- Views: 4921
- Wed Sep 14, 2005 1:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to replace null to something.
- Replies: 9
- Views: 4921
- Wed Sep 14, 2005 12:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to replace null to something.
- Replies: 9
- Views: 4921
How to replace null to something.
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 ?...
- Fri Aug 19, 2005 11:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to add data to same seq file from more than one jobs
- Replies: 8
- Views: 3138
- Thu Aug 18, 2005 7:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to add data to same seq file from more than one jobs
- Replies: 8
- Views: 3138
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...
- Thu Aug 18, 2005 7:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to add data to same seq file from more than one jobs
- Replies: 8
- Views: 3138
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...
- Wed Aug 17, 2005 4:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to add data to same seq file from more than one jobs
- Replies: 8
- Views: 3138
How to add data to same seq file from more than one jobs
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...