Call a sql script in ds job

dr.murthy · Post by **dr.murthy** » Thu Oct 21, 2010 4:07 am

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.

ArndW · Post by **ArndW** » Thu Oct 21, 2010 4:19 am

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.

dr.murthy · Post by **dr.murthy** » Thu Oct 21, 2010 4:22 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Oct 21, 2010 5:07 am

Why not? Resist stupid requirements!

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

chulett · Post by **chulett** » Thu Oct 21, 2010 7:15 am

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.