Search found 42189 matches

by chulett
Wed Aug 06, 2008 8:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage upgrade
Replies: 6
Views: 1523

It would be much simpler if you just "upgrade in place". For a new server - yes, you will need to export and import all projects. That and transfer all existing data/hashed/etc files you'll need to persist.
by chulett
Wed Aug 06, 2008 8:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: List jobname and its category
Replies: 16
Views: 7947

Did you turn off the "View / Show Categories" option as noted?
by chulett
Wed Aug 06, 2008 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check that
Replies: 4
Views: 1084

Check that?
by chulett
Wed Aug 06, 2008 7:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage upgrade
Replies: 6
Views: 1523

Ok, confusing. You still haven't stated upgrading from 7.5.1 to what? And what "new datastage server" are you talking about - are you building a completely new box for this upgrade to be installed on? :?
by chulett
Wed Aug 06, 2008 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed to open RT_LOG2377 file
Replies: 10
Views: 2506

You just went out and unlocked ALL jobs? Bad Idea. If you can't see the job listed in the Director then your project has become corrupted, possibly from your overzealous use of the UNLOCK verb. You'll probably as a first effort need to try and REINDEX the project, search the forum for that word or D...
by chulett
Wed Aug 06, 2008 7:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String to DATE (YYYYMMDD) conversion Error
Replies: 4
Views: 1450

ps. You're not having a problem, a DATE is a DATE regardless of the format some tool displays it in.
by chulett
Wed Aug 06, 2008 7:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Ascential header
Replies: 1
Views: 751

There's an option in the stage to "Include comment". Disable that.
by chulett
Wed Aug 06, 2008 7:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Matching records between sources
Replies: 9
Views: 2054

Check the length and compare the first X characters where X is the length of the smaller of the two.
by chulett
Wed Aug 06, 2008 7:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Backward compatability
Replies: 2
Views: 825

ps. That's not "backward compatibility". More like "forward"... and everything should always be forward compatible. :wink:
by chulett
Wed Aug 06, 2008 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: deriving Month and Year to seperate columns
Replies: 3
Views: 889

Describe your job design. Explain in detail what "no records has been transferred" means.
by chulett
Wed Aug 06, 2008 7:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Remove duplicates on morethan 1 column
Replies: 13
Views: 5644

Double-click on the function itself in the Manager (Routines\sdk\RowProc) - it is "explained clearly" in the Long Description, as are all supplied routines.
by chulett
Wed Aug 06, 2008 7:21 am
Forum: General
Topic: Regeneration of wsdl
Replies: 1
Views: 907

Every time? No. I suppose if you change the input or output format you would, but not for just an internal code change. Unless that's a new "feature" of 8.x. :?
by chulett
Tue Aug 05, 2008 9:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1592

I suggested you open a case with your official support provider, not read the release notes. Although that wasn't a bad idea but it certainly isn't the only thing to do.
by chulett
Tue Aug 05, 2008 9:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get rid of new line return in Datastage basic code
Replies: 9
Views: 1860

Then it seems you may need to trim a 'newline' directly - CHAR(10) rather than @FM.