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

Highlight the main features of datastage?

615


What are the types of containers in datastage?

705


what is use of SDR function?

4711


What are the steps needed to create a simple basic datastage job?

664


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?

1759






What is the command line function to import and export the ds jobs?

683


Why fact table is in normal form?

678


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1085


What are the functionalities of link collector?

628


What are the features of datastage flow designer?

636


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1932


How many types of hash files are there?

613


What are transforms and what is the differenece between routines and transforms?

618


What is the sortmerge collector?

668


How one source columns or rows to be loaded in to two different tables?

666