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

What is Fastly Changing Dimension?

6 Answers   TCS,


what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,


Define Routines and their types?

0 Answers  


How the ipc stage work?

0 Answers  


What is mapping?

3 Answers  






I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

1 Answers   TCS,


What is the importance of the exception activity in datastage?

0 Answers  


i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,


IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


To see hidden files in LINIX?

0 Answers   CTS,


when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,


Categories