How to add zero "0" before record in a field?

Answer Posted / santhu

Ranjan is right but when we want add 4 zeros("0")then By Using String Function we can do that

String("o",1):Column name
Here 1 is how many zeros we want

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What steps should be taken to improve Datastage jobs?

635


Difference between in process and inter process?

695


Difference between data warehousing and olap?

650


What can we do with datastage director?

666


What is datastage engine?

728






how to export or import the jobs in .ISX file

714


EXPLAIN SCD

958


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

1627


What is staging variable?

622


What is difference between symmetric multiprocessing and massive parallel processing?

649


How complex jobs are implemented in datstage to improve performance?

589


Describe link sort?

638


What are the main features of datastage?

659


How the ipc stage work?

669


How many Key we can define in remove duplicate stage?

818