Search found 42189 matches

by chulett
Mon Aug 16, 2004 8:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: db2setup
Replies: 4
Views: 1098

In other words, it's only applicable to PX? :?
by chulett
Mon Aug 16, 2004 8:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: non-root install
Replies: 6
Views: 2562

There have been a couple of other posts on the topic of a non-root install and both were discussing problems when doing so on Solaris, from what I recall. Here is one example. The consensus seemed to be that, in spite of the fact that you can do one now, you should stick with a root install.
by chulett
Mon Aug 16, 2004 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using JOB parameters in Email Notification Activity Stage
Replies: 10
Views: 4443

You know, sitting here and thinking about it... you may be right. From previous conversations here or on ADN, I think that it did work - but only on one specific platform and that probably by accident. What they've finally done is address the issue and made it work across all platforms in the manner...
by chulett
Mon Aug 16, 2004 7:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can you move ur project from development to production
Replies: 6
Views: 1448

Exactly. A search of the forum for "Version Control" will yield many posts on the subject... most of them actually helpful. And you do have it, even though it is not installed by default. In version 6 you needed to 'explore' and find in on your cdrom yourself. In newer versions they finally included...
by chulett
Mon Aug 16, 2004 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Character Set Problem in ORAOCIBL
Replies: 7
Views: 2022

We see from the installation notes that NLS is not supported in version 6.0. What do we do now? Your only option (other than ganging up on your DBA) is to upgrade. I'd suggest the highest version that supports NLS. 7.5 is available and I'm pretty sure it supports it. Craig, can you ask Ascential su...
by chulett
Sun Aug 15, 2004 8:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Question On lookup
Replies: 1
Views: 742

If I am following how your job is setup, your problem is more than likely due to a lack of NULL handling. One important thing to recognize is the fact that, when a lookup fails, the values in the lookup record are NULL. This is assuming you have defined a specific key (like country_id) in your OCI s...
by chulett
Sun Aug 15, 2004 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine return status in sequencers
Replies: 2
Views: 926

It's always been this way, the new feature in 7.5 just makes it easier for you shoot yourself in the foot. As Ray said, Routines don't have an exit status, the return value is what is checked. That's why you can't use the normal Trigger types with Routines in a Sequencer or simply check off that new...
by chulett
Sat Aug 14, 2004 2:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Finding whether a Feild is null or not
Replies: 4
Views: 1115

All questions about why it's a "must" and you "need" to do it this way aside... It seems to me your question is not so much about determining if a field is null or not. That's simple and no different than you'd do in a Derivation inside a job. What it looks to me what you are doing is reading a flat...
by chulett
Sat Aug 14, 2004 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to open a job
Replies: 2
Views: 892

Ahmed, welcome. This is a very common question, so the first thing I'd suggest you do is check out the 'Search' functionality of the forum. You should be able to find a ton of different answers to pick from. After you do that, come back with more questions. Oh, and beware of the generic answer to do...
by chulett
Sat Aug 14, 2004 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need Details of [b]Sort[/b] Stage
Replies: 2
Views: 886

You should be able to put your cursor in each field, one at a time, and while it's there click on the 'Parameter Help' button. This will give you specific help about that field. You can do this in any stage, actually. Heck, you can set this up so you can do it for your own Job Parameters if you like.
by chulett
Sat Aug 14, 2004 7:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: increment data
Replies: 7
Views: 1871

If CDC is not an option, then check out this post on the subject of CRC32 and CDD. It's a way to tell if something has changed without having to rely on it being "captured" for you.
by chulett
Fri Aug 13, 2004 11:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: increment data
Replies: 7
Views: 1871

I'm going to guess what it is you are asking for. :? Try searching the forum for the following terms:

CDC or the phrase "Change Data Capture"
CDD or the phrase "Change Data Detection"

Let us know if that helps...
by chulett
Fri Aug 13, 2004 11:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: deleting dependant table rows
Replies: 7
Views: 1802

That's because it's something called a "Paragraph", one of those secret Universe under the covers type things. :wink:

Check out this post where Ray and Ken explained it all for me.
by chulett
Fri Aug 13, 2004 10:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using JOB parameters in Email Notification Activity Stage
Replies: 10
Views: 4443

Nope, never been there. From the readme for 7.5: Job Sequencer ------------- A number of enhancements have been made to the Job Sequencer at this release: - Additions to Notify Stage The Notification Activity can now send attachments. Multiple attachments are also supported. All fields may include p...
by chulett
Fri Aug 13, 2004 9:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: convert hex to integer
Replies: 4
Views: 1817

Kind of an odd time for you to be posting Ray... airport lounge again? :wink: