Search found 42189 matches

by chulett
Tue Jul 27, 2004 6:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Putting Datastage 7 and Datastage 5 Client's on the same m/c
Replies: 7
Views: 1874

anupam wrote:It is situated under utilities/unsupported.

Starting with 7.5 there is a 'supported' version of the Client Switcher utility with a slightly different name that I don't recall off the top of my head.
by chulett
Tue Jul 27, 2004 6:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup with wildcard
Replies: 8
Views: 3162

Instead of going the wildcard route, why don't you try breaking your TAB2 lookup hash into single records so that it's no longer a concern? Do you know how many (maximum) number of entries can be in a single record? Break them up during the loading process with the FIELD function and write each one ...
by chulett
Mon Jul 26, 2004 6:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Tuning.
Replies: 3
Views: 1375

Check this post for a very interesting way to do what it sounds like you are doing with UV stages in a hash stage instead. Takes a little bit to setup but very speedy stuff.

Or you may just need to build indexes for your hashed key columns... are they indexed?
by chulett
Mon Jul 26, 2004 6:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is ARRAY Size
Replies: 4
Views: 1386

That's too bad. :? You could check out the same items on an OCI stage for instance, I know they are all listed there.
by chulett
Mon Jul 26, 2004 5:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is ARRAY Size
Replies: 4
Views: 1386

What happens when, with the DRS Stage open, you click the 'Help' button? Unless they've screwed something up, it should open up the online help for the stage such that you'd be able to look up the meanings of all of the check boxes and input areas in it. Simple put, Array Size is how many records at...
by chulett
Mon Jul 26, 2004 5:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Looking up a Space in a Hash file
Replies: 3
Views: 1073

Are any of these 'space' fields keys in your hash file? I'm guessing that's the case if they are involved in the success or failure of your lookup. Are you sure you've trimmed or not trimmed or done whatever needs to be done to ensure that the 'space-ness' of the fields is not changed so the lookup ...
by chulett
Mon Jul 26, 2004 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg Iconv and Oconv
Replies: 4
Views: 3250

You can use them in a BASIC Transformer from what I understand, said the Server guy. :wink:
by chulett
Mon Jul 26, 2004 12:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Backing out an upgrade
Replies: 5
Views: 912

There really isn't any official 'back out this update' capability. Hopefully you've got either a good backup or a full export from your previous version. You are going to need to completely remove the 7.1 version, and then either re-install the 7.0.1 version and re-import your matching export (as Ki...
by chulett
Mon Jul 26, 2004 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Could not access DataStage
Replies: 6
Views: 2010

Hard to say... couldn't hurt! :wink:
by chulett
Mon Jul 26, 2004 7:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Could not access DataStage
Replies: 6
Views: 2010

Well... keep in mind the fact that this will totally clear all of your job logs. And by 'clear' I mean not like you would from the Director, but totally blow away everything in them, including any Auto Purge settings you may have had. There really isn't enough information to make a judgement regardi...
by chulett
Sat Jul 24, 2004 8:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert data
Replies: 3
Views: 817

Wow... all that in one sentence. Unfortunately, I have no idea what kind of specific information you are looking for. I can only make a few comments and inferences. * To 'insert new data so that previous data be overwritten' use one of the Update actions. One does a simple update of the existing rec...
by chulett
Sat Jul 24, 2004 8:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parsing CUST_PHONE
Replies: 4
Views: 1283

Bob - this isn't an IM client, so it's ok to use whole words and complete sentences. Besides, in an international forum it would help people understand your questions - especially those for whom English is not their native tongue. Now, to the subject of parsing a phone number. Check your online help...
by chulett
Sat Jul 24, 2004 8:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 2547

No problem, glad to help! Let us know if you have more questions when you get into the thick of it. :lol:
by chulett
Sat Jul 24, 2004 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dropping records
Replies: 4
Views: 1431

Well... more than likely, because you told it to. Seriously, Transformers don't "drop" records on their own. Records either don't pass through because of a constaint or look like they didn't because they've been rejected by the target stage. I would guess that the later is your case. Need. More. Inf...
by chulett
Fri Jul 23, 2004 11:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 2547

Hmmm... have you created Sequencer jobs yet? They allow you to control the 'flow' of several related jobs / routines / activities and help automate the passing of parameters between or to them. When you add an Activity stage to a Sequencer, you can automate the passing of parameters from either the ...