DSXchange

Hey!!! Does anybody have idea, how to release a Lock in DataStage 5.2? I am implementing a job. Suddenly I got DataStage Repository Interface Error. So I closed DataStage Designer Window without Save. When I opened Same job again, It is showing "Already opend by another user". I assure no ...

Thanq Kenneth.
I will check it now in my Projectname folder.

Does anybody pls let me know the following Error and How to rectify in Unix DS Server. Right now I am using DataStage 5.2 (WIN2000/Client) and DataStage 5.2 (Unix/Server) Project:MTest (127.0.0.1) Job name:jODSSampleSts Event #:36 Timestamp:9/15/2003 8:34:15 AM Event type:Warning User:adm Message: j...

How to do in DataStage the following Condition If (DSLink1.EmpJob < 'VS_PRES') Then DSLink3.EmpJob = "CEO" *Passing Value to Target column V_One = "T" *Setting the variable Else DSLink3.EmpJob End Here V_One is Stage variable or parameter. That we will use in another Target Stage...

Hey, Here is my exact process.. If the Error Condition occurs then Insert default value ("-1") to target table and Log an error in Err table. I have already given my ErrTable column names in the above Message. So, Pls give your Suggestions how to do in DataStage? Right now Im using DataSta...

Hey Ray, Craig Thanx ur respond. Yes you are right I want log an Error for column. That means here Im taking one Lookup also. For Example, Master_table.column1 = Lookup.column1 then retrieve Lookup.column2 and pass to Target table. So here Lookup.column2 is not available then display "-1" ...

Hey Ray, Craig Thanx ur respond. Yes you are right I want log an Error for column. That means here Im taking one Lookup also. For Example, Master_table.column1 = Lookup.column1 then retrieve Lookup.column2 and pass to Target table. So here Lookup.column2 is not available then display "-1" ...

Hey All, I doing a Job J1 in that I am passing one Source Column value to Target Column. So, When the Source Column Pass "E" or "-1" to Target column, I want to go to Another job and Insert Log an error to this particular column. For example, If (a < b) Then -- Statements End Els...

Hey, Thanx to this replies. Still Im in R n D to Transpose my Source Columns into Target Records. Is there any otherway to do without take 20 Input Streams and with more Lookups. I have 4 columns in my Target table and each of this Target columns having 11 columns to transpose each. So If i write St...

Hey Craig, But actually my query like this only. So Its okay to given your Query. But Here I have In-line Query. So How to I take it in ORAOCI8? So this is the problem. And I have taken this whole query to my Master Stage (ORAOCI for Employees) and I tried. Then Im getting result. But thats not the ...

Hey Vincent,

Thanx your repsond. But here Im using Lookup. So Lookup inside Lookup is not possible right? Without using SQL Query, Is there any other way should perform this Query? If suppose I've Nested In-line queries then how can i do with ORAOCI8?

Thanx in Advance.

Ravi

Here I am using ORAOCI8 as Lookup and Retrieving a Column and This Retrieved column is tranf. to Target. This is my following Query. SELECT d.department_name FROM employees e, departments d WHERE e.department_id = d.department_id AND d.location_id = (SELECT location_id FROM locations WHERE country_i...

Hey All, Im new to DataStage tool. Right now Im using DataStage 5.2 Client in Windows 2000. And DataStage Server also in Windows 2000 and Version 5.2. And Im using ORAOCI8 to both Source and Target sides. Backend is Oracle 9i. I have a table in oracle src_one (Source table) and the availble columns ...

Hey All,
Thakx your Suggestions. Well Its worked Successfully to my Standalone system. But Its not working to my other Server. May be the problem they have not Initialized. Again Thanx to all your Suggestions.

Regards
Ravi

Hey, Can anybody give Suggestions to the following Error. Here Im using DataStage5.2 in Windows 2000 Professional. Both Server and clients are in my system. And Here Im using ORAOCI as Lookup Ref. Link to Transformer Stage and Sequential file stage as target. It Compiled successfully. But when I val...