Search found 42189 matches

by chulett
Mon Feb 23, 2009 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is dscc.exe reliable?
Replies: 16
Views: 5887

OK, I was assuming a standard 'looking up from the same hashed file being updated' scenario, all from one transformer. You can't do the normal creation / clearing in the write link as the reference lookup happens first. Now that I've reread your original posts and see the job design, I don't see any...
by chulett
Mon Feb 23, 2009 8:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Derivation
Replies: 6
Views: 1982

:lol:

Yah, yah Mr Henry... give me Perl or give me death.
by chulett
Mon Feb 23, 2009 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unexpected termination of Designer
Replies: 3
Views: 1553

Check with your support provider, that's a known issue with a patch available.
by chulett
Mon Feb 23, 2009 8:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is dscc.exe reliable?
Replies: 16
Views: 5887

Right... and no need for a separate job, I always add that link to the using job, connected to the lookup hashed file. And most importantly - left trouser leg. :wink:
by chulett
Mon Feb 23, 2009 8:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Derivation
Replies: 6
Views: 1982

Or push the button in the Designer that looks like the IE icon, it will generate an HTML document with everything in the job.
by chulett
Mon Feb 23, 2009 8:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML input Stage Error
Replies: 14
Views: 7259

Then you're chock full o' bugs... better get patching. :wink:
by chulett
Mon Feb 23, 2009 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to use comman table expression(Inline view) in ODBC Stag
Replies: 23
Views: 7110

Then it's time to mark this post as Resolved using the button at the top of the screen, it seems.
by chulett
Sun Feb 22, 2009 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing rows Per second
Replies: 6
Views: 1607

AFAIK, you'll need to compute that yourself from the elapsed time of the job run and your count.
by chulett
Sat Feb 21, 2009 9:08 pm
Forum: General
Topic: how to get previous month value from given date vaule
Replies: 3
Views: 1302

Ray has some pre-built Server date handling routines he loves to give away. As they say 'Why reinvent the wheel?' :wink:
by chulett
Sat Feb 21, 2009 6:14 pm
Forum: General
Topic: How to get "day" from given "date"
Replies: 3
Views: 1230

Then please mark the post as Resolved using the button at the top of the screen.
by chulett
Sat Feb 21, 2009 8:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Format output of a date
Replies: 10
Views: 2814

Ah... my Parallel docs are 7.5 vintage.
by chulett
Sat Feb 21, 2009 8:32 am
Forum: General
Topic: How to get "day" from given "date"
Replies: 3
Views: 1230

The needful is documented in the online help. Read about the 'D' code for OConv() with the format option WA to get the full weekday name.
by chulett
Sat Feb 21, 2009 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Format output of a date
Replies: 10
Views: 2814

Perhaps "does not provide an example of" doesn't mean the docs are bad but rather that it doesn't exist. Where did you find a reference to %mmmm? As noted, it's nowhere to be found in the pdf docs. Guys, how does one convert that '01' in the example date to 'January' rather than 'Jan'? You...
by chulett
Fri Feb 20, 2009 5:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How much time CLEAR command takes to clear RT_LOG of 2 GB
Replies: 7
Views: 2950

Hmmm... I've done CLEAR.FILE on overblown corrupted logs and don't recall it every having a problem. But then perhaps I just got lucky. Or my memory is shot. :wink: