Search found 42189 matches

by chulett
Fri Feb 22, 2008 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Table Definition to an Excel File
Replies: 3
Views: 1692

Not that I've seen. You can, however, get an HTML file - double-click on the table def, swith to the Layout tab and right-click.
by chulett
Fri Feb 22, 2008 1:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: concatenate
Replies: 7
Views: 1890

Spell your requirements out in words. That would help both us and yourself as well.
by chulett
Fri Feb 22, 2008 1:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Count for always run job
Replies: 6
Views: 1635

So, I take it you don't have a "load/modification date" in the target table, something you could query on to get a daily count?

Link counts aren't going to help you if the job runs constantly... unless you take a delta from day to day, of course.
by chulett
Fri Feb 22, 2008 12:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error
Replies: 5
Views: 1864

Could you let us know which particular values, please? That and mark the post as 'Resolved'? Thanks!
by chulett
Fri Feb 22, 2008 12:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UVCONFIG T30
Replies: 2
Views: 1618

If it was, you would be getting a 'T30 specific' message. For example:

Unable to allocate Type 30 descriptor, table is full
by chulett
Fri Feb 22, 2008 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting NULL records even after defining constraint
Replies: 19
Views: 3984

Yes, please try to keep up. And note that there's no "if-then-else" in Arnd's constraint, no "then N else Y' or "then @TRUE else @FALSE" as that is completely unnecessary. These are expressions and they will automagically evaluate to true or false if you let them - and you should let them do so if a...
by chulett
Fri Feb 22, 2008 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Master Sequence is not restartable
Replies: 19
Views: 5587

Re: Master Sequence is not restartable

But still if any of the subsequence S1, S2 or S3 fails then the master sequence M1 is not getting aborted, but is showing Finished(See Log) Interesting thought. I've been assuming that the 'fails' mentioned above means 'aborted' but perhaps that's not the case. If the "sub-sequences" don't abort th...
by chulett
Fri Feb 22, 2008 8:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in Hash file
Replies: 12
Views: 3003

2048. Tell us why you think you would need a key size that large. What are you trying to accomplish?
by chulett
Fri Feb 22, 2008 8:12 am
Forum:
Topic: mismatch between imported metadata and that in the source
Replies: 5
Views: 2229

Known 'issue', use the Orchestrate orchdbutil utility instead to import the metadata instead.
by chulett
Fri Feb 22, 2008 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running: Not getting completed
Replies: 6
Views: 1704

500, I do believe, but still...
by chulett
Fri Feb 22, 2008 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to manage two Client Oracle
Replies: 4
Views: 1220

Re: How to manage two Client Oracle

In the meantime, while we wait - can you please explain what you mean by this? we need to install two Oracle client on DataStage Server to implement a secure connection. What do you mean by 'secure connection'? And are you saying that some jobs will need to use one client and some jobs will need to ...
by chulett
Fri Feb 22, 2008 8:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cleanup resources option in director
Replies: 3
Views: 1103

I thought you meant that nothing was showing up, are you saying only the pids of certain jobs are not showing up? :?
by chulett
Fri Feb 22, 2008 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS Issue with Orcale Enterprise stage
Replies: 1
Views: 2320

Re: NLS Issue with Orcale Enterprise stage

I strongly believe that the NLS Settings for Oracle and DataStage should be in sync. Not necessarily. Only do this is you are sure the incoming data is appropriate for the NLS setting of the database. Setting them to be the same will mean no conversion is done during the load which could lead to 'c...
by chulett
Fri Feb 22, 2008 7:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Master Sequence is not restartable
Replies: 19
Views: 5587

You need to open a case with your Support provider. The need for all that triggering and explicit abort handling went out the window when the 'Automatically handle' options came on the scene. The simple 'OK trigger only' flow should do exactly what you need - I do this many places in our 7.5.x relea...
by chulett
Fri Feb 22, 2008 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSSendMailTester Rouitne
Replies: 3
Views: 2555

Ugh. Why not write the bad vaules to a file, then send one email after the job completes if the file is populated rather than sending an email for every bad record? :?