Search found 42189 matches

by chulett
Wed Feb 25, 2009 11:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data getting added in CDC stage
Replies: 11
Views: 2363

Suggest... patience.
by chulett
Wed Feb 25, 2009 11:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strip Chars at the end and not in middle
Replies: 9
Views: 3241

Why don't you post the Server routine code, then people could comment on how to do the equivalent in EE.
by chulett
Wed Feb 25, 2009 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

Your problem is right there in the error message, a job cannot attach to itself. If you really need to do that, skip the attach and use DSJ.ME as the job handle.
by chulett
Wed Feb 25, 2009 8:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting default values in the job parameters
Replies: 5
Views: 1807

And by the API, that means a call to DSGetParamInfo().
by chulett
Wed Feb 25, 2009 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Stage and Link Names in a Job
Replies: 3
Views: 2330

Take the list of job / stage names and then query for the link names, either using 'dsjob -llinks' or DSGetStageInfo() can return a 'link list'.
by chulett
Wed Feb 25, 2009 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing sql query as parameter
Replies: 8
Views: 1869

Edit: Never mind, I misread the post. [sigh]
by chulett
Wed Feb 25, 2009 8:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert date value into SQL Server datetime columm
Replies: 31
Views: 22296

That sounds like Oracle advice. :?
by chulett
Wed Feb 25, 2009 8:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

You need to figure out exactly where things go wrong. Add breadcrumbs... calls to DSLogInfo() after every step and see where the trail ends.
by chulett
Wed Feb 25, 2009 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: fork error
Replies: 2
Views: 1687

Or perhaps under-configured. Chat with your SysAdmin.
by chulett
Wed Feb 25, 2009 8:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Time Conversion
Replies: 3
Views: 1530

Then... Resolved?
by chulett
Wed Feb 25, 2009 8:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log Corrupted
Replies: 15
Views: 5197

Ripley: I say we take off and nuke the entire site from orbit. It's the only way to be sure. :wink:
by chulett
Wed Feb 25, 2009 8:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log Corrupted
Replies: 15
Views: 5197

Ripley: I say we take off and nuke the entire site from orbit. It's the only way to be sure. :wink:
by chulett
Tue Feb 24, 2009 11:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Time Conversion
Replies: 3
Views: 1530

You need to load this into what datatype in Oracle? There's no "time" type, so what... DATE? TIMESTAMP? VARCHAR2? Only the latter will take a "time" value with no correspoding date associated with it.