DSXchange

Hi I want to trigger mail using UNIX shell script by getting the job status of datastage job using dsjob command. I tried to get jobstatus as soon as job execution is completed. Here is what I am doing in shell.. executing job using dsjob command and in next step i am trying to find the status of jo...

Hi

If I give date() function in input, I see some number at the output without the date.
What is the actual date() format in server jobs

Because when I am sending a date in yyyymmdd format in server job, its converting some junk value at the out put

Thanks in advance

Hi I have a routine which generates some report based on requirements. Now I just want to add some query to that routine, to get some additional statistics from a database table which should go into that file. So, can I execute an SQL query in routine activity stage. If so, can you please help me ho...

At the datastage level I have mentioned where clause with those key columns, but at table level I dont mentioned any key columns...may be that makes to delete all records?

Three targets with the appropriate action in each and constraints based on the last column's value. ... Thankyou for your reply I tried the same, but when some records are passing to delete stream, all records are getting deleted in the database. Database is DB2, and using DB2 Api stage. Delete wit...

Hi I have a question, let me take an example I have five columns, first two columns are key columns and last column is an indicator in which 'I' stands for Insert, 'C' stands for Update and 'D stands for Delete. For first run, I will have all I's which will be all inserts Col1 Col2 Col3 Col4 Col5 A ...

Why do you want to achieve this using only one transformer? Using Transformer and Lookup stage we can achieve this, but I have this requirement multiple times for a particular accounting. So, I was trying to reduce the number of stages rather than whole bunch of stages using again and again. Just w...

Hi I have a question I want to seperate all dupes into one file and without duples into other file only just by using transformer. Can we do that. We can seperate duplicates using two stage variables which is easy but in this case I have a diff. requirement Let us take an example Input OutFile1 OutF...

Hi

How can I enter multiple unix commands in after or before job subroutine in job properties level.

How can I seperate each command from other if I am entering a set of commands

Thanks in advance

Well, there wont be any value in Col3 to use. So its like generating an indicator "X" to process further. So, let us say Col2 value of third record is -2, then the result of record2 and record3 of Col3 should be X I have generated a surrogate key col along with this data. So in simple way ...

Hi I have a requirement like this Col1 Col2 Col3 A - X A -1 X A -3 X A 2 A 5 X A 0 X If the value in Col2 <=0 then the Col3 = "X" and its previous record values in Col3 should be "X" Else " " So while checking this, how to skip the first values of Col2 (because no value...

There's no "else" to stopping. From your Execute Command stage, link a zero trigger to a stage after the End Loop. The >0 trigger goes to the End Loop stage. ... Hi Can you please tell me in a little more eloborative way which may help me more. I couldnt get anything from your above sente...

Hi Yes you are right. I was thinking how to handle this loop end. Any suggestions from your end please At job level, everytime I am capturing re_process file counts in a diff file at /temp/count.txt In Sequence level using Execute_Cmd_Acty(read count from file) cat /temp/count.txt UserVariable_Activ...

ray.wurlod wrote:StartLoop and EndLoop activities in sequence seems to me to be the best approach. ...

Hi
Could you please suggest me how to handle it in Sequence using start loop and end loop

Thanks

Hi I have a requirement as below File1--->some stages---->Transformer ---->File3 ---->File2 Transformer pushes data into File2 and File3 Now File3 need to become the source file File1 Again same job runs This process should keep on going until the count in File3 becomes zero and File2 data keeps on ...