DSXchange

I had gone through those topics but still can't able to make it work....I just need an constraint in Transformer to work..Can anyone let me know the constract for the changekey column from Sort stage?

Hi All, I went through all the searches and I have got few clues but that didnt work for me. There are many duplicates in the Source DRS stage and I need to capture them and ignore those duplicates in the target, My job design is like Source DRS stage --->Join-->transformer--->target (DRS stage), I ...

Hi Ray,

No we don't have MKS toolkit......But is there any possibility to do the Unix functionaltity in Windows?

Yes, you are correct. But I am just seeing how can I make this Unix command to work in DOS....

Thanks for the response, Well I need to get the File Record count using that routine which I had mentioned in Unix. This worked with parallel jobs. But, still seeing how to get the same finctionality work in Server jobs.

Hi All,

Can anyone help me out by giving me the DOS command for the below Linux Command....


Command1 = "wc -l `ls -tr " :PathName: "/*" :XXX: "*" : YYY :"* | head -1` | awk '{print $1}'"

I am trying to implement the same in DOS. Thanks in Advance!!

Hi All,

Is there any possibility to send the email notification when the job aborts from the database level? we are using SQL Server. If yes, how to write it?

We already have from the DataStage level and it working fine. Just as a heads-up, I am trying from the Database.

Thanks in Advance!

Hi All, I am just want to know is there any possibility that we can give the limit to any no. of aborts. We have an email notification which will send out email whenever the job aborts. But is there any options or any functionality to restrict the notification?. After each 50 aborts then only notifi...

Replaced the UserVariable activity with Execute Command and the command is echo %time:~0,2%

Thanks alot Sachin,

I was using time /t command only. I just had a thought whether we can have only HOUR....You got it for me...

Thanks all....

Hi all,

Can anyone let me know the windows command for current time which should show only the HOUR.

for eg: In Unix, the command is date +%H which shows the result as 11 (24 hour format) if the current time is 11:20:36.

I need the same command the get it worked in Windows.

Thanks in advance.

Hi All, I am working with waitforfile and I am using the 1. Starting with StartLoop Activity 2. UserVariable Activity stage to check for time where the expression given is DSJobStartTime[1,2] 3. There is a nested condition stage with the given two expression type as "Custom" and first expr...

BINGO!!!!!!!!!!

Thanks DSguru......I have changed it as two digit and it worked like missile....Appreciate it!!

Hi,

Yes, I am reading the .csv file in sequential file. Tried different ways, still its not working.

Hi All, I am trying to convert the date value as in source the field is in NVarchar and in target (SQL) the field is in Timestamp. I need to convert the value like 1/10/08 9:33 (from source) to timestamp (in target). Tried string to timestamp and left function and all..I am missing some simple logic...