Execute script from DS

shiva459 · Post by **shiva459** » Tue Aug 26, 2003 2:01 pm

Hi
I have to run a SQL script from the command line through EXECUTE COMMAND activity of the sequencer.Now I can give the command as
db2 -tf and the parameter as the file name.Now my question is where should I place the script file?Should it be placed in any specific folder?I am working on AIX.
Regards

Shiv

spracht · Post by **spracht** » Tue Aug 26, 2003 2:29 pm

For portability reasons, I found it sensible to place scripts into subfolders of the project directory, as the utilities executing OS commands or scripts always take the project directory as their working directory. Thus you can always specify the path to your script relative to the project account.

Stephan

ray.wurlod · Post by **ray.wurlod** » Tue Aug 26, 2003 4:34 pm

Stephan's approach has the additional benefit that these sub-folders can then be referenced as custom folders by Version Control for DataStage.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518