Search found 15 matches

by jmperezrus
Tue Sep 19, 2006 2:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 6578

Thanks everyone for your posts...

I have finally created a routine that removes these null characters in-between strings by using Seq function...

Best regards
Jose
by jmperezrus
Tue Sep 05, 2006 4:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 6578

Thanks Kumar but I think that by doing that I could create problems with all the null handling I have done so far in the project...
by jmperezrus
Tue Sep 05, 2006 8:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 6578

Yes, I did... Sorry I did not mention it. Result was 10...
by jmperezrus
Tue Sep 05, 2006 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 6578

Thanks Kumar.

I have actually tried that and the returned value for LEN is 10. I know, weird... My field has ten "00 00 hex" characters and its "LEN" is 10. Therefore I cannot distinguish valid registries from these null ones by using that function...
by jmperezrus
Tue Sep 05, 2006 6:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 6578

Thanks for your post Ray.
I can't read the whole post though...

Anyway, I must use "Continue" in the lookup, cause I want to keep those registries.

What I actually get is a string with 10 null (00 00 hex) characters (the field is a char 10).

Any other ideas? Please...
by jmperezrus
Mon Sep 04, 2006 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 6578

Help with Lookups

I am going nuts with this guys... your help will be much appreciated. What is the output of a Lookup stage (parallel) if no results are found matching the input? If we select "View data" it appears like a "null" value for this field, or like a 0-length string. Obviously these are...
by jmperezrus
Wed Aug 23, 2006 12:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error compiling generated subroutine for stage
Replies: 7
Views: 5567

Hi everyone,

The problem has been fixed. How? Restarting my PC and trying to compile again. That's it.

Thanks for your help & best regards
by jmperezrus
Wed Aug 23, 2006 12:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error compiling generated subroutine for stage
Replies: 7
Views: 5567

Yup, as you reckon I have tried by "rebuilding" the same job. It was not hard to do since there is almost no code involved, as I said the derivations are direct copies of input links. I have just noticed that the same issue comes up for other jobs in the same folder... And they are pretty ...
by jmperezrus
Wed Aug 23, 2006 11:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error compiling generated subroutine for stage
Replies: 7
Views: 5567

Thanks Kris,

Actually, as I said there are not any numerical operations. The only derivations are direct copies from input fields (drag&dropped)

Thanks anyways...
by jmperezrus
Wed Aug 23, 2006 11:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error compiling generated subroutine for stage
Replies: 7
Views: 5567

Error compiling generated subroutine for stage

Hi guys, I get this error everytime I try to compile a job. The error relates to a transformer stage. I have checked EVERYTHING (constraints, variables,...). I have even written trivial derivations (with no routines involved, just mapping directly from input fields) I have even tried to rebuild the ...
by jmperezrus
Wed Jun 07, 2006 7:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot edit any stages within a Job Sequence
Replies: 11
Views: 5143

Hi everyone,

Finally I have found the patch in ascential's page, and it works fine.

Thanks guys for your support!
by jmperezrus
Wed Jun 07, 2006 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot edit any stages within a Job Sequence
Replies: 11
Views: 5143

Hi again,

I can't find the link on eServices... Can anybody tell me the ECASE ID or the link itself?

Cheers
by jmperezrus
Wed Jun 07, 2006 1:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot edit any stages within a Job Sequence
Replies: 11
Views: 5143

Thanks chulett, I have been investigating and I have come to the conclusion that it has to do with Service Pack 2.... I know that everything would be ok if I just re-installed, but I like getting to the bottom of things :) Plus, it can get a bit annoying having to reinstall from time to time, so cou...
by jmperezrus
Tue May 30, 2006 8:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot edit any stages within a Job Sequence
Replies: 11
Views: 5143

Hi,

Thx for your reply.

I have tried what you suggest but nothing happens.

I don't think this is the problem because I have more RAM than other PCs and I do not have any other programs running...

The monitor DPI settings are "Normal", so I guess this is not the issue either...
by jmperezrus
Tue May 30, 2006 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot edit any stages within a Job Sequence
Replies: 11
Views: 5143

Cannot edit any stages within a Job Sequence

Hi everyone, When I double click on any stage contained in a Job sequence, nothing happens. Neither it does if I select "Properties" on the right-click menu. However, everything was OK some days ago. It's even OK if I use another PC, what makes me believe that it has to do with some file t...