How do u call shellscript/Batch file from DS?
Answers were Sorted based on User's Feedback
Answer / jack
You can invoke shell script through Job Properties -->
Before Job routine --->ExecSH
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / datastage4you
there are diff ways to call..
if Seq job :
Use command stage to call a shell script
or if job
go to the job properties and select "Before/After job
routine" and use ExecSH options to invoke shell script.
Thanks
http://datastage4you.blogspot.in/
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kiran
Well answer from Jack and u can call from another way.go to
Job Properties and ther r one option is ther like
APT_CONFIG_file Tab is there do to user defined and select
Search Shell Path
Is This Answer Correct ? | 2 Yes | 9 No |
Can you define merge?
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
How can you find out whether datastage process is running or not in unix?
What are the enhancements made in datastage 7.5 compare with 7.0?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
what is usage of datastage with materialized views
Why do we use exception activity in Datastage?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?