Answer / subbuchamala

1) In Sequential file, we have an option like 'filter'.
in the filter we can mention like:
sed 's/\^M//g' FileName.txt

or
2) we can do this in Before job routine(executeSH) and we can cal this in Seq file stage. here we can use UNIX command 'unix2dos fileName.txt'

Answer / subhash (subbuchamala)

We can use these ways also to remove Control M Characters

tr -d '\r' < yourfile.txt > yourfile1.txt
mv yourfile1.txt yourfile.txt

or

Change the line terminator in Sequential File stage from
UNIX-style to DOS-style(it's a stage property).

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

job locking methods? How can we unlock the job?

3 Answers   IBM,

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,

---

How to manage date conversion in Datastage?

0 Answers  

---

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

---

What is a delta record? How you will read it?

0 Answers   EDS,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

how to call routines in stages?

3 Answers   ME,

---

What are the partition techniques available in your last project?

1 Answers  

---

What is container and then types?

1 Answers  

---

Pls tell me what is troubleshooting in datastage view?

1 Answers  

---

How can we improve performance of data stage jobs?

0 Answers  

---