Search found 42189 matches

by chulett
Fri Apr 22, 2011 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00060: Deadlock detected
Replies: 7
Views: 4405

A deadlock in the XMETA repository? I would involve your official support provider.
by chulett
Fri Apr 22, 2011 7:19 am
Forum: General
Topic: Duplicate entry in .odbc.ini
Replies: 7
Views: 2217

If you need to do it the answer is simple, just assure they have unique names.
by chulett
Fri Apr 22, 2011 7:04 am
Forum: General
Topic: Duplicate entry in .odbc.ini
Replies: 7
Views: 2217

Apparently you can. Assuming this is something you are doing rather than planning on doing. :wink:

I would wager only one ever gets used and probably that would be the first one...
by chulett
Fri Apr 22, 2011 7:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBS_Enterprise_0:The runlOCALLY() OF THE OPERATOR FAILED
Replies: 4
Views: 5580

So, this is actually a Parallel job? Off we go...
by chulett
Fri Apr 22, 2011 7:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle OCI stage is always shown in "Grid Style"
Replies: 8
Views: 5223

Keep in mind the fact that it does say it is a temporary fix, ultimately you should "Install patch or upgrade to 8.1".
by chulett
Thu Apr 21, 2011 2:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: month from date
Replies: 2
Views: 1074

Link.TimestampField[6,2]
by chulett
Thu Apr 21, 2011 1:02 pm
Forum: General
Topic: Extract Invocation Id Expression from all sequencers in proj
Replies: 5
Views: 3203

First, help us out by exlaining what "Invocation Id Expression" would be and what you mean by extract. Also, how are you planning on using this information?
by chulett
Thu Apr 21, 2011 1:00 pm
Forum: General
Topic: Schedulers
Replies: 2
Views: 1594

The 'DataStage scheduler' on UNIX is cron. Enterprise schedulers are more robust, support dependancies and can schedule anything rather than just jobs.
by chulett
Thu Apr 21, 2011 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null issue in Date data type
Replies: 6
Views: 4297

Oracle supports a 'default value' but you need to not mention the column in your sql for it to be applied, if you specifically pass a null to the column it will be set to a null.

To me that means it is coming from your job, somewhere in there a default value is being applied.
by chulett
Thu Apr 21, 2011 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Discussion about Late Arriving Dimensions
Replies: 11
Views: 7880

Right, we had zero desire for any need to go back and modify old fact records for late arriving dimensions. :wink:
by chulett
Thu Apr 21, 2011 6:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change default value of attribute in oracle stage
Replies: 3
Views: 2697

Re: Change default value of attribute in oracle stage

asaf_arbely wrote:Does any one know if it's possible to change default values of attribute in datastage stage
It's not.
by chulett
Thu Apr 21, 2011 6:43 am
Forum: General
Topic: Test Routine, infinite loop
Replies: 6
Views: 3635

Pull the plug?
by chulett
Thu Apr 21, 2011 6:42 am
Forum: General
Topic: "Empty DSN: list returned from host XXX" Windows
Replies: 6
Views: 9329

Why would it be a 'bug' for a 32bit application to look for 32bit drivers, the only ones that it can use? Still, thanks for posting that solution.
by chulett
Wed Apr 20, 2011 7:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TIMESTAMP TO INTEGER
Replies: 6
Views: 1663

If that was true then your [1,4] substring should have worked. Change your target to a flat file, include the timestamp and show us what you get.