Search found 42189 matches

by chulett
Fri Oct 16, 2009 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trim in Modify stage
Replies: 20
Views: 22465

If you literally mean char rather than varchar and you're trying to trim trailing spaces, you cannot. Anywhere. Nature of the beast.
by chulett
Fri Oct 16, 2009 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RTI & WISD
Replies: 6
Views: 1837

There's no "RTI" in 8.x so you wouldn't have it anywhere. For 8.x you need to find out what/where the WISD equivalent is.
by chulett
Fri Oct 16, 2009 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Real Time processing of data
Replies: 2
Views: 927

What kind of volume and frequency are we talking about here?
by chulett
Fri Oct 16, 2009 7:04 am
Forum: General
Topic: Connecting to Command Line Interface
Replies: 5
Views: 2364

How did you 'set the path'? Sounds like you didn't get that bit right.
by chulett
Fri Oct 16, 2009 7:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: About error in GCI Link Inicialization
Replies: 5
Views: 1384

Neither of those values should ever be set to zero.
by chulett
Fri Oct 16, 2009 6:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Developing a Batch File to Back up a complete proyect
Replies: 32
Views: 10942

And here I thought we were talking about an export problem. Then this items are not read only items, but when i import the proyect i can see that some jobs are not been exported. The Read Only Items wasn't the elements witch I have not found in the proyect export file. The problem may be other one. ...
by chulett
Fri Oct 16, 2009 6:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: About server routine UtilityHashLookup with composite key
Replies: 2
Views: 1025

As noted, it's not a 'workaround' to concatenate the key values together, that's what you have to do to use this routine with a 'composite' key. Put a 'text mark' (@TM) between the columns when you do so.
by chulett
Fri Oct 16, 2009 6:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Version 8.0.1 FIX PACKS
Replies: 2
Views: 927

Holey Moley, that's some list. :shock:
by chulett
Thu Oct 15, 2009 5:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Developing a Batch File to Back up a complete proyect
Replies: 32
Views: 10942

Not sure what to tell you other than it works fine in 8.1 for me. Created a new job category (even though I think you're really supposed to store connectors elsewhere) and created a new connector object there. Ran two full project exports from the command line - using dsexport and dscmdexport - and ...
by chulett
Thu Oct 15, 2009 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server SMALLDATETIME data type error
Replies: 8
Views: 3646

OK, just wanted to double-check as sometimes an error can be a 'view data only' error.
by chulett
Thu Oct 15, 2009 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server SMALLDATETIME data type error
Replies: 8
Views: 3646

Does this only occur in the Viewer? Meaning, does the job run to completion without error or does it log the same message?
by chulett
Thu Oct 15, 2009 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling warnings
Replies: 9
Views: 3617

If you're thinking that the 'warnings' logged during the reset are in any way included in the job's ending status, you would be incorrect. They are ignored. :?
by chulett
Thu Oct 15, 2009 2:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: numeric conversion error going into sybase
Replies: 4
Views: 2027

Then I doubt you have "no problem" as you need to explicity handle the implied decimal by dividing it by the appropriate amount. Should fix both issues.
by chulett
Thu Oct 15, 2009 1:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RTI & WISD
Replies: 6
Views: 1837

Do you have 7.x or 8.x that you are working with? You've posted both now, which is it? As noted, it's a separate install on the RTI media for 7.
by chulett
Thu Oct 15, 2009 12:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: numeric conversion error going into sybase
Replies: 4
Views: 2027

Are you dividing the value by 100 (or 1000) before sending it off to Sybase?