Search found 22 matches
- Wed Sep 17, 2003 8:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How is Release Lock?
- Replies: 2
- Views: 1487
How is Release Lock?
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 ...
- Tue Sep 16, 2003 12:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: (HashFiles) VOC file as a file definition record.
- Replies: 2
- Views: 1659
- Mon Sep 15, 2003 7:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: (HashFiles) VOC file as a file definition record.
- Replies: 2
- Views: 1659
(HashFiles) VOC file as a file definition record.
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...
- Fri Aug 01, 2003 12:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: If Condition...
- Replies: 1
- Views: 1345
If Condition...
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...
- Thu Jul 31, 2003 10:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling one Job from another Job....
- Replies: 6
- Views: 2715
- Thu Jul 31, 2003 10:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling one Job from another Job....
- Replies: 6
- Views: 2715
- Thu Jul 31, 2003 10:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling one Job from another Job....
- Replies: 6
- Views: 2715
- Thu Jul 31, 2003 3:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling one Job from another Job....
- Replies: 6
- Views: 2715
Calling one Job from another Job....
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...
- Mon Jul 21, 2003 4:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to do Row Convention in DataStage?
- Replies: 5
- Views: 3457
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...
- Fri Jul 18, 2003 7:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using ORAOCI8 Stage as Lookup....
- Replies: 4
- Views: 2040
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 ...
- Fri Jul 18, 2003 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using ORAOCI8 Stage as Lookup....
- Replies: 4
- Views: 2040
- Fri Jul 18, 2003 12:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using ORAOCI8 Stage as Lookup....
- Replies: 4
- Views: 2040
Using ORAOCI8 Stage as Lookup....
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...
- Tue Jul 15, 2003 11:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to do Row Convention in DataStage?
- Replies: 5
- Views: 3457
How to do Row Convention in DataStage?
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 ...
- Wed Jul 09, 2003 11:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error with ORAOCI and ORAOCI8
- Replies: 4
- Views: 2381
- Tue Jul 08, 2003 12:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error with ORAOCI and ORAOCI8
- Replies: 4
- Views: 2381
Error with ORAOCI and ORAOCI8
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...