Search found 53125 matches

by ray.wurlod
Fri Jun 11, 2010 6:46 pm
Forum: IBM QualityStage
Topic: What is the difference b/w ZQMIXNZQ, ZQMIXAZQ, ZQMIXRZQ
Replies: 4
Views: 2206

Which rule set uses these literals (I am not in the USA)? The names suggest "mixed numeric", "mixed alpha" and "mixed something beginning with R" - possibly very mixed tokens such as R2D2.
by ray.wurlod
Fri Jun 11, 2010 6:45 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Join two or more tables
Replies: 5
Views: 2252

Not directly within IA but, if you create an appropriate view in the source, then you can profile the view.
by ray.wurlod
Fri Jun 11, 2010 6:40 pm
Forum: Enhancement Wish List
Topic: Commit Progress Information Logging and Skipping
Replies: 2
Views: 2563

I don't see why this couldn't be written to handle execution on multiple machines, whether in a cluster or a grid, though the information would have to be collected (and maybe reported) per-node, just as row counts currently are. One of the additional items of information might be the number of rows...
by ray.wurlod
Fri Jun 11, 2010 4:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delimiter for field warning while reading sequential file
Replies: 16
Views: 21212

What is your specified delimiter. The stage has read the four characters indicated. Could there be line terminators in your data?
by ray.wurlod
Fri Jun 11, 2010 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inline sort Storage
Replies: 2
Views: 1394

Same as the Sort stage. The tsort operator is used in both cases. It will attempt to do the entire sort in memory until allocated memory is exhausted, then spill to scratchdisk.
by ray.wurlod
Fri Jun 11, 2010 4:29 am
Forum: General
Topic: passing file path as a parameter to server routine
Replies: 5
Views: 1930

Put a DSLogInfo() call into your routine to report what pathname it received. Put DSLogInfo() calls into all four clauses of the OpenSeq statement to report which is taken. Put a DSLogInfo() call into the Then and Else clauses of the ReadSeq statement to report what happened and what was read.
by ray.wurlod
Thu Jun 10, 2010 9:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help in Range lookup
Replies: 7
Views: 2445

What if you use two Lookup stages, so that you're not mixing lookup types? A range lookup compiles to a transform operator whereas a normal lookup compiles to a composite (LUT_CreateOp/LUT_ProcessOp) operator.
by ray.wurlod
Thu Jun 10, 2010 9:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Nanosecond
Replies: 5
Views: 1886

Or quantum physical data!
:lol:
by ray.wurlod
Thu Jun 10, 2010 5:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterpirse Stage - Records rejected without warning
Replies: 11
Views: 3873

Does the executing user have INSERT privilege to the table in question?

(If you don't tell us, we have to ask.)
by ray.wurlod
Thu Jun 10, 2010 5:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Nanosecond
Replies: 5
Views: 1886

Might have a REALLY FAST processor!
:wink:
by ray.wurlod
Thu Jun 10, 2010 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregate the Data
Replies: 2
Views: 1211

Please mark thread as Resolved using green button at top. Well done for finding the solution.
by ray.wurlod
Thu Jun 10, 2010 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capture Job Log
Replies: 1
Views: 1340

You can use an after-job routine quite happily. It should use the log interrogation functions DSGetNewestLogId(), DSGetLogEvent() and/or DSGetLogSummary().
by ray.wurlod
Thu Jun 10, 2010 4:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: isadmin not found in registry
Replies: 1
Views: 2239

When you switch to LDAP, assuming it's done properly, all of the internal user registry users are eliminated. The new administrator is the LDAP server user name. You need to open web console for Information Server logging in with this ID, allocate the Suite Administrator role to one or two LDAP user...
by ray.wurlod
Thu Jun 10, 2010 4:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning Concern -- masking of an error
Replies: 3
Views: 1679

Message handlers are based on the Message ID.

Only that particular message ID will be masked. And only in jobs for which the message handler is loaded.