Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Difference between sequential file and data set?

1205


What is datastage engine?

1180


What is the purpose of pivot stage?

1168


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?

2230


how can we create rank using datastage?what is the meaning of rank?

8795


What is the difference between validated and compiled in the datastage?

1293


State the difference between an operational datastage and a data warehouse?

1132


What is the roundrobin collector?

1099


what is the use of skid in reporting?

2381


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746


what is flow of project?

2002


What are routines in datastage?

1329


If you want to use the same piece of code in different jobs, how will you achieve it?

1158


Can you filter data in hashed file?

3773


what are the errors,warnings in datastage

2700