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 |
Difference between server jobs & parallel jobs?
What is ibm datastage?
What are stage variables and constants?
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
With out using Funnel Stage, how to populate the data from different sources to single target
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
what are the errors,warnings in datastage
Enlist various types of routines in datastage.
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
How to create user defined environment varibale(parameter)?
Difference between the Sequence and Sequencer in DS?
how to change left and right links in join stage?