Search found 53125 matches

by ray.wurlod
Fri Mar 10, 2006 6:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control project purge
Replies: 4
Views: 1122

Contents of the extra hashed files in the VERSION project are, like most, not publicly documented. Haven't had time to hack those yet. Can't be all that difficult.
by ray.wurlod
Fri Mar 10, 2006 6:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Case Insensitivity when comparing strings?
Replies: 7
Views: 3201

Your test routine requires a DEFFUN declaration.
by ray.wurlod
Fri Mar 10, 2006 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: converting 100s of rows into 100s of columns
Replies: 6
Views: 1564

There are other techniques too. Search the forum for VERTICAL PIVOT.
by ray.wurlod
Fri Mar 10, 2006 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deleting corrupted Empty category/folder
Replies: 8
Views: 3359

It may also be that the index on CATEGORY is not up to date. You may try re-indexing the Repository.
by ray.wurlod
Fri Mar 10, 2006 6:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Encrypted Environment variables
Replies: 14
Views: 9514

I understood that encrypted environment variable parameters weren't suppported until version 7.5, yet jetlim is on 7.1.
by ray.wurlod
Fri Mar 10, 2006 6:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data from Webpages To Datastage
Replies: 2
Views: 985

If you have direct access to the web pages you can "View Source" and use DataStage to parse that HTML.
by ray.wurlod
Fri Mar 10, 2006 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Network Problems when doing multi-compile: Defect 1835:
Replies: 2
Views: 1191

Is this really version 7.x, or the beta Hawk release? The word "defect" in the report suggests that you should be advising your support provider.
by ray.wurlod
Fri Mar 10, 2006 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sync source on DataStage job
Replies: 6
Views: 2541

There's some good news for you in the Hawk release, where they have a "difference" tool that allows you to compare two DataStage objects side by side. Hyperlinks to where the actual differences occur are part of what you get.
by ray.wurlod
Fri Mar 10, 2006 6:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trim Function in Modify Stage
Replies: 21
Views: 12414

Don't forget the colon.
NewEmpname: nullable varchar(255)=string_trim(Empname)
by ray.wurlod
Fri Mar 10, 2006 6:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: multiple files into a single seq file???
Replies: 8
Views: 2540

Tip: If you use multiple File property values, the technique is Specific File, not Pattern.
by ray.wurlod
Fri Mar 10, 2006 6:18 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Licensing the RTI Agent on a Server machine
Replies: 6
Views: 3457

Ya can always test in development first. :wink:
But - yes - I'm confident.
by ray.wurlod
Thu Mar 09, 2006 8:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job gets slower
Replies: 2
Views: 976

If you are getting thousands of warnings - or even informational messages - per run clogging the job log, this is one reason that jobs can run slower than they used to - there's more overhead in adding entries to a non-cached hashed file (the job log) when it's got lots and lots of entries in it alr...
by ray.wurlod
Thu Mar 09, 2006 8:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Case Insensitivity when comparing strings?
Replies: 7
Views: 3201

Have you inspected the code for CompareNoCase() ? :wink:
by ray.wurlod
Thu Mar 09, 2006 8:48 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Licensing the RTI Agent on a Server machine
Replies: 6
Views: 3457

Shouidn't've been a problem - the letters in the serial number indicate exactly what it is that's being licensed. Might've saved some time. C'est la vie. You being paid by the hour? :lol:
by ray.wurlod
Thu Mar 09, 2006 5:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal to integer
Replies: 15
Views: 4464

No. DataStage will always generate the warning. Because you need the warning. If you want to you can create a message handler to demote the warning to an informational message. Search is your friend.