Search found 42189 matches

by chulett
Fri May 18, 2007 6:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValueConcurrent
Replies: 9
Views: 3347

We're obviously stumbling over the meaning of the word 'recreate'. It means to delete and then create again. This implies the new file would be empty which is why Ray made his comment and which would definitely effect every other sequence that was (formerly) held by that static hashed file. I suspec...
by chulett
Fri May 18, 2007 6:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Current Timestamp in to DB2
Replies: 10
Views: 2514

The DB2 stage wants dates in internal format, from what I recall.
by chulett
Thu May 17, 2007 9:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we use the output of one reference input in the other?
Replies: 5
Views: 1190

Why did you mark the job type as Parallel? That's what led to the confusion, at least for some people.

I already explained the 'how' for a Server job.
by chulett
Thu May 17, 2007 9:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to open job
Replies: 9
Views: 3022

Did you not have any luck searching? It's all out there, having been discussed in detail many times before this. Why make someone type it all up again? ps. For it to 'take effect' you need to be cleaning up either your own processes or doing it as dsadm. But then if you'd searched and done some self...
by chulett
Thu May 17, 2007 8:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to open job
Replies: 9
Views: 3022

First rememdy would be to search here for your message 'accessed by another user'. I got 48 matches where this topic has been discussed, I'm sure you'll find an appropriate answer out there.
by chulett
Thu May 17, 2007 7:14 pm
Forum: General
Topic: Is anyone using DataDirect XML products with DataStage?
Replies: 10
Views: 2613

Never did and never will! :lol:
by chulett
Thu May 17, 2007 6:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Repository Interface error
Replies: 9
Views: 5433

Good to know.
by chulett
Thu May 17, 2007 6:09 pm
Forum: General
Topic: Is anyone using DataDirect XML products with DataStage?
Replies: 10
Views: 2613

Well, maybe Uncle Ernie will wander in to our little Holiday Camp and give us his two cents on the issue. :wink:
by chulett
Thu May 17, 2007 5:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Repository Interface error
Replies: 9
Views: 5433

The reason the new project was created was to eliminate the 'runtime error 6' everyone was apparently getting, which was preventing them from turning off tracing.
by chulett
Thu May 17, 2007 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we use the output of one reference input in the other?
Replies: 5
Views: 1190

Doh... in the Server forum, you'll more than likely get a Server answer.
by chulett
Thu May 17, 2007 5:06 pm
Forum: General
Topic: Is anyone using DataDirect XML products with DataStage?
Replies: 10
Views: 2613

:lol: Guess I should have used a different verb as I didn't mean literally that is was unsolicited - I opted in to their mailing list. It's just that they are very proud of their tools, it seems.

So, you've had no need to worry about large volumes of XML? Or pondered life beyond the XML Output stage?
by chulett
Thu May 17, 2007 3:36 pm
Forum: General
Topic: Problem while working with dsjob command.
Replies: 1
Views: 1130

You need to 'source' dsenv first:

Code: Select all

cd $DSHOME
. ./dsenv

Then things will work more better.
by chulett
Thu May 17, 2007 12:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we use the output of one reference input in the other?
Replies: 5
Views: 1190

Possible but not really recommended. You have to define it manually as it can't be done via dragging within the GUI. And it will always stay red, so you'd want to include an annotation that you were doing that on purpose and expecting the 'looks like an error' result.
by chulett
Thu May 17, 2007 12:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Manipulate Job Parameter
Replies: 3
Views: 1059

I never use a single parameter to encompass a complete filename, always two - specifically because they are not easily manipulated inside jobs. They are, however, easily combined. You'd have to do that outside of the job. For example, a Sequence job could use substrings like you noted (or the Field ...
by chulett
Thu May 17, 2007 10:28 am
Forum: General
Topic: unix command to see these incomplete records
Replies: 4
Views: 1423

You'll have to gunzip the file and pipe the output to awk.