Search found 53125 matches

by ray.wurlod
Tue Nov 16, 2010 3:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parse file
Replies: 13
Views: 4245

That would be the approach I would take also. Do you know all the possible fields that can occur in a jil file?
by ray.wurlod
Tue Nov 16, 2010 3:30 am
Forum: General
Topic: IIS 8.1 Separate engine installation error
Replies: 8
Views: 9496

That's all fine. So to find out what went wrong you will need to consult the install.log file.
by ray.wurlod
Tue Nov 16, 2010 1:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read very high volume sorted sequential file
Replies: 5
Views: 1756

That's correct. However, if you had re-partitioned the data on the input to the Data Set, the data in the Data Set would almost certainly not be sorted.
by ray.wurlod
Mon Nov 15, 2010 11:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: default parameterset
Replies: 1
Views: 1220

There is no default Parameter Set in the way in which you describe.

Parameters that are not members of parameter sets exist only as job properties - they have no existence outside of the job in which they are defined.
by ray.wurlod
Mon Nov 15, 2010 11:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read very high volume sorted sequential file
Replies: 5
Views: 1756

Re-partitioning is almost guaranteed to destroy parallel-sorted data's sorted order. Partitioning of a sequential stream will tend to preserve sorted order.
by ray.wurlod
Mon Nov 15, 2010 11:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove Duplicate PRoblem when using 2X
Replies: 3
Views: 1384

Are the sort keys the same as the remove duplicate keys?
by ray.wurlod
Mon Nov 15, 2010 10:59 pm
Forum: General
Topic: IIS 8.1 Separate engine installation error
Replies: 8
Views: 9496

Then you have not successfully installed the engine tier. Does the installation directory already exist? It should not exist, though its parent directory must exist. For example, if your installation directory is /opt/IBM/InformationServer, then /opt/IBM/InformationServer must not exist, but a direc...
by ray.wurlod
Mon Nov 15, 2010 2:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameterized values getting hard coded
Replies: 10
Views: 4486

Did you migrate the associated Parameter Set?
by ray.wurlod
Mon Nov 15, 2010 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove Duplicate PRoblem when using 2X
Replies: 3
Views: 1384

Welcome aboard.

Are the data partitioned on the "key used to determine duplicates"?
by ray.wurlod
Mon Nov 15, 2010 2:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Allowing dups..
Replies: 4
Views: 2334

Re: Lookup Allowing dups..

HariK wrote:Lookup is supposed to return only one row from the reference input. If there are more than one record that matches it will throw warning.
That's not true. One reference input to a Lookup stage is permitted to return multiple rows. There's a drop-down list that allows that link name to be selected.
by ray.wurlod
Mon Nov 15, 2010 2:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to install IIS 8.5 client components
Replies: 8
Views: 4189

Check that you do indeed have 2GB. One of the memory sticks may not be fully pushed home in its slot. Or your PC supplier may have robbed you!
by ray.wurlod
Mon Nov 15, 2010 2:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get minimum value without using aggregator stage
Replies: 10
Views: 3853

Re: how to get min sal without using aggregator stage

sureshbabu wrote:friest filer basend on depno, then sort ase order on sal then the both depno and sal and using copy pass only one
Please replace your keyboard with one that can spell!
by ray.wurlod
Mon Nov 15, 2010 2:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rows to columns
Replies: 1
Views: 1190

Search DSXchange for "vertical pivot". It's been discussed a number of times.
by ray.wurlod
Mon Nov 15, 2010 2:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pattern Matching
Replies: 14
Views: 5514

How do you construct Arg2?