Search found 53125 matches

by ray.wurlod
Fri Mar 20, 2009 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OCONV function still work in PX routine
Replies: 3
Views: 2193

Iconv() and Oconv() are not available for use in C++ parallel routines.

They can be used in server routines invoked from BASIC Transformer stage. But these are server routines.

So the assertion in the original post on this thread is incorrect.
by ray.wurlod
Fri Mar 20, 2009 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warrning:-APT_Combined... and data is not loaded into SeqFil
Replies: 3
Views: 1303

You'll never know where the error is being generated while you have operator combination enabled.
by ray.wurlod
Fri Mar 20, 2009 4:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parrel job warning and not loading data into seq file
Replies: 3
Views: 1340

sjaladurgam is not reading the message. The message is being generated by a sort, whether it's an explicit Sort stage, an input link sort or an inserted tsort operator.

The solution will be found with a Search.
by ray.wurlod
Fri Mar 20, 2009 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSN not appearning in manager to import table def
Replies: 4
Views: 1130

The drop-down list is populated from DSNs from which table definitions have been imported and for which, as a result, an entry appears in the uvodbc.config file in the project.

You can also manually edit the uvodbc.config file in the project to include the DSN.
by ray.wurlod
Fri Mar 20, 2009 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Range Lookups V7.5.2
Replies: 5
Views: 2094

I'm not sure this is correct. Write Range Map stage creates a range map to support Range partitioning, not Range lookup. Range (or "between") lookups are available in version 8. ABout the only way I know to do it in version 7 is to use a sparse lookup with user-defined SQL containing an ap...
by ray.wurlod
Fri Mar 20, 2009 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Compilation Error for Transformer
Replies: 8
Views: 3891

And your values for the four "Compiler" environment variables are ...?
by ray.wurlod
Fri Mar 20, 2009 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter set used in Transformer = Compilation error
Replies: 13
Views: 3309

Just a parameter reference in an expression should yield the parameter value at run time. The job log will show the value that was passed to the job, annotated that it is the $PROJDEF value if such is the case.
by ray.wurlod
Fri Mar 20, 2009 3:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML 'footer' information
Replies: 3
Views: 1452

You could use a separate Sequential File stage reading a whole line at a time (with a Filter command of grep if you have grep on your system, or passing through a Transformer constrained on the existence of "Row Count" in the line and responsible for the parsing). Use Index() for the exist...
by ray.wurlod
Fri Mar 20, 2009 3:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: VPN Datastage work resulting in error
Replies: 5
Views: 1536

I'm not sure that this is a VPN issue. There appears to be a bug in 8.1 which I encountered recently. In my case it was a server routine that couldn't be saved, and it turned out that the entire routine code had been packed into the key (which was then too long, since keys on that system are limited...
by ray.wurlod
Fri Mar 20, 2009 3:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control Repository
Replies: 5
Views: 1552

I would recommend the RESIZE approach, but perhaps with more thoughtfully-chosen parameters. 18 groups size In this syntax size is the size of a group buffer (use 4, which specifies 2048 bytes) and groups is the number of groups (look at the existing size of DATA.30 and OVER.30, sum them and divide ...
by ray.wurlod
Fri Mar 20, 2009 3:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dsx export discrepancies
Replies: 4
Views: 1553

What is the exact server version on each system (for example 7.5.1.r2d2)
by ray.wurlod
Fri Mar 20, 2009 3:40 pm
Forum: General
Topic: appropriate use of exception handler stage
Replies: 2
Views: 3199

First catch your exception.

Is your definition of "fails" the same as that which the job sequence uses?
by ray.wurlod
Fri Mar 20, 2009 3:38 pm
Forum: General
Topic: how to pass the start timestamp of one job to another job
Replies: 5
Views: 1368

Why is it urgent? Why didn't you ask a week earlier? Why is it urgent on a Friday night? We don't do "urgent". DSXchange is an all-volunteer site whose participants post as and when they can, usually only if they have something useful to contribute. If you want urgent assistance sign up wi...
by ray.wurlod
Fri Mar 20, 2009 3:35 pm
Forum: IBM QualityStage
Topic: MatchFrequency file Vs. the weightage
Replies: 2
Views: 1899

How are you generating the match frequencies? Are you perhaps on a two node environment and only looking at figures from one node?