hello, tell me the function which removes spaces from decimal field?

hello,
tell me the function which removes spaces from decimal
field?

Question Posted / mansoorkjl

2 Answers
24045 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hello, tell me the function which removes spaces from decimal field?..

Answer / prakash b

Use 'decimal_lpad' or 'decimal_strip'

Is This Answer Correct ?

16 Yes

1 No

hello, tell me the function which removes spaces from decimal field?..

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

Post New Answer

More Ab Initio Interview Questions

What are the steps to create a repository in ab initio?

0 Answers

What does edp stand for?

0 Answers

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

0 Answers

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

0 Answers

What is $mpjret? Where it is used in ab-initio?

4 Answers

hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....

1 Answers

Explain what is de-partition in abinitio?

0 Answers

What information is provided by .dbc file extension for connecting to the database?

0 Answers

What is the difference between partitioning with key and round robin?

7 Answers TCS, Wipro,

Have you worked with packages?

0 Answers

What mpjret contains ? How to use in abinitio graph?

2 Answers IBM, TCL,

Describe how you would monitor and control database physical file size and growth?

3 Answers IBM, Satyam,

For more Ab Initio Interview Questions Click Here