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

Difference between server jobs & parallel jobs?

1 Answers  


What is ibm datastage?

1 Answers  


What are stage variables and constants?

1 Answers  


Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,


With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,


Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  


what are the errors,warnings in datastage

1 Answers   Syntel, Wipro,


Enlist various types of routines in datastage.

1 Answers  


I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,


How to create user defined environment varibale(parameter)?

1 Answers   TCS,


Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,


how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,


Categories