DSXchange

Hi,

i have an requirement to create a datastage job to call sql script with in job but this is an external SQL script it should not be imbeeded in job control tab of ds job.

Any suggestions how to call this script in ds job.

that is a bit confusing, since in the job control tab you can call up external programs... which seems to be what you want to do.

Am not supposed to call this script through job control tab.

Why not? Resist stupid requirements!

Then you can execute it through a before-job or after-job subroutine.

If they are worried about not 'seeing' anything on the canvas, put an annotation there stating where/what is going on. Otherwise you'll need a single record source, a routine to call DSExecute() and then some kind of a target which could be a flat file directed to /dev/null, I suppose.