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

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 ?    15 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

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

0 Answers  


How can you find the 2nd Highest salary in a file department wise in abinitio?

9 Answers   IBM, TCS,


When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

0 Answers  


How can a graph be run infinitely?

0 Answers  


Explain about ab initio’s dependency analysis?

0 Answers  






Have you ever encountered an error called “depth not equal”?

0 Answers  


Can you explain the co>operating system’s processing model?

0 Answers  


Have you eveer encountered an error called "depth not equal"?

2 Answers  


What are the differences between different versions of co-op?

0 Answers  


) How can you count the total no .of records in the specified partition in the Multifile?

5 Answers  


How can we increase the loading performance of oracle table in AbInitio?

0 Answers  


name the air commands in ab initio?

2 Answers   IBM, Syntel,


Categories