Search found 25 matches

by sarat.srinivas@tcs.com
Wed Oct 10, 2007 5:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can I kill the job which is still running after stopped?
Replies: 7
Views: 3185

Hey,

Just re-compile that running job in Designer, then the status will be changed in Director. This happened with us too when we were working with Windows 2003 server & DS 7.5x2 version.

Sarat.
by sarat.srinivas@tcs.com
Tue Aug 28, 2007 11:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using file pattern option in the sequential file
Replies: 3
Views: 1984

Re: Using file pattern option in the sequential file

[/quote] Check if there are any files with .txt extension available or not, that seems to be the problem. And, hope you are not specifying a path on your client machine, the URL has to be for a server directory.[/quote] Hi Sud, Thanks for the reply! There are .txt files in the path specified and the...
by sarat.srinivas@tcs.com
Tue Aug 28, 2007 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using file pattern option in the sequential file
Replies: 3
Views: 1984

Using file pattern option in the sequential file

Hi All, I have two text files which have the job log of two respective jobs say Job1,Job2, in a placed in a folder. I am using another job for reading these log files everytime after the jobs are exceuted. I am trying to use the file pattern option in the sequential file, and tried giving the path o...
by sarat.srinivas@tcs.com
Tue Aug 21, 2007 5:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation of DS 7.5.2 on AIX 5.3
Replies: 5
Views: 2948

Installation of DS 7.5.2 on AIX 5.3

Hi All, I want to install Datastage 7.5.2 on AIX 5.3. I have refered to the available user manuals but could not find anything specific to AIX 5.3. I want to know the issues and problems faced while doing the installation process. Could anyone, who have already installed datastage on AIX5.3 , share ...
by sarat.srinivas@tcs.com
Tue Aug 21, 2007 12:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic in the job using the Lookup stage
Replies: 5
Views: 1108

You can have more than one column as key fields in sort stage. Hi JoshGeorge, Ya. The idea of using a sort and a filter is surely seperating the redundant data.But, actually the requirement is that we need to compare the data in the input file and the files in the data tables before the redundant d...
by sarat.srinivas@tcs.com
Mon Aug 20, 2007 5:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic in the job using the Lookup stage
Replies: 5
Views: 1108

You can do this in one job without any look up. Pass the records coming from your input file thru a sort stage (sorted on keys) by checking the change key option in sort stage. Use a filter stage and pass all the records with change key column values as 1 to your data table and rest to your error t...
by sarat.srinivas@tcs.com
Mon Aug 20, 2007 4:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic in the job using the Lookup stage
Replies: 5
Views: 1108

Logic in the job using the Lookup stage

Hi All, The following is the job details I have to impemented: I have an input text file which has data of the tide-height value at that respective time and date. I have to achieve that we will load the unique tide-height which are unique with respect to the date time values into the data table, and...
by sarat.srinivas@tcs.com
Wed Jul 18, 2007 11:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connecting to DB2(v 9.1) database server from Datastage
Replies: 3
Views: 2023

Hi,
The Server name ,Username and Password have been passed correctly. Is there any other property of this stage which has to be considered so as to avoid this error ?
by sarat.srinivas@tcs.com
Wed Jul 18, 2007 4:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connecting to DB2(v 9.1) database server from Datastage
Replies: 3
Views: 2023

Connecting to DB2(v 9.1) database server from Datastage

Hello, We are trying to connect to the DB2(v 9.1) database which is on a Windows xpProfessional system, from Datastage(7.5.x2) which is on another system which is a windows 2003 Server, using a parallel job.In the job we are we are giving a simple .csv input file with a couple of columns as the inpu...
by sarat.srinivas@tcs.com
Wed Jul 18, 2007 4:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connecting to DB2(v 9.1) database server from Datastage
Replies: 1
Views: 1259

Connecting to DB2(v 9.1) database server from Datastage

Hello, We are trying to connect to the DB2(v 9.1) database which is on a Windows xpProfessional system, from Datastage(7.5.x2) which is on another system which is a windows 2003 Server, using a parallel job.In the job we are we are giving a simple .csv input file with a couple of columns as the inpu...