DSXchange

I have a job that reads from a CSV file. The problem is that this file has a blank line at the end of the file. Please let me know how to take care of this.

Thanks in advance

Appreciate you kind reply. It's really helpful to us. We would definitely keep in mind the points suggested by you. I would like to request the forum to share their learning experience on this topic so that we are well equiped while doing the Upgradation. Thanks Bapajju I don't think you are going t...

We are planning to move from datastage6.0 to datastage7.5.Could you please let me know where to find the relevant documents that specifies the Issues/Challenges/precaustions and the Process for Upgrading from datastage6.0 to datastage7.5. Even if one comprehensive white paper will also do. Thanks in...

Ray, Thanks a lot. It worked. It really worked as we wanted it to be. Thanks a lot again. :) bapajju Subject to two very specific conditions, yes. The first condition is that you have an ODBC driver for Excel. If not, stop reading now - you will need to export each sheet as a separate CSV (or TXT) f...

Hi,

Is there any way that we can read one Excel sheet with multiple pages.

Thanks Chulett. I think this should be the solution i.e. controlling the job from out side. It will be very nice of you if you could publish the Syntax for the same. Thanks Bapajju I don't think you can do this from inside the job. :? What I'd look into doing is running the job from some custom Job ...

Roy,

Thanks for your reply. But could you please let me know how can I check for warnings in a stage variable. It will be very kind of you.

roy wrote:Hi,
you could try to check in a stage variable or link for warnings and abort if the job type is A.

IHTH,

Hi, I have job that has a parameter called TYPE and this parameter can have values like A or B. The requirement is like: if I run with TYPE=A and I get any warnig message then I want to immediately abort the job, but if I run with TYPE=B and any warnig occurs then it should give standard datastage l...

Yup Boss. I will. Thanks for the help. Appreciate your help. You'll have to write your own. You may want to look here: http://www.dsxchange.com/viewtopic.php?t=85788 to get a headstart. This function subtracts two timestamps. You basically have to subtract minutes and deal with rolling under hours a...

HI, I have a timestamp field in the format as : yyyy-mm-dd hh24:mm:ss. Now I have another input field called MINUTES (Decimal (5,0)) and this field essentially contains values like 10,20,30... which are essentially number of minutes. I need to deduct this value from the timestamp field and put into ...

James u can try this option. We follow the similar pattern.

Have another O/p link to any Sequential file or any Target Error. In the constraints for this new link Check the Rejected Check Box. This link will capture all the records that have not been loaded to the target due to any eeor.

Thanks

Thanks dnzl. I will try the same. But still I have a doubt whether that will work.As Chulett the look up will work as Match or Mismatch. Still I will try your suggestion. Thanks a lot.

Hi all, I am using a HASH file for look up. The HASH file has fields as A,B, C and all the fields are key fields. My input record has fields as C1,C2 and C3. I need to do the look up as mentioned below: Lookup will be successful if: C1 matches with A AND (C2 matches with B when C3='LINE' or C2 match...

You can follow this. This is one of the approches we follow. 1. There will be records for Update ( That needs to be a changed record of the existing record) and there will be new records also. 2. For insert records look up into the target table and see if the exact record exists, if it exists then d...

Thanks Rasi.

I tried it again with Update and Insert in the single stage with two links and in the Update Link I have put transaction Size as 1. It now works fine.

Thanks for your suggestion