Search found 53125 matches

by ray.wurlod
Fri Dec 14, 2012 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Java Compilation error
Replies: 9
Views: 4849

Maybe. Where are your other classes (jar files) located?
by ray.wurlod
Fri Dec 14, 2012 3:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handle exception case in database load failuare
Replies: 3
Views: 1042

DELETE is good but it, too, is transactional. Pour another beer down your DBA's throat.
by ray.wurlod
Fri Dec 14, 2012 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between two rows
Replies: 7
Views: 2549

Otherwise use stage variables in a Transformer stage to "remember" the value from the previous row, a technique that has been explained more than once on DSXchange.
by ray.wurlod
Fri Dec 14, 2012 3:22 pm
Forum: General
Topic: How to find jobs using shared container?
Replies: 18
Views: 4024

That's all that's defined for the RT_... tables. :(
by ray.wurlod
Fri Dec 14, 2012 3:21 pm
Forum: General
Topic: Information Server 9.1 and DataStage 9.1 now available
Replies: 7
Views: 9531

Vincent has an earlier blog about what's new in 9.1, or you can get all of that information in detail from the Information Center - the 9.1 pages have been up there for some time.
by ray.wurlod
Fri Dec 14, 2012 3:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare files - Generic Job
Replies: 6
Views: 2283

You're up to 100 posts near enough. Don't you think it's time you contributed your 30c/day and got yourself a premium membership? Premium membership is DSXchange's funding model - this money all goes to hosting and bandwidth costs for the site.
by ray.wurlod
Fri Dec 14, 2012 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage job not throwing warnings on foreign key violation
Replies: 5
Views: 2467

If you capture the reject in a reject link the reject link can also be populated with the error code and error text.
by ray.wurlod
Fri Dec 14, 2012 3:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build Op for "LIKE" operation between data in two
Replies: 5
Views: 2022

Why not perform an equi-join on the ID values with a Join stage and the comparison in a Transformer stage (using the Index() function) downstream of that?
by ray.wurlod
Fri Dec 14, 2012 3:34 am
Forum: General
Topic: How to find jobs using shared container?
Replies: 18
Views: 4024

For partial documentation, in a dssh environment:

Code: Select all

LIST DICT DS_JOBS
LIST DICT DS_JOBOBJECTS
For discoveries, rummage around the results of a search here for DS_JOBOBJECTS.
by ray.wurlod
Fri Dec 14, 2012 3:32 am
Forum: General
Topic: Assigning two DS engines to the same xmeta repository
Replies: 12
Views: 3013

That "solution" will still not share jobs and other engine-specific objects.

Information Server does have built-in HA capability in the services and repository tiers, but there's no way to get running jobs or connected client sessions to fail over.
by ray.wurlod
Fri Dec 14, 2012 12:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare files - Generic Job
Replies: 6
Views: 2283

If the number of fields is unknown and arbitrary, the only generic solution is to read each line as a single VarChar, parse based on a known delimiter character (could be a job parameter) and produce the output in that fashion. The output will also need to be a single VarChar in order for there to b...
by ray.wurlod
Fri Dec 14, 2012 12:08 am
Forum: General
Topic: How to find jobs using shared container?
Replies: 18
Views: 4024

Alas the structures of these tables are only partially documented. A few of us have hacked some of the structure, but definitely not completely. Do you have a colleague with UniVerse (or, at a pinch, UniData) experience? They will stand a better chance of hacking the structures. There's a lot of UV ...
by ray.wurlod
Fri Dec 14, 2012 12:06 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Information Analyzer Issue
Replies: 3
Views: 2888

When you run the installer, does it go into "add components" rather than "new installation"?
by ray.wurlod
Fri Dec 14, 2012 12:04 am
Forum: Site/Forum
Topic: Slide-Ins
Replies: 11
Views: 8687

A full malware scan revealed "no issues".
A full anti-virus scan revealed "no issues".
Weird.
by ray.wurlod
Thu Dec 13, 2012 8:55 pm
Forum: General
Topic: How to find jobs using shared container?
Replies: 18
Views: 4024

You need to identify (by OLETYPE) the Shared Container (view) records in DS_JOBOBJECTS. In those records the input link and output link references can be found, and you can self-join using the OBJIDNO column. To get the job name join to DS_JOBS based on DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO.