Search found 26 matches
- Tue Sep 11, 2012 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Stage variable into Oracle using Oracle date formats
- Replies: 3
- Views: 3927
- Tue Sep 11, 2012 8:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Stage variable into Oracle using Oracle date formats
- Replies: 3
- Views: 3927
Passing Stage variable into Oracle using Oracle date formats
Hi, I am trying to write a dynamic query in Oracle using Datastage variables that get set at time of job running. I am getting errors from the way I am tying to pass the date into Oracle. I have defined a stage variable: srchQueryDateRange - that will hold the date portion of my query, the variable ...
- Thu Sep 06, 2012 8:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SaveInputRecords and GetSavedInputRecords
- Replies: 3
- Views: 5528
SaveInputRecords and GetSavedInputRecords
Has anyone worked with 8.7 new looping feature of SaveInputRecords and GetSavedInputRecords. I am trying to use this function but all I am getting is an error: APT_CombinedOperatorController,0: Internal Error: (xfer_->initialFixRunLength_f == initialFixRunLength):./../include/apt_internal/api/transf...
- Fri Sep 22, 2006 12:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CLOB / BLOB
- Replies: 3
- Views: 2854
- Fri Sep 22, 2006 9:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating/updating an unique number for each call of the sequ
- Replies: 13
- Views: 5803
- Fri Sep 22, 2006 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting error APT_ORACLE_LOAD_OPTIONS
- Replies: 2
- Views: 2869
- Wed Jul 21, 2004 6:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Starting sequences
- Replies: 3
- Views: 2269
- Wed Jul 21, 2004 6:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Starting sequences
- Replies: 3
- Views: 2269
Starting sequences
I am trying to start a sequence in Datastage for a new instance. I have a development, integration and model environment, and now that I am moving to the model invironment, I want to start a sequence within SDKSequences table at a specific number. I have tried the following:UPDATE SDKSequences USING...
- Tue Jun 29, 2004 5:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do you use SAS in Enterprise Edition
- Replies: 6
- Views: 3812
- Tue Jun 29, 2004 11:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do you access SAS in Enterprise Edition
- Replies: 0
- Views: 792
How do you access SAS in Enterprise Edition
I am still relatively new to DataStage, and we are supposed to have Enterprise Edition version 7.0.1. Can someone tell me how I access SAS in this version. Is there a special plugin that is needed which will make the parallel stage within the Tool menu become active? Everything that I have read pert...
- Tue Jun 29, 2004 11:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do you use SAS in Enterprise Edition
- Replies: 6
- Views: 3812
How do you use SAS in Enterprise Edition
I am still relatively new to DataStage, and we are supposed to have Enterprise Edition version 7.0.1. Can someone tell me how I access SAS in this version. Is there a special plugin that is needed which will make the parallel stage within the Tool menu become active? Everything that I have read pert...
- Mon Apr 12, 2004 12:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Clear a logfile from a command line?
- Replies: 8
- Views: 5019
- Mon Apr 12, 2004 11:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Clear a logfile from a command line?
- Replies: 8
- Views: 5019
Thanks again Kenneth, I have figured out the logs internal file number, but I'm not sure how to delete this log. It's RT_LOG403. When I tried to delete the actual server job, I get the following error: Cannot get excluse access to log for job DWAddress..... which is the name of the job I am trying t...
- Mon Apr 12, 2004 11:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Help needed to kill a "rogue" server job
- Replies: 5
- Views: 2275
- Mon Apr 12, 2004 11:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Clear a logfile from a command line?
- Replies: 8
- Views: 5019
Thanks Kenneth, I have tried that, but the Director just hangs. I wasn't the person who submitted this job, I'm was designated as the Administrator, so I'm left holding the bag, trying to kill this monster. I'm beside myself right about now. I've only worked with DataStage about a month, so this is ...