DSXchange

Time out for what in datastage.

As Craig pointed out you can. But thats only part of your test, the second part is the time 8:00pm I wrote a quick little routine for you. It checks for existence of end file and checks for time. If file exists or time equals or exceeds 8:00pm, it will return 1 else 0. Depending upon that you can br...

So now, either the arrival of END file or arrival of 8 pm will terminate the sequence job. Well i hate to break it to you but you will have to use some sort of Basic coding to achieve that. Here's what i would do. Within start loop and end loop have a wait for file activity that waits for the trigge...

I never did believe in the saying "Ignorance is Bliss"

If thats the case then my apologies. Just couldnt get you the first time

ray.wurlod wrote:"server jobs would all become read-only" in Hawk.

Wow. Thats a pretty bold statement to make, for any rep. And a scary one for huge server edition fans.

Thats true. YOu need to put that in the derivation as



and in the columns provide the name as Field_Name.

Still doesnt make sense. Say for example your job is inserting a few hunder thousand records into the database and your end file shows up, how do you want to handle that? You cannot just end the job without aborting it or sending an explicit stop request. I dont think termiinating the job at the ver...

I am pretty sure we will be upgrading it to 8.0 as soon as it comes out. Just had a chat with an IBM consultant here at our site. He is trying to get the beta version for a trial. But seems like we will be getting it as soon as it shows up.

and the sequencer also should end in a normal mode. What do you mean by normal mode? Do you mean by just end and not continue processing ??? If you force abort the sequence job, it will abort. Not in a normal mode. You need to build your logic in such a way, so that it keeps checking for the arriva...

Certainly possible. But nothing out of the box other than commiting at all or none. This methodology has been discussed here before. Try a search. As for the two jobs in the sequence job and this being the second job, that is the basic restartability provided by the sequence job. Its certainly achie...

sun786....the OP happens to sit on a windowz box.

If we are using the routine as an After-job subroutine, I guess we can skip the test to check if the file is of zero size, before we can get the DSGetLinkInfo? If no rows have passed through the link, we get the result as zero. Not really. Like the OP said, that he is doing some validations and get...

Can you copy paste the sql your target stage is generating. Something is happening at the 25th column.

Well, yes if you are trying to get the row count inside the transformer and if no rows come thorough it wont be instantiated and hence you wont get any validations done.
You need to handle this is before/after stage subroutine. Maybe test to see if file size is zero then do something.