DSXchange

Before the transformer sort the input rows with your key column. And create stage variables in the transformer like below: svOld - svNew svNew - InputColumn.Key svCheck - If svOld <> svNew then 'Y' Else 'N' sv1 - If svCheck = 'Y' Then If InputLink.Col1 = 'YES' Then 1 Else 0 Else If InputLink.Col1 = ...

I'm sorry if I'm still missing something here.. To get the count, you dont need to pass your source key to the target hashed file. Your key, for example can be a hard coded '1' for all rows. For the sample data you gave the hashed file will look like: Key YesCnt NoCnt NACnt 1 4 2 2

Yes this logic works for only one set of data, it should be able to handle different group types(i.e the key column keeps changing) I did not understand this. Can you give some example? And if you are talking abouut the Key column in the Hashed file, it should be a dummy key, say 1 for all the rows.

If your requirement is to just add a header after every 50 records, you can create a dummy column say SeqNum and assign values like, first fifty as 2, 2nd fifty as 4. In a separate file create all the header records you want with SeqNum column with values like 1,3,5. Then merge both the files and so...

If my understanding is correct the below approach will work. SeqFile ----> Transformer ----> HashedFile ---->SeqFile In the transformer, create 3 stage variables: sv1 - If InputLink.Col1 = 'YES' Then sv1+1 Else sv1 sv2 - If InputLink.Col1 = 'NO' Then sv2+1 Else sv2 sv3 - If InputLink.Col1 = 'NA' The...

Can you give more information like, Do you use a scheduler? You want to run the jobs parallely or one after the other?

What are you trying to do? Why cant you read the file in the job and pass it on to the routine?

Why dont you cat the file, check for the row count and set the user status in the job? Why do you want to set the user status in the routine?

Can you try something like this:

If Input.Column < 0 Then '-' : Trim(Field(Input.Column,'-',2),'0','L') Else Trim(Input.Column,'0','L')

I'm not sure if i'm missing something here. As far as I understood your requirement, you can try the below approach. If your source is database, select all your rows and in a separate stage select the max of date from the same source table. Use a look-up and pass the row to target which matches and ...

Thanks Craig and all. This is what I'm doing now.

Thanks everyone. I do have a unix script with the sleep. But I was just wondering whether we would be able to do it in datastage.

Vivek, I will try to explain this more clearly. This is what we do. Whenever the sequence starts, we do a ls with the file pattern. and if the file is out there, we will get the file name. If the file is not there, we need to wait for 2 Hrs before aborting the job. Here I need to pass the file name ...

You can use this to check a date. This will return null if the incoming date is not valid. And this will work for all other date formats except YYYY-MM-DD.

oconv(iconv(vDate,'d4'),'d-ymd[4,2,2]')

Try this and let us know.

If both the table are in different database, I believe the best way would be to do it in a query.

Ask your DBA to create a dblink for you.