DSXchange

Sorry for that stupidity... JobName = "srcDlyCalcTxns_LN" BatchName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) result = DSGetLinkInfo(DSJ.JOBNAME,DSJ.ME,DSJ.ME,DSJ.LINKROWCOUNT) Errcode = RunRestartableJob(JobName,HASHPATH,BATCHNUMBER,"BATCHTIMESTAMP=":BatchStartDts) If Errcode Then GOT...

following Error is coming:----Batch::LNRemitMaster_exp..JobControl (fatal error from Batch::LNRemitMaster_exp): Batch ran failed! (see warnings) Is is not at all calling following part of code...just failing....and dont care abt the routines.....those are restartability routines JobName = "srcD...

DEFFUN RunRestartableJob(JobName,HASHPATH,BatchNumber,SKIPPARAM) Calling "DSU.RunRestartableJob" DEFFUN EmailErrorMessage(HASHPATH,BatchNumber) Calling "DSU.EmailErrorMessage" DEFFUN JobControlReset(JobList) Calling "DSU.JobControlReset" DEFFUN RunBatch(JobList, Params...

DSGetLinkInfo syntax i checked....as per that i have modified bold part... JobName = "srcDlyCalcTxns_LN" BatchName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) Errcode = RunRestartableJob(JobName,HASHPATH,BATCHNUMBER,"BATCHTIMESTAMP=":BatchStartDts) If Errcode Then GOTO ENDJOB result = DS...

DEFFUN RunRestartableJob(JobName,HASHPATH,BatchNumber,SKIPPARAM) Calling "DSU.RunRestartableJob" DEFFUN EmailErrorMessage(HASHPATH,BatchNumber) Calling "DSU.EmailErrorMessage" DEFFUN JobControlReset(JobList) Calling "DSU.JobControlReset" DEFFUN RunBatch(JobList, Params...

i have a job control for this where i have sequenced it...
can you please share a code how to check the input is null or not in this case?

I have a job......

sequential stage---->FTP stage

what i need to do is.....

1) job should run sucessfully...
2)it should not post any black file to remote server if the input has no value....

is it possible?

I have a one more requiermnt...lets say if query doesnt fetch the data then i get a blank seq. file.....but now if i dont want the job to get aborted also i dont want the blank file to get created can i do that?

can you please elaborate little more

Hi i have developed a sever job which is pretty simple,It just has Oracle Stage which will Extract data into the Sequential file.

But many times query is not pulling the records from table so the black file is getting generated

Can you please tell me how to abort the job if the no data gets fetched?

Can we write and use Job control code for Parellel jobs?

here is my fullcode...... FunctionName = "ParseFE1X" ******************** * Define Functions * ******************** DEFFUN ConvDateCYYDDDtoYYYYMMDD(A) Calling "DSU.ConvDateCYYDDDtoYYYYMMDD" DEFFUN ConvDateToYYYYMMDD(A) Calling "DSU.ConvDateToYYYYMMDD" DEFFUN ConvtSignO...

chullet...thanks alot i got ur point.

here is my fullcode...... FunctionName = "ParseFE1X" ******************** * Define Functions * ******************** DEFFUN ConvDateCYYDDDtoYYYYMMDD(A) Calling "DSU.ConvDateCYYDDDtoYYYYMMDD" DEFFUN ConvDateToYYYYMMDD(A) Calling "DSU.ConvDateToYYYYMMDD" DEFFUN ConvtSignOv...

Thanks i will keep in mind...but any solution for this?