Search found 12 matches

by praveensuss
Mon Mar 30, 2009 2:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before/After Stage subroutines
Replies: 10
Views: 13231

Hi dsuser_cai, I am looking at Parallel job. I have copied a text from the parallel job developer guide in my first thread of this post. It says that we can call before/after job subroutine in job properties as well as in transformer stage. Thanks. as far as i know only the server job(transformer) h...
by praveensuss
Mon Mar 30, 2009 1:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before/After Stage subroutines
Replies: 10
Views: 13231

Re: Before/After Stage subroutines

Hi All, I am checking in Job properties and not in the sequencer properties. I have pretty much worked with DataStage but not on shell scripts and routines. So, I do very well know to access the job properties and stage properties. The version I am using is 8.1.0. I am still surprised why am I not a...
by praveensuss
Mon Mar 30, 2009 1:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before/After Stage subroutines
Replies: 10
Views: 13231

ArndW wrote:I am not at a DataStage client at the moment, but know that I have used Before/After job routines at Version several times in the past so they are still in the product. I would guess that the before/a ...
Hi ArndW,
I could not see your complete reply as I am not a premium member..
Thanks.
by praveensuss
Mon Mar 30, 2009 12:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before/After Stage subroutines
Replies: 10
Views: 13231

Before/After Stage subroutines

Hi, This is the first time I am trying to use a Before or After stage subroutine in a DataStage job. I have Information Server 8.1 installed in my system. I have copied the below text from the Parallel job Developer guide, To specify a routine, click the stage properties button in the toolbar to ope...
by praveensuss
Fri Mar 27, 2009 12:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob command - error while using ./dsenv
Replies: 2
Views: 2619

dsjob command - error while using ./dsenv

Hi,

I was trying to run the ./dsenv command before running the dsjob command. But I get a permission error as shown below:

-bash-3.2$ pwd
/opt/IBM/InformationServer/Server/DSEngine
-bash-3.2$ ./dsenv
-bash: ./dsenv: Permission denied
-bash-3.2$


what may be the reason for this ?

Thank you !
by praveensuss
Fri Mar 27, 2009 11:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob command in LINUX - 'command not found' error
Replies: 1
Views: 3116

dsjob command in LINUX - 'command not found' error

Hi, This is the first time I am trying to use dsjob command to execute job from LINUX. I tried a simple exercise to execute a job using dsjob command. But it says dsjob command not found. But I checked for dsjob in the path and it exists. -------------------------- -bash-3.2$ pwd /opt/IBM/Informatio...
by praveensuss
Tue Nov 20, 2007 2:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wait for File in FTP
Replies: 4
Views: 2720

Re: Wait for File in FTP

Hi, Thanks for the response.. The problem here is if i dont get a file on a particular day in FTP, even if i set the re-try intervals to a maximum value, the FTP job will abort.. This will abort my entire sequence.. The requirement here is: All the jobs in the sequence should run as soon as a file a...
by praveensuss
Tue Nov 20, 2007 1:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wait for File in FTP
Replies: 4
Views: 2720

Wait for File in FTP

Hi All, I am really in need of the following : I have a bunch of jobs that need to be triggered and executed when a file apperas in a FTP path. I am trying to do this via job control code. Does anyone know how to use DSWaitForFile job control command to check for an FTP file ? I am able to use this ...
by praveensuss
Tue Nov 20, 2007 1:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check for file using Job Control code
Replies: 1
Views: 999

Check for file using Job Control code

Hi All, I am really in need of the following : I have a bunch of jobs that need to be triggered and executed when a file apperas in a FTP path. I am trying to do this via job control code. Does anyone know how to use DSWaitForFile job control command to check for an FTP file ? I am able to use this ...
by praveensuss
Fri Sep 21, 2007 1:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Call stored procedure in Sequence
Replies: 5
Views: 3489

You can use "Stored Procedure stage" available with DataStage to call the stored procedures and sequence them through a Job Sequencer..I hope this shld work..
by praveensuss
Fri Sep 21, 2007 12:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file stage-Active or passive stage?
Replies: 7
Views: 3266

Hashed file is a Passive stage.. Actives stages, such as the Transformer and Aggregator perform processing tasks, while passive stages, such as Sequential file stage, hashed file stage and ODBC stage, are reading or writing data sources and provide services to the active stages. Hope this clarifies ...
by praveensuss
Thu Sep 20, 2007 3:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file stage-Active or passive stage?
Replies: 2
Views: 1511

Re: Hash file stage-Active or Passive stage

Hash file is a Passive stage.. Actives stages, such as the Transformer and Aggregator perform processing tasks, while passive stages, such as Sequential file stage, hash file stage and ODBC stage, are reading or writing data sources and provide services to the active stages. Hope this clarifies your...