DSXchange

The answer is YES. You need to set up a DSN in .odbc.ini and uvconfig under your project.

I already figured it out by using or XSLT or XPath. If use XPATH, use ../@employeeno for parent, //EMPLOYEE/@employeeno for the current node. for XSLT: <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="...

Now I have similar problem. I want to read the recursive XML into different tables. For example: <EmployeeNo 100> Name='a' <EmployeeNo 102> Name = 'b' </EmployeeNo> <EmployeeNo 201> Name = 'c' </EmployeeNo> <EmployeeNo 103> Name = 'z' </EmployeeNo> </EmployeeNo> which means c reports to b. b and z r...

Is that the only message you got from Director?

DS_FocusGroup wrote:Al_Address_Name_Link_FL,0: TeraSession: cli rejected buffer write, stall #0 of 0.

Is that the only message you got from Director?

DS_FocusGroup wrote:Al_Address_Name_Link_FL,0: TeraSession: cli rejected buffer write, stall #0 of 0.

Thank you very much, Ray. Even though I can't read all your content. I have the solution now. Could you please give me a discount to join the Premium Membership? As a return, I will post the complete solution.

I got this error message too. I already input the PX auth code. Does anyone konw this issue?

I went through the whole forum and find the answer. QS is not a true c/s architeture. You got to do a export/import if you want to share the jobs with others or migrate to other environment. And version 8 fix this problem, works like DataStage.

I am new to QualityStage. I installed QualityStage Server on Unix and QualityStage Designer on my desktop. When I ran QS designer, it created a access database as repository. I went through the documents, it seems that QS doesn't have a central repository on the Server side. I am wondering how can s...

1. clear status file
2. clean up resources
3. go to
http://www.ibm.com/developerworks/forum ... 6#13948755

My source column is a NULLABLE value, but it needs to get dumped into target column that is NOT NULLABLE, so i have the modify stage to convert the nullability and am using the HANDLE_NULL function in specification.. but how do i do this 1) Set the default date to 1/1/1901 if source value is null 2...

I installed 64 bit TeraData CLI V2 and the connection between TeraData and DataStage didn't work. And then we find out that DataStage is 32 bit application, it just support 32 bit DataBase client. And for TeraData, the database user must have creat, insert, update and delete permission, otherwise, y...

You can drop or change the order of columns. You can have extra copies for backup purpose.

I wrote a function which can extract number out from a .ini file, it will return string number like "25". My server job will call this function and assign the output value to a stage variable: stagevar. My job is to fileter out the records that column DUE is greater than that stagevar. At ...

It is really an old post. I encountered the same problem today. ETL server and DB2 reside on different machine. Does anyone know how to point 'Directory for Data and Command Files' to the DB2 box? It will be ok if I point it to ETL server dirctory. Please forgive me if this is simple, but I am runni...