DSXchange

Hi,

Can anyone please help me whether we have any functioanlity in datastage to write a custom routine to encrypt and decrypt passwords?
If so,can you please give me additional information.

Thanks in Advance !

Hi, I reading data from tables & writing to a sequential file.Each time I am running I am overwriting the existing files. I had been running the jobs for several times.I have checked "First Line is Column Names" always.I have never got this problem before. But only during incremental l...

chulett wrote:True, you need the single quotes around the job parameter. Missed that. But no, your date mask is still wrong, it needs to match whatever your job parameter looks like. ...

Ok,So I will change the date mask also.Thank You so Much.

Thanks for your reply. I tried SELECT TO_DATE('01032008','DD/MM/YYYY') FROM DUAL which is working fine.I think I had an error because I was not using ' ' when I was passing Workdate parameter.that is SELECT TO_DATE(#WORKDATE#,'DD/MM/YYYY'). So am I correct that I should use the following: SELECT TO_...

Thanks a lot for ur replies.I will trying changing the format.But ,This happens when I try to convert the Workdate .As my WorkDate is in format 01032008(DDMMYYYY).So when I try to do TO_DATE(#WorkDate#,'DD/MM/YYYY'),I am getting the warning. Basically I have to do DELETE FROM TRGT_TABLE WHERE HLD_IN...

Hi I am getting this warning in my server jobs.I have been running the jobs for about 2 weeks,but I dint get this warning anytime.It happened only when we did Incremental Load.Is there anything wrong with data & datatype.The source & target are both Oraoci stage reading from & writing to...

Thanks for your information.I will buy Premium membership if its only 30c per day.Thanks again

Hi ARVD,


I cannot see your eply as I am not a premium member.Thanks!

Hi priyaraj, Y don you try a much simpler solution.... There is no need to use stage variables for this functionality. Instead check condition in the constraint for the link. Use this constraint: not(isnull(required link) ) Sharad, I tried using the constraint which You sent ,but it still inserts a...

Thanks .

I will try the code which you have sent & let you know .

Thanks again

Thanks a lot !

I will fix it & let you know if I have any issues.

Thanks for your response.

So should I have to give If LK1.PHONE="" Then 'N' Else 'Y' condition?

Thanks again

Thanks for your response.

So should I have to give If LK1.PHONE="" Then 'N' Else 'Y' condition?

Thanks again

Hi, I am reading a data from a file which has "~" as a delimiter.I am writing to a table.There is column PHONE from source where I have check for null value.I should insert the data only when PHONE is not null. So I defined a stage variable with condition If IsNull(LK1.PHONE) Then 'N"...

Yes,I have unchecked ' Log Warnings after activities.....' & it works fine.

Thanks !