Search found 18 matches
- Thu Oct 31, 2013 9:16 am
- Forum: General
- Topic: To get Job Status for jobs with Invocation ID
- Replies: 5
- Views: 2130
I am running the job through Job Activity which is set Invocation ID as Table Name and Triggering Expression Type as Unconditional . As Job Activity output link is given to End Loop Activity and this link has unconditional trigger type, I believe that the loop continues till all Invocation IDs witho...
- Thu Oct 31, 2013 5:18 am
- Forum: General
- Topic: To get Job Status for jobs with Invocation ID
- Replies: 5
- Views: 2130
To get Job Status for jobs with Invocation ID
Hi I have a Multiple Instance enabled job which runs for 60 tables. Table name is used as Invocation ID. I have created a sequence to form a loop which executes the job for all 60 Invocation IDs( Target table name). There is no dependency between one table load to any of other table load from these ...
- Thu Apr 11, 2013 6:42 am
- Forum: General
- Topic: List of parallel jobs that use Orcle Enterprise Stage
- Replies: 2
- Views: 1787
- Thu Apr 11, 2013 4:37 am
- Forum: General
- Topic: List of parallel jobs that use Orcle Enterprise Stage
- Replies: 2
- Views: 1787
List of parallel jobs that use Orcle Enterprise Stage
Hi could anyone please help me out in listing parallel job that use Oracle Enterprise Stage in a project.? The actual requirement is to replace Oracle Enterprise Stage with Oracle Connector Stage in jobs. There are so many parallel jobs in the project. And more over we are not sure in how many jobs ...
- Thu Jun 28, 2012 4:59 am
- Forum: General
- Topic: Monitor window in Director showing job stopped
- Replies: 6
- Views: 4509
Re: Monitor window in Director showing job stopped
If you come up with errors or warnings from the log of the job sequence, it will be helpful to resolve the issue..
--------
Pons
--------
Pons
- Thu Jun 14, 2012 2:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get previous row value in current row
- Replies: 14
- Views: 12105
Re: how to get previous row value in current row
you can implement the logic using stage variables in Transformer stage
---------
Pons
---------
Pons
- Thu Jun 14, 2012 2:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get previous row value in current row
- Replies: 14
- Views: 12105
Re: how to get previous row value in current row
you can implement the logic using stage variables in Transformer stage
---------
Pons
---------
Pons
- Wed May 23, 2012 11:36 pm
- Forum: General
- Topic: issue when ls command executed in datastage
- Replies: 3
- Views: 3254
Re: issue when ls command executed in datastage
What is the extact command which you are using in your sequence to list the file?
--------
Pons
--------
Pons
- Fri May 18, 2012 4:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sqlcode "-1"
- Replies: 1
- Views: 1500
- Wed May 16, 2012 3:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Multiple Flat Files with Headers using File Pattern
- Replies: 5
- Views: 3838
Re: Reading Multiple Flat Files with Headers using File Patt
The same kind of topic has already been discussed.
Please check whether the solution can help you to resolve your problem.
[url]viewtopic.php?t=125243&highlight=removing+header[/url]
--------
Pons
Please check whether the solution can help you to resolve your problem.
[url]viewtopic.php?t=125243&highlight=removing+header[/url]
--------
Pons
- Tue May 15, 2012 2:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: regarding last transaction and current transaction
- Replies: 7
- Views: 4147
Re: regarding last transaction and current transaction
Use the below logics in stage variables sv_Opening_Bal ---> if @INROWNUM=1 Then 0 Else sv_Prev_Clsoing_Bal sv_Prev_Clsoing_Bal ---> closingbal in colunm deivation, assign the stage variable sv_Opening_Bal to openingbal column. date - date closingbal - closingbal openingbal - sv_Opening_Bal ---------...
- Tue Apr 03, 2012 4:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Key change column
- Replies: 4
- Views: 3198
- Mon Dec 05, 2011 7:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to view all records from sequential file
- Replies: 20
- Views: 9808
- Mon Nov 07, 2011 2:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert number of days to date
- Replies: 4
- Views: 2677
- Mon Apr 25, 2011 1:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Special Character in Output Sequential File
- Replies: 5
- Views: 2950