Interested to Buy Any Domain ? << Click Here >> for more details...
Hi frnds, my scenario is like i'm having a record
1234"1323£3434%343434^23232!1212$23232
in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
- 2 Answers
- 16890 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Please use below function.
convert('!@#$%^&*','',string)
No need of the give space in between codes
Only one step to solve this.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is a merge in datastage?
What is the project in datastage?
What is aggtorec restructure operator?
What are system variables and sequencers in datastage
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the use of datastage director?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the features of datastage flow designer?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the important features of datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How do you start developing a datastage project?
What are the types of hashed files in data stage
