My source having following data as below,
AB1
Aim2
Abnv5
1An8bx
and my question is i need the Datastage job the following
as in my target
000AB1
00Aim2
0Abnv5
1An8bx
Please help me to achive this.
Answer Posted / d
Str('0',6-Len(string)): string
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
How you can fix the truncated data error in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What steps should be taken to improve Datastage jobs?
Have you used Unstructured data?
What are system variables and sequencers in datastage
Difference between in process and inter process?
How many Key we can define in remove duplicate stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the purpose of pivot stage?
What are iconv and oconv?
Differentiate between Join, Merge and Lookup stage?
What are the job parameters?
What is difference between symmetric multiprocessing and massive parallel processing?
How to perform incremental load in datastage?