Search found 42189 matches

by chulett
Wed Sep 22, 2010 8:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: truncate target table
Replies: 20
Views: 5797

Seemed more like you were saying why would I post the answer. Anyway, let us know what you find out. Failing that, let us know the stage you are using, something you still haven't mentioned.
by chulett
Wed Sep 22, 2010 7:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update DB2 table takes longer time
Replies: 4
Views: 2007

In your shoes, I would involve my DBA and have them trace the activity, confirm that the index is indeed being used and your table is not being "full table scanned" for each update.
by chulett
Wed Sep 22, 2010 7:13 pm
Forum: General
Topic: Problem Using Sed via Routine Activity
Replies: 5
Views: 2408

In other words, just like you thought. :wink:
by chulett
Wed Sep 22, 2010 7:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading Huge Data
Replies: 5
Views: 1624

There is no "restartability" out of the box, that's something you need to design into your jobs based on your job's architecture and requirements.
by chulett
Wed Sep 22, 2010 7:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: full join
Replies: 12
Views: 3378

What makes you think the Merge stage can't do a full outer join? From what I recall, you would use what it calls a "Complete Set" as the Join Type, have you tried that?
by chulett
Wed Sep 22, 2010 7:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: truncate target table
Replies: 20
Views: 5797

Does it provides the same functionality for the SQL Server too or provides different functionality as my target database is SQLServer. And if it provides different functionality then "Clear table then insert rows" for the update action in SQL Server is going to delete all the rows or drop...
by chulett
Wed Sep 22, 2010 6:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: truncate target table
Replies: 20
Views: 5797

I dont have any documentation I find that very hard to believe. There is the "online" help text available from any of the client tools, plus an entire directory of pdf documentation at your disposal. Not to mention the Help button that is in each and every stage. You really should check t...
by chulett
Wed Sep 22, 2010 2:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: truncate target table
Replies: 20
Views: 5797

Neither one "drops" the table. And you have the documentation, I don't, so why not simply look it up and tell us?
by chulett
Wed Sep 22, 2010 1:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: truncate target table
Replies: 20
Views: 5797

As noted in the documentation, those two Update Actions perform two different functions in Oracle. They only behave "the same" for DB2 and Informix.
by chulett
Wed Sep 22, 2010 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup - Timestamp Fatal Error
Replies: 5
Views: 2491

Not sure what the heck that is supposed to mean, but if you are having an issue - start a new post.
by chulett
Wed Sep 22, 2010 11:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: truncate target table
Replies: 20
Views: 5797

Read what was posted a little more carefully.
by chulett
Wed Sep 22, 2010 10:44 am
Forum: General
Topic: multiple compile
Replies: 1
Views: 1052

Same tool. From what I recall you need to enable manual selection and then only push over the category that you want.
by chulett
Wed Sep 22, 2010 9:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: truncate target table
Replies: 20
Views: 5797

What stage are you using? Most would have an update action similiar to "Clear table then insert rows" which would do the truncate for you.
by chulett
Wed Sep 22, 2010 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage delete issue
Replies: 12
Views: 6472

New question = new post, please. That or search for some of those key words as it has been discussed here a number of times.
by chulett
Wed Sep 22, 2010 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Menu Bar Missing from The IBM DataStage v8.1 Designer Window
Replies: 7
Views: 10756

Same way. The registry key can't be all *that* different for 8.x so simply search for "dsdesign" and see where it turns up.