How to convert alpha Numeric values to alpha using functions?



How to convert alpha Numeric values to alpha using functions?..

Answer / niraj pathak

Using convert function
Sv1=convert (0123456789,col1,"")

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,


what is executable in DataStage?

2 Answers  


source contains 2 columns comes to target 4 columns how

1 Answers   IBM,


how to sort two columns in single job in datastage.

0 Answers   TCS,


Enlist various types of routines in datastage.

0 Answers  






how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers  


If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,


i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  


what are the types of nodes

4 Answers   HCL, TCS,


1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,


Categories