Search found 42189 matches

by chulett
Fri Oct 01, 2004 7:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Level Environment Variables ---------
Replies: 12
Views: 4667

andru wrote:Just FYI. I'm working on Version 7.1r1. Encrypted parameters works fine for me.

In general, they do work just fine. It's just that, once in a great while, it will break for a particular job. When it does, nothing short of changing the parameter type to 'String' seems to help. It's... very odd.
by chulett
Thu Sep 30, 2004 7:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Level Environment Variables ---------
Replies: 12
Views: 4667

Really? I'll have to double-check as I don't recall seeing that. It would be nice, as I too have seen this problem. You aren't doing anything wrong, it's just a plain old B-U-G that's been around for several versions now. No clue what triggers it, but when it happens it can be extremely frustrating ...
by chulett
Thu Sep 30, 2004 4:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Testing User Name/Password in DS Administrator
Replies: 5
Views: 1392

ray.wurlod wrote:It CAN make a difference, for example if the same name is used for different things.

Yup, said that.

Didn't have a clue about the "idiosyncratic malloc" issue, will have to keep that in mind if I ever contemplate loading GCI functions. :wink:
by chulett
Thu Sep 30, 2004 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Joins with Hash
Replies: 4
Views: 1119

But you can use an expression in the Key value field. A simple If-Then-Else expression can put the link data into the key if is "not empty", otherwise it can use a default value to do the lookup. Or you could do this in two lookups to the same hash, one using row data in the keys and one using defau...
by chulett
Thu Sep 30, 2004 2:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to construct external null string
Replies: 5
Views: 2863

And '000' is a null. Some options interpret that to mean "I don't want this", but not the Padding character in the Sequential file stage.
by chulett
Thu Sep 30, 2004 12:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple DataStage Server instances on one Machine
Replies: 11
Views: 2882

kcbland wrote:Technically yes, but, how are you going to attach to both instances from your PC client?

That wasn't the question asked. :wink:

and then kcbland wrote:Aaaarrghhh, this thread only needed a 1 word response: NO.

Perhaps two words: Yes But.

Your teapot seems to be running at a rolling boil today, Ken. :lol:
by chulett
Thu Sep 30, 2004 11:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple DataStage Server instances on one Machine
Replies: 11
Views: 2882

As you said, I'm sure that by "multiple instances" they either meant multiple projects and/or multiple servers.
by chulett
Thu Sep 30, 2004 10:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple DataStage Server instances on one Machine
Replies: 11
Views: 2882

Starting witn 7.x it is possible to run simultaneous server instances. You need to manipulate the "id" associated with them... whatever it is called. You know, the thing that defaults to "ade". That and the port for the dsrcpd daemon.
by chulett
Thu Sep 30, 2004 10:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple DataStage Server instances on one Machine
Replies: 11
Views: 2882

It's been discussed before, I think most recently at ADN. It can be done, is a little on the painful side and would typically involve different versions of the server running at any one time. The question would be why you are looking at doing this? If you state what it is you are trying to accomplis...
by chulett
Thu Sep 30, 2004 8:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how generate new row with incrementing data for column
Replies: 4
Views: 1148

ashok wrote:it is not needed

What is not needed? :? If that's the answer to my qestion, then... ok, cool.

On the subject of stage variables, perhaps this post will help.
by chulett
Thu Sep 30, 2004 8:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Denormalizing Data
Replies: 7
Views: 2301

Just as an FYI for those in our studio audience using Oracle as their database of choice, there is actual "Full Outer Join" syntax available in 9i:

Code: Select all

SELECT a.x, b.x
FROM a FULL OUTER JOIN b
ON (a.y = b.y)
by chulett
Thu Sep 30, 2004 6:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Testing User Name/Password in DS Administrator
Replies: 5
Views: 1392

Interesting. That... shouldn't have mattered. It still should have been able to find it. Unless you've got something else called ATTRIB that it found in a directory before the system32 directory was looked in. Or there was something wrong with the syntax of that entry before you moved it, but that w...
by chulett
Thu Sep 30, 2004 5:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how generate new row with incrementing data for column
Replies: 4
Views: 1148

Well, I would think two things would help here. The Pivot stage to do the 'interesting' pivoting you are doing. That and a pair of Stage Variables. One that you would increment based on Customer ID changes and another to hold the old value so you could know when it changed. In that order. Would "100...
by chulett
Wed Sep 29, 2004 4:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Copy forward a record
Replies: 8
Views: 1153

Compilation Error : Job contains cyclic or linear dependendiews and will not run. You would need to post a "picture", as best you can, of your job. This error basically means you've created a "loop" in your process. If you use the Code tabs and the Preview option, you can generally get something fa...
by chulett
Wed Sep 29, 2004 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help needed with BW Extract Pack
Replies: 6
Views: 2017

Do you have a support agreement? You could always call Ascential Support and run your question by them...