I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
Answer Posted / trupti
InputField = "abcdefghijklmnopqrs"
step by step we can use transformer functions as,
1. left(InputField,10) ==> OP will be 'abcdefghij'
2. Use above output in
right (abcdefghij,1)= 'J'
The final derivation will be like below,
Convert(right(left(InputField,10),1),'Z',Inputfield)
Output :- abcdefghiZklmnopqrs
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the important features of datastage?
Differentiate between validated and Compiled in the Datastage?
What is ibm datastage flow designer?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to manage date conversion in Datastage?
What is "fatal error/rdbms code 3996" error?
What is the use of hoursfromtime() function in transformer stage in datastage?
Can you explain players in datastage?
what is flow of project?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How many types of stage?
What are the steps needed to create a simple basic datastage job?
What are the main features of datastage?
What are the different types of lookups in datastage?
how to implement scd2 in datastage 7.5 with lookup stage