How to abort a job in a routine if the source file is empty?

Shaina Austin · Post by **Shaina Austin** » Tue Dec 14, 2004 4:47 pm

Hi All:

My source file has 1 header, n detail and 1 trailer records.

First I perform a check on the header, if the header is not found, I abort the job after 1 record in the constraint.

I need to do the same with the trailer. I reject the trailer in a separate sequencial file, here if the trailer is not found then abort the job. I am unable to do this in the constraint, as there is no record found in the sequencial file, if the trailer does not appear in the source file.

Hence I am trying to write a routine using the DSLogfatal, but cannot get started with it. Can anyone please guide me thru the steps I need to follow or what should be included in the routine. Also where and how do I implement this routine?

Any help is greatly appreciated.

lebos · Post by **lebos** » Tue Dec 14, 2004 5:55 pm

One way to do this is to write a "Dummy" trailer record to your trailer reject file at the beginning of your job. This way the file is never empty and you can check it later in a constraint to see if it contains a real trailer or the dummy one.

This involves a little overhead, but not much.

Larry

kcbland · Post by **kcbland** » Tue Dec 14, 2004 11:26 pm

Why not write a before/after routine that uses Unix commands? In the routine, you can use the DSExecute API (search the forum for LOADS of examples) to execute a shell command. You can do heads and tails and lots of stuff that will return the screen output in a variable, then look at the variable and take appropriate action. To call DSLogFatal, again search the forum for loads of examples.

DSkkk · Post by **DSkkk** » Thu Dec 16, 2004 11:20 am

i need to abort the job if there are no records in it. i get a header which gives the rowcount but i do not know where and how to compare this. if this is 0 then the job should stop abort.
can you please help me.

lebos · Post by **lebos** » Thu Dec 16, 2004 3:07 pm

In the tranform into which the input file is going, code something like the following in a derivation field:

If Input.HeaderCount = 0 then UtilityAbortToLog("No Records to process") Else Input.HeaderCount

Modify this to fit your needs. Use field names to match your transform, put your own expression after the else.

You might want to verify the syntax, but it is close.

Larry

arunverma · Post by **arunverma** » Fri Dec 17, 2004 8:14 am

Hi ,

We had also same problem , but we resolve this problem with Unix shell scripting, we had got confirmation that source file having standard head and trailer , then we create unix script which check header and trailer and call this script in datastage job - before job subrotuine .

With Regards

Arun

dsxdev · Post by **dsxdev** » Sat Dec 25, 2004 3:24 am

You can achieve this functionality in a routine by using DSExecute and all the logic embedded inthe Code. Even Job cintrol Code would be another option.

DSkkk · Post by **DSkkk** » Mon Dec 27, 2004 10:57 am

i solved the problem using a shell script.
thank you though for trying to help me

Shaina Austin · Post by **Shaina Austin** » Mon Dec 27, 2004 4:34 pm

Hi,

Kiran, I am still not able to abort my job, if the file is empty. Can u explain, how u acheived this using a shell script?

Probably, it might help me in doing the same.

Thx.