Search found 42189 matches

by chulett
Tue Jun 08, 2010 8:08 pm
Forum: General
Topic: Trim leading zero's
Replies: 6
Views: 2110

... and yet we all know how much people like to worry, even about insignificant things. :wink:
by chulett
Tue Jun 08, 2010 8:07 pm
Forum: General
Topic: Parsing xml messages using datastage
Replies: 4
Views: 2789

That and spend some time with any XML savvy people that you work with and who are willing to help. Any non-DataStage specific terms, like DTD and XSD, can be easily googled for. The CLOB part with be the problematical part, regardless of what is in it. Better to have used Oracle's XMLTYPE field for ...
by chulett
Tue Jun 08, 2010 12:36 pm
Forum: General
Topic: Trim leading zero's
Replies: 6
Views: 2110

There won't be an error as while they may get trimmed, the Decimal datatype puts them right back. You'd need to target a Varchar if you didn't want the zeroes: DecimalToString()
by chulett
Tue Jun 08, 2010 8:49 am
Forum: General
Topic: Converting Nullable source to Non-Nullable
Replies: 2
Views: 1524

Well... if "use a modify operator" isn't the way you want to go, do an exact search on your message starting with "Converting" and see if that helps.
by chulett
Tue Jun 08, 2010 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot create parallel job
Replies: 5
Views: 1771

Then you didn't properly license the Parallel engine, it seems.
by chulett
Tue Jun 08, 2010 7:36 am
Forum: General
Topic: How to unlock the job in Windows
Replies: 3
Views: 1085

Operating system doesn't matter. What did you find when you searched here, for example an Exact Search for 'unlock'?
by chulett
Tue Jun 08, 2010 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dealing with XHTML Files
Replies: 4
Views: 1674

Can't imagine it is any kind of supported. I wonder if there are any kind of XHTML -> XML converters out there?
by chulett
Tue Jun 08, 2010 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Improve performance with multiple transformers
Replies: 24
Views: 6451

Thanks Ernie. Wanted to convey that when I posted, but wasn't quite sure how to articulate it properly. Too dang early in the morning. :wink:
by chulett
Tue Jun 08, 2010 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 4
Views: 1681

In other words, a Reject link with a 'Abort after X rows' setting of 1.
by chulett
Tue Jun 08, 2010 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Improve performance with multiple transformers
Replies: 24
Views: 6451

1. As I said before....The layout of my job is like this DS -----------> Transformer --------------> DS DS -----------> Transformer --------------> DS DS -----------> Transformer --------------> DS Sometimes in a job I have 50 such DS-->TRNS--->DS. :shock: No, this is the first time you've fully de...
by chulett
Tue Jun 08, 2010 6:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can we get the System out from datastage job
Replies: 8
Views: 2508

You'd need to do a much better job of asking your question to get any help with it.
by chulett
Tue Jun 08, 2010 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Auto purge options
Replies: 5
Views: 1790

If all you're after is removing their listing in the Director, that takes a recompile of the base job (which nukes all) or you can 'Reset status file' on them, one by one, I believe. There's no automagic option that I recall.
by chulett
Tue Jun 08, 2010 6:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 'WEEK.TAG' with Sunday as start of week
Replies: 16
Views: 6681

Pretty sure the change needed is documented, but have no ability to check any more. :?
by chulett
Tue Jun 08, 2010 6:01 am
Forum: General
Topic: how to run datastage jobs in cygwin and suggest any packages
Replies: 3
Views: 1611

So... is it UNIX or Windows? You've marked your post as UNIX but talk about DataStage 7.5x2 which is Windows only. Cygwin is a terminal emulator and you'd use it to connect to a UNIX server from your Windows PC. Needless to say, confusing. If all is Windows, you don't need Cygwin for anything. In ei...