Search found 42189 matches

by chulett
Fri Dec 18, 2009 10:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Milliseconds
Replies: 7
Views: 5544

Contact your official support provider, that smells like a bug.

ps. When someone asks for an Oracle version, it means all 4 digits. Saying "10g" is way too generic, it should be more like "10.2.0.1" or some such. Some specific versions are more problematic than others.
by chulett
Fri Dec 18, 2009 10:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reducing Joblogsize after Purge?
Replies: 9
Views: 3056

True, forgot you can only do it from the main job. Did you get a count of log entries before and after? That should confirm the amount of records that were actually deleted.
by chulett
Fri Dec 18, 2009 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reducing Joblogsize after Purge?
Replies: 9
Views: 3056

Multi-instance jobs are a little trickier - where did you do the purge from, the 'base' job or from one / all of the invocation ids? How long had it been since the last '30 days' purge?
by chulett
Fri Dec 18, 2009 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To pas path as a parameter from the parameter file
Replies: 4
Views: 1755

Please post the exact error messages. Cut and paste, don't summarize.
by chulett
Fri Dec 18, 2009 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Delimeter
Replies: 6
Views: 1824

You've been supplied an invalid csv file. Those amounts need to be quoted so they can be properly read, that or they should not have those internal commas. pdid,pdcost,pdnm a001,"10,000",XXX b001,"20,000",YYY c001,"1,00,000",ZZZ pdid,pdcost,pdnm a001,10000,XXX b001,2000...
by chulett
Fri Dec 18, 2009 8:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help me asap
Replies: 4
Views: 1280

Why would you think you'd need to know the "exact length"? It's just a csv file, the Sequential File stage will worry about that. :?
by chulett
Fri Dec 18, 2009 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key Perfromance
Replies: 5
Views: 2072

What does this mean? :?
rajan.n wrote:but it wont generate sequence number as I am on 2 node structure.
by chulett
Fri Dec 18, 2009 7:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reducing Joblogsize after Purge?
Replies: 9
Views: 3056

They're Type30 dynamic hashed files, so that purge should automatically be reducing the log's size as well. Are you certain that it is not? :?
by chulett
Fri Dec 18, 2009 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Slow query performance in DataStage - Fast in Sql PLus
Replies: 7
Views: 3264

True. Usually you'd have to ask for the grants the Session Browser needs. See if your DBA will help you monitor this and check your runtime explain plan.
by chulett
Fri Dec 18, 2009 7:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Milliseconds
Replies: 7
Views: 5544

I've never seen that. As noted, an Oracle DATE does not support milliseconds. Which 'generation' option are you using? What version of the Oracle client is installed on your server? :?
by chulett
Fri Dec 18, 2009 7:45 am
Forum: General
Topic: XML Input from a URL rather than a File Path
Replies: 7
Views: 1768

And then unjar it later on some toast. :wink:

Thanks Ernie.
by chulett
Fri Dec 18, 2009 7:42 am
Forum: General
Topic: What is the use of Partition table option
Replies: 3
Views: 1162

You've already been replied.

...and we particularly don't like to answer questions that can readily be answered by invoking on-line help or by reading the manuals.

Read about it in the help and documentation, then let us know if you have any specific questions.
by chulett
Thu Dec 17, 2009 7:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Slow query performance in DataStage - Fast in Sql PLus
Replies: 7
Views: 3264

Yes, through the Session Browser assuming you have the grants for that. Or have your DBA do that for you. And just cause they're both done in Toad doesn't mean they're the same thing!
by chulett
Thu Dec 17, 2009 7:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert,Update - Oracle DB
Replies: 5
Views: 1560

Check the docs, I don't recall if that's strictly a load option or not.
by chulett
Thu Dec 17, 2009 7:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LDAP to Database job question
Replies: 3
Views: 1468

Arise! :D

Out of curiousity, is there a way to do this without TX or the Java pack? I've been offered up a perl script shooting LDAP information out to standard out as a possible solution but wondering what other approach there might be. For us 'Don't Haves', that is.