Search found 53125 matches

by ray.wurlod
Thu Jul 16, 2009 11:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: to sort on row in asc and second row in desc in a table of 1
Replies: 4
Views: 1011

No, simply because there's nothing that allows you to sort a row.

I assume you want a result something like

Code: Select all

 1  2  3  4  5  6
10  9  8  7  7  6
 3  5  9 11 13 20
15 14 12 10  9  5
by ray.wurlod
Thu Jul 16, 2009 11:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge multiple rows into one based on key values
Replies: 8
Views: 3512

Link Collector stage, Transformer stage, Aggregator stage ("Last")
by ray.wurlod
Thu Jul 16, 2009 5:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Versions on the same server
Replies: 3
Views: 1677

8.x must be a standard installation.

Two 8.x servers on the same machine are not supported.

The combination of 8.x and 7.x is supported, but the 7.x must be the -itag installation.
by ray.wurlod
Thu Jul 16, 2009 5:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Output multi byte data indicating NLS:UTF8
Replies: 9
Views: 3706

You don't need to change anything in the operating system.

You DO need to get the job that populates the hashed file working properly. It's THERE that the mapping must be set properly. What is the source for this job (file or table)?
by ray.wurlod
Thu Jul 16, 2009 5:04 pm
Forum: General
Topic: Job Status is not showing properly when it is Failed
Replies: 4
Views: 1165

Has your UNIX administrator enabled large file support, or is the UNIX file size limit 2GB? Also, please check the ulimit settings for the user that actually executes the job.
by ray.wurlod
Thu Jul 16, 2009 5:02 pm
Forum: General
Topic: Error report
Replies: 1
Views: 889

Ask for more specifics. WHAT warning? Were row counts reported? What technique was used to attempt to see the data?
by ray.wurlod
Thu Jul 16, 2009 1:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rules To Be Followed For Concatenation
Replies: 8
Views: 2210

Following is the code i am using... If IsNull(DSLink3.FIRSTNAME) Then ',' Else Trim(DSLink3.FIRSTNAME) : ',' : If IsNull(DSLink3.LASTNAME) Then ',' Else Trim(DSLink3.LASTNAME) And i am not getting any warrning or error.Job is completing successfully. I am handling null also. Only two columns are me...
by ray.wurlod
Thu Jul 16, 2009 1:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: score file error
Replies: 3
Views: 5702

The file system on which /tmp is mounted filled.

Land your score someplace else.
by ray.wurlod
Thu Jul 16, 2009 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to load in XML file
Replies: 5
Views: 1925

If you can't find the file and can't view the data, what precisely do you mean by "finished successfully"? What are the row counts reported by the client tools?
by ray.wurlod
Thu Jul 16, 2009 1:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connecting Datastage to Classic Fed server
Replies: 1
Views: 1222

Welcome aboard. It's certainly possible in version 8.0.1, where there is a separate stage type for Federation Server (though I suspect, from its properties, that it uses an ODBC driver, or at least ODBC protocols, under the covers). I am not currently in a position to verify or otherwise whether thi...
by ray.wurlod
Thu Jul 16, 2009 1:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Output multi byte data indicating NLS:UTF8
Replies: 9
Views: 3706

Does the job that populates the hashed file display Japanese characters correctly when you use View Data on the Hashed File stage?
by ray.wurlod
Wed Jul 15, 2009 11:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not Enough space
Replies: 11
Views: 3812

sanjay wrote:you have implement memory window option in HP unix to resolve above issue below issue .
:?:
Please explain how you believe the memory window option solves lack of physical disk space.

I'm not really certain what you mean by "above issue below issue" either.
by ray.wurlod
Wed Jul 15, 2009 11:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error
Replies: 3
Views: 2230

That has verified that your configuration file is syntactically (and semantically) correct, which needed to be eliminated first.

Now read the next part of the error message, about not having rsh set up properly or $APT_ORCHHOME not visible on all nodes.
by ray.wurlod
Wed Jul 15, 2009 11:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error:No conductor nodes found in export node pool
Replies: 5
Views: 6473

Re: Error:No conductor nodes found in export node pool

whenever you are reading from file or writing to file you need to user the two environemnt variables called APT_GRID_SEQFILE_HOST and APT_GRID_SEQFILE_HOST2 which runs on conductor node, so use APT_GRID_SEQFILE_HOST2 on the file name before the file path name. That's only true if executing in a gri...
by ray.wurlod
Wed Jul 15, 2009 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is APT_PM_CONDUCTOR_TIMEOUT? Unable to access dataset?
Replies: 4
Views: 4007

You need to set up trusted communication for rsh.