Search found 42189 matches

by chulett
Tue Sep 22, 2009 5:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Deletion Unsuccessful
Replies: 14
Views: 3446

chulett wrote:contact your official support provider, something I think you'll need to do regardless now that you've manually deleted
even more of the project.
by chulett
Mon Sep 21, 2009 6:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD MLOAD truncating 11th character of CHAR(11) input -- why?
Replies: 5
Views: 2138

This sounds... familiar. Perhaps a carefully chosen search would turn something up.
by chulett
Mon Sep 21, 2009 6:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating a Reserved Word/Variable
Replies: 12
Views: 4161

I guess that is indeed what I'm proposing, assuming you're still going the way you asserted earlier and using job parameters that are set to $ENV as their default value. There's no reason to pass them in on the command line in that case and if the script can set them in the job's environment painles...
by chulett
Mon Sep 21, 2009 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help needed converting oconv to PX
Replies: 5
Views: 1997

Can't be much help with your query but more confusing were the responses, where does date conversion come in to it? No clue, I only added my date comment after the first response specifically complained about not having IConv/OConv to do dates in PX. :? And yes, should have mentioned the same thoug...
by chulett
Mon Sep 21, 2009 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating a Reserved Word/Variable
Replies: 12
Views: 4161

You still shouldn't have to "resolve these in each controlling sequence" if by "resolve" you mean "set". Still unclear what you have in place in the way of job control, meaning I'm still wondering what is actually running your sequence jobs across your enterprise. If it...
by chulett
Mon Sep 21, 2009 11:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does DB2 Enterprise stage work on different domains?
Replies: 9
Views: 4835

I would think that they are but honestly I can't say for sure. You'd probably need to confirm or deny that with your official support provider.
by chulett
Mon Sep 21, 2009 11:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine source
Replies: 6
Views: 1412

:oops: Saw all those other ".H" files there and forgot they stuck the ones you're looking for off in each project directory for some reason:

./dsinclude/JOBCONTROL.H
by chulett
Mon Sep 21, 2009 10:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine source
Replies: 6
Views: 1412

Sure, it's in the $DSHOME/INCLUDE directory.
by chulett
Mon Sep 21, 2009 10:01 am
Forum: General
Topic: IBM IOD discount
Replies: 1
Views: 809

Oddly enough, my code is G09HULETT if anyone would like to use it to save 100 smackers US. :wink:
by chulett
Mon Sep 21, 2009 9:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error when using DSJobReport in After Job
Replies: 3
Views: 2708

Looking at the routine code, you'll see you've gotten past the "open" step to the actual writing step, which to me would typically mean a permissions or space issue there. Any chance that filename already exists there? (probably not seeing as now it is timestamped) Can you try putting Exec...
by chulett
Mon Sep 21, 2009 9:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Job Runtime error
Replies: 3
Views: 1272

:? Go to Search, make sure Exact Search is selected and search for "This Jobtype is not currently runnable on this platform" - you'll get 19 matches.
by chulett
Mon Sep 21, 2009 9:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot Stage
Replies: 3
Views: 1429

Simple enough to manually add the 'phone_type' columns (x3) to the data before the pivot and then drop any pivoted rows where the number was null post-pivot.
by chulett
Mon Sep 21, 2009 9:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: link collector
Replies: 11
Views: 5098

Your best bet is to optimize the source query and presize the hashed file (Minimum Modulus) properly.
by chulett
Mon Sep 21, 2009 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delete records in a dataset based on a key
Replies: 2
Views: 1273

I don't believe so, AFAIK you'd need to create a job to copy the dataset and drop the records you no longer needed during the process.
by chulett
Mon Sep 21, 2009 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: project locked
Replies: 9
Views: 1893

That's your problem, then, the old projects are gone and I would assume you'll need to reinstall the 7.5 version. Best to check with your official support provider and I hope you have a backup.