Interested to Buy Any Domain ? << Click Here >> for more details...
hello,
tell me the function which removes spaces from decimal
field?
- 2 Answers
- 24002 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murali udayagiri
Generally the decimal field does't contain any spaces.
The below two are string functions.
1.decimal_lpad
2.decimal_strip
These can be used for
a)trim the spaces
b)Removing nondecimal
from string inputs.
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 2 Yes | 1 No |
What is a rollup component? Explain about it.
How to create a repository in abinitio for stand-alone system(local nt)?
What is local and formal parameter?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Tell us about the architecture of abinitio.
How to get DML using Utilities in UNIX?
Describe how you would monitor and control database physical file size and growth?
can we perform checkin and checkout through sandbox?
What is Is_defined(), Is_null(), Is_Blank()?
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..
What is the difference between check point and phase?
Teradata 
