Search found 42189 matches

by chulett
Mon Sep 01, 2008 11:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to avoid update query
Replies: 10
Views: 3202

How would that help? An update is an update. :?
by chulett
Mon Sep 01, 2008 5:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to mark a job as FINISHED
Replies: 7
Views: 2046

Yes, why are you asking? What problem are you trying to solve?
by chulett
Mon Sep 01, 2008 2:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to mark a job as FINISHED
Replies: 7
Views: 2046

No, there isn't - it will need to achieve that status on its own. And yes, you can Stop a job or Reset one that's been stopped (or aborted) if need be.
by chulett
Mon Sep 01, 2008 2:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restoring a job that was deleted
Replies: 1
Views: 1037

Nope. You'll need some sort of backup (file image, export, etc) to get it back.
by chulett
Mon Sep 01, 2008 8:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to connect DB2 Server via DB2 Enterprise Stage
Replies: 6
Views: 2222

Ray's "bleeding obvious" was to uninstall the patch. Hence the quote.
by chulett
Mon Sep 01, 2008 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to avoid update query
Replies: 10
Views: 3202

What database? What stage? What array size? :?

Work with your DBA, see what suggestions they have to improve the speed.
by chulett
Mon Sep 01, 2008 7:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to avoid update query
Replies: 10
Views: 3202

That would entirely depend on how you handled these errors. Me, I would use a transaction size of 0, then abort the job and rollback all the work if there were any problems. That and design the job such that errors would be a remote possibility. :wink:
by chulett
Mon Sep 01, 2008 7:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Use Userdefine Environment Variables into the Dsjob c
Replies: 6
Views: 2883

What does "not working" mean in this context? What error message is generated? <snip> I'm using following command, but it's not working. <snip> If anybody having idea. Let's share with me ! The first idea to share with you is to answer Ray's first two questions. All you've done here is repeat the f...
by chulett
Mon Sep 01, 2008 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to avoid update query
Replies: 10
Views: 3202

How long is "too much time"? How many indexes on your target table and is there one over the key column(s) you are using for the update? What about foreign keys? Check constraints? Triggers? As noted, there are many factors that effect update speed. Can you avoid an update? You tell us. One method w...
by chulett
Mon Sep 01, 2008 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Usage of UVBackup and UVRestore
Replies: 37
Views: 14475

They are restoring a 7.5.1 installation on an old server and then want to import the contents into their new 8.x installation. Use export/import to accomplish that.
by chulett
Mon Sep 01, 2008 7:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import server routine using command line
Replies: 5
Views: 1851

You can't. You can, however, delete the 'wrong' one but only before anyone replies to it.
by chulett
Mon Sep 01, 2008 7:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Usage of UtilityHashLookup
Replies: 7
Views: 2363

I only use it when I need to look-up one value and I'd rather do that once rather than over and over, even though there isn't anything wrong with that. Therefore, I use it in the Initial Value section of a stage variable.
by chulett
Mon Sep 01, 2008 6:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import server routine using command line
Replies: 5
Views: 1851

Please do not post the same question in multiple forums. That just tends to upset people. :evil:

http://www.dsxchange.com/viewtopic.php?t=121815
by chulett
Mon Sep 01, 2008 6:54 am
Forum: General
Topic: Import server routine using command line
Replies: 6
Views: 2776

They said 'to the server' not 'from the server'. That's because dsimport.exe is a client command and you would run it from your PC. The server only imports jobs, AFAIK.
by chulett
Mon Sep 01, 2008 6:47 am
Forum: General
Topic: Using environment variables in ODBC Connector stage
Replies: 5
Views: 2878

It certainly should be. If that way doesn't work, it sounds like a bug to me and suggests that you should contact your official support provider.