Search found 42189 matches

by chulett
Fri Feb 08, 2008 2:58 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Datastage job as service
Replies: 19
Views: 12982

In other words, unless you have an 8.x version you need to purchase RTI/SOA in order to expose jobs as services.
by chulett
Fri Feb 08, 2008 12:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs not running
Replies: 20
Views: 3913

:shock: Oh my, not even close to what you needed to do. Drop the test project, recreate it empty and then populate it from a production export.
by chulett
Fri Feb 08, 2008 12:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs not running
Replies: 20
Views: 3913

Re: Jobs not running

47shailesh wrote:I have recently refreshed Project from Production in Testing env.

Explain to us exactly how you did this 'refresh'.
by chulett
Fri Feb 08, 2008 10:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Char to Timestamp
Replies: 18
Views: 4118

What happened to the %s?
by chulett
Fri Feb 08, 2008 9:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OPTIMIZATION
Replies: 5
Views: 1132

Not sure why people seem loath to do this, but go have a chat with your DBA. They LOVE helping with stuff like this. :wink:
by chulett
Fri Feb 08, 2008 7:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Testing a hash, want to do a single lookup and write result
Replies: 2
Views: 853

So... no questions, just a post to let us know things you're trying? :wink:

ps. A 'reference lookup' doesn't count as an 'input link', hence your need for a second transformer.
by chulett
Fri Feb 08, 2008 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After job subroutine
Replies: 7
Views: 2014

Exactly. If/when that fixes your problem, please mark the topic as Resolved. :wink:
by chulett
Fri Feb 08, 2008 7:41 am
Forum: General
Topic: DB2II apply job passing row data to DS job
Replies: 4
Views: 1736

'Real time' would imply the need for whatever they call SOA/RTI nowadays in 8 - I don't recall the new acronym. :?

Seems like you would be able to build an RTI enabled job, which could run continuously and process those messages in real time.
by chulett
Fri Feb 08, 2008 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer stage at the begining of a Job
Replies: 11
Views: 2643

I'd be careful there. Anything that resolves to 'true' is the same as not having a constraint and - in a Server job at least - will result in an 'infinite' number of records generated. I would suggest something specific, like:

Code: Select all

@OUTROWNUM=1
by chulett
Fri Feb 08, 2008 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mathematics in ExecSh
Replies: 7
Views: 999

I can read. Still unclear as there's no specific mention of any script. Sounded to me that all they put in the 'Input Value' field after setting the 'After-job subroutine' to ExecSH was 'parameter+1'. Hence the rather generic answer I gave in the hopes of garnering something more specific when that...
by chulett
Fri Feb 08, 2008 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to Schedule from director...
Replies: 2
Views: 1366

They'll know this, but specifically your scheduling user needs to be added to 'cron.allow' and 'at.allow'.
by chulett
Fri Feb 08, 2008 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resetting a job
Replies: 13
Views: 3181

Even though the job is in aborted state and if we try to reset it knowing that we dont have c++ compilers not installed,will it get reset and will execute properly ? Asked and Answered. More than once. Yes. But in this regard, When i try to reset the aborted job ,I am facing the Error Messsage as :...
by chulett
Fri Feb 08, 2008 7:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple value in job parameter
Replies: 11
Views: 3283

Director log (OSH script) doesn't show the final SQL, it shows the SQL with parameter. If we were discussing a Server job here, that - the 'non translation' of a job parameter in the logs - would imply the parameter name didn't exist in the job. Is the same not true here? How, in a PX job, does one...
by chulett
Fri Feb 08, 2008 7:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to pass two values from parameter
Replies: 4
Views: 876

As noted, on the surface that should work just fine. We'd need specifics of the problem/abort to be able to help.