Answer / jack

You can invoke shell script through Job Properties -->
Before Job routine --->ExecSH

Answer / vaishali

using execute command stage

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/

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

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

---

What is the roundrobin collector?

0 Answers  

---

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

What is merge stage?

0 Answers  

---

How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

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?

11 Answers   Cap Gemini,

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

Describe the architecture of datastage?

0 Answers  

---