Empty Source File

amsh76 · Post by **amsh76** » Tue Jun 15, 2004 5:03 pm

I want to give a warning when the source file is empty but the job should not abort. Right now if I have an empty source file, the the job aborts as the source spage cannot read the file. Can anyone tell me how to handle this situation?

My requirement is that the job should not abort but should give a warning.

chulett · Post by **chulett** » Tue Jun 15, 2004 5:13 pm

Something else is wrong - an 'empty' source file should not cause a job to fail. It should simply run and process no records - no errors, no warnings - just start up and shut back down and do a whole lot of nothing.

If the job aborts, it should only be because the source file does not exist, or perhaps because the data is not in the proper format.

You can check in an after job routine the number of rows the job processed and write a warning to the log if the number is zero. Check out the DSGetLinkInfo function in your online help with the DSJ.LINKROWCOUNT InfoType.

amsh76 · Post by **amsh76** » Tue Jun 15, 2004 9:06 pm

Thanks Craig,

But when I am trying to run after job routine for row count, its giving compilation errors. Says DSAttachJob needs to be dimensioned. What I am trying to do is first Attach the job, then get job info, stagelist and then row count. But its not working...

chulett · Post by **chulett** » Tue Jun 15, 2004 9:13 pm

Put this at the top of your routine:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

Or more properly:

Code: Select all

$IFNDEF JOBCONTROL.H 
$INCLUDE DSINCLUDE JOBCONTROL.H 
$ENDIF

kcbland · Post by **kcbland** » Tue Jun 15, 2004 9:13 pm

In order to use the job control APIs you must put this statement at the top of your function/routine (courtesy of Ray Wurlod):

Code: Select all

$IFNDEF JOBCONTROL.H 
$INCLUDE DSINCLUDE JOBCONTROL.H 
$ENDIF

The include statement adds the API definitions to your function.

kcbland · Post by **kcbland** » Tue Jun 15, 2004 9:14 pm

Jeepers Craig, you won that one.

chulett · Post by **chulett** » Tue Jun 15, 2004 9:15 pm

Not by much, it would appear.

amsh76 · Post by **amsh76** » Tue Jun 15, 2004 9:32 pm

Thanks Guys..This Helps

Juls · Post by **Juls** » Thu Sep 30, 2004 2:38 pm

Hi, I am pretty new to DS and not too familiar with BASIC and routine execution.

I am having the same problem as described here: Job Fails and Aborts if Data source is empty. (I am running on Windows).

Where would I place this routine to get row count as described here?

DSGetLinkInfo(DSJ.ME, "src_tbl_SW_VAL_PRODUCT","lnk_GO_TO_SORT_1",DSJ.LINKROWCOUNT)

Thanks.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 30, 2004 5:00 pm

I'd put it in a separate thread, since it's not about "empty source file"

DSXchange