Search found 42189 matches

by chulett
Thu Apr 03, 2008 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Parameter Copy
Replies: 2
Views: 800

Our Ken Bland gives away a solution for this from his website, part of the utilities in his Job Control Utilities suite.
by chulett
Thu Apr 03, 2008 7:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Hint on a partitioned table
Replies: 3
Views: 1401

Basically the same way it does on a non-partitioned table. This is a conversation best had with your Friendly Neighborhood DBA Man. And it's not "concurrent servers" but rather threads.
by chulett
Thu Apr 03, 2008 7:43 am
Forum: General
Topic: How to Call Java Program in Data Stage
Replies: 2
Views: 1054

Unless you can give more details about your 'want', the only answer is to search the forum for JAVA PACK to find other conversations on this subject.
by chulett
Wed Apr 02, 2008 11:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Changes of parameters in admin,not relected in job
Replies: 9
Views: 2579

What default value are you using in your jobs - the actual value from the Administrator or $PROJDEF?
by chulett
Wed Apr 02, 2008 11:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parameters to pass through ConvertWeek()
Replies: 4
Views: 1356

Open the ConvertWeek function in the Manager - the General tab details what to pass as the second argument.
by chulett
Wed Apr 02, 2008 6:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: invoking ETL job from Java program
Replies: 2
Views: 756

Sure, it has even been discussed here several times from what I recall. Searching the forums all terms - "java dsjob" - should turn them up, I would think.
by chulett
Wed Apr 02, 2008 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: field mapping
Replies: 5
Views: 1138

Or - inside transformer1, select all then copy. Open transformer2, paste.
by chulett
Wed Apr 02, 2008 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help reagrding External source stage
Replies: 7
Views: 1318

When XML goes into an XML Input stage but doesn't come back out, it usually means your XPath Expressions are incorrect.
by chulett
Wed Apr 02, 2008 7:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reste the Surrogate File
Replies: 6
Views: 1084

You are going to have to explain what you mean by 'surrogate file'. Exactly what mechanism are you using to generate your surrogates?
by chulett
Tue Apr 01, 2008 8:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob (-jobinfo works, but -run does not)
Replies: 30
Views: 7894

Never mind, googling for 'chgrp operation not permitted' enlightens us - you must be a member of the group to have permissions to change the group. Or be root, of course.
by chulett
Tue Apr 01, 2008 8:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob (-jobinfo works, but -run does not)
Replies: 30
Views: 7894

Ah, so just the 'operation not permitted' part then. Still, what O/S?
by chulett
Tue Apr 01, 2008 8:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob (-jobinfo works, but -run does not)
Replies: 30
Views: 7894

Odd.. is that literally the error - 'each/and/every/file'? If so, that's not something I've seen before, what flavor of UNIX are you running? :?
by chulett
Tue Apr 01, 2008 8:15 pm
Forum: General
Topic: date function : routines
Replies: 13
Views: 5794

Uncheck the one you have listed as 'b'.
by chulett
Tue Apr 01, 2008 8:09 pm
Forum: General
Topic: job statistics
Replies: 1
Views: 982

Been discussed quite alot here and implemented in various fashions at quite a number of sites, I'm sure. Best thing to get you started is to take advantage of all of the work Kim Duke has done and offers free to users here - download ETLStats from the tips page on his website.