Search found 42189 matches

by chulett
Tue Dec 22, 2009 5:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xmeta restore
Replies: 8
Views: 3768

Yes, what about the 'Universe' repository? Does that not need to stay in sync with XMETA? :?
by chulett
Tue Dec 22, 2009 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert in Sybase
Replies: 3
Views: 1540

Why did you feel the need to change the sql? What happened when you ran it with the generated sql?
by chulett
Tue Dec 22, 2009 2:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Compiling Parallel Transformer 8.1
Replies: 17
Views: 14822

Visual Studio 2008 is not supported - 2003 and 2005 are, from what I recall. Check your documentation.
by chulett
Tue Dec 22, 2009 2:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing . from decimal value.
Replies: 3
Views: 1498

Where is this output data and how are you looking at it? That "dot" may very well just be an artifact of the View Data option and not actually in your data.
by chulett
Tue Dec 22, 2009 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while running the job
Replies: 10
Views: 1720

SIGSEGV is a Segmentation Violation signal, more of a coding than a resource issue. Did you try search here for that message? What is your job design?
by chulett
Tue Dec 22, 2009 1:36 pm
Forum: General
Topic: Error: int 32 to decimal
Replies: 9
Views: 3072

The invalid character is noted in the message - a hex FD.
by chulett
Tue Dec 22, 2009 1:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Query
Replies: 3
Views: 1321

You'll be fine simply clearing the hashed files.
by chulett
Tue Dec 22, 2009 11:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Compiling Parallel Transformer 8.1
Replies: 17
Views: 14822

Yes, over and over and over.

Details, please - did you install a supported compiler? What are your compiler and linker APT variables set to? Is this a problem with any job with a Transformer stage or just this particular job?
by chulett
Tue Dec 22, 2009 11:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling SQL Script in a Unix Shell Script
Replies: 5
Views: 1724

It's a utility that you call from the "command line" - meaning the O/S level - to run scripts in your database. For Oracle it would be sqlplus but no clue what it is for Informix. As noted, have a chat with your DBA, they should be able to get you all squared away.
by chulett
Tue Dec 22, 2009 11:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling SQL Script in a Unix Shell Script
Replies: 5
Views: 1724

That's really a question for your Informix DBA. What command line utility do they provide for this?
by chulett
Tue Dec 22, 2009 10:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rollback the data if the datastage job get aborted
Replies: 18
Views: 9195

Check the Transaction Handling tab.
by chulett
Tue Dec 22, 2009 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rejects from Modify
Replies: 3
Views: 1673

Yes, in a transformer. And there's no reason to avoid the transformer for "performance reasons", those days are long ago.
by chulett
Tue Dec 22, 2009 10:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The JOB every hour brings me a different result
Replies: 5
Views: 2343

Preserve Type exists as an option in the 7.5.2 release. You also have the Default to Decimal Output option that may help as well.
by chulett
Tue Dec 22, 2009 10:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rejects from Modify
Replies: 3
Views: 1673

I don't believe so. Check upstream using the IsValid function and reject them before the Modify.
by chulett
Tue Dec 22, 2009 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while viewing data in a parallel job
Replies: 4
Views: 1790

Temp as in "temp" or temp as in "tmp"?