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.
Call a sql script in ds job
Moderators: chulett, rschirm, roy
Call a sql script in ds job
D.N .MURTHY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers