Search found 53125 matches

by ray.wurlod
Mon Nov 29, 2010 1:26 pm
Forum: General
Topic: Regarding installation of Infosphere 8.1 server edition
Replies: 8
Views: 3619

Full instructions about what you need to download are on the Passport Advantage and Fix Central sites. There are lots of fix packs and patches for version 8.1, which you will need to get from Fix Central. Let Fix Central do the searching for you.
by ray.wurlod
Mon Nov 29, 2010 1:24 pm
Forum: General
Topic: Installation - Engin and classes are disabled
Replies: 1
Views: 1364

My guess is that your friend downloaded a UNIX edition, not a Windows edition, for the server components.

The new installer does not ask for a licence file. There's a default licence and a "trust" mechanism.
by ray.wurlod
Mon Nov 29, 2010 4:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: special character removal using DS job
Replies: 6
Views: 5423

No more information is required. My suggested solution will work.
by ray.wurlod
Mon Nov 29, 2010 4:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with handling chinese characters
Replies: 3
Views: 1746

You must have all your maps (a) correct and (b) compatible. For example MS1252 does not handle Chinese characters.
by ray.wurlod
Mon Nov 29, 2010 4:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert to Date
Replies: 9
Views: 2376

More work may be required if the output has Date data type.
by ray.wurlod
Mon Nov 29, 2010 2:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert to Date
Replies: 9
Views: 2376

Provide the correct format strings and use conversion functions such as DateToString() and StringToDate(). You will also need to concatenate the day number (01) to the incoming string.
by ray.wurlod
Sat Nov 27, 2010 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field defaults Quotes In Sequential File stage
Replies: 6
Views: 3075

You can use strings longer than one character, but you have to use Field/Record Delimiter String property rather than Field/Record Delimiter (which is limited to a single character).

There is no default for these. The default is to use Field Delimiter = comma.
by ray.wurlod
Sat Nov 27, 2010 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encryption & decryption
Replies: 1
Views: 954

You're going to encrypt and decrypt in the one flow? That's the same as taking one step forward and one step backward - a lot of effort to achieve nothing.

Anyway, there's lots of encryption algorithms to be found on the web. And you can hire a C++ programmer if you don't have the skills.
by ray.wurlod
Sat Nov 27, 2010 4:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: GET FILENAME
Replies: 37
Views: 9673

That is not the file name. That is the first three characters of the filename.
by ray.wurlod
Fri Nov 26, 2010 2:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset distinct what is right approach
Replies: 3
Views: 1128

There isn't, the same way there's no way to do it within a database table. You have to do it as the rows come out.
by ray.wurlod
Fri Nov 26, 2010 2:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference Between join, Lookup and merge
Replies: 6
Views: 12576

For starters, Merge consumes rows from its reference (update) input(s). The other two stage types don't. Your Keep rule iss giving variations because you end up with unmatched masters after all the reference rows have been consumed. So what do you actually want the output to be? Both results you got...
by ray.wurlod
Fri Nov 26, 2010 2:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: special character removal using DS job
Replies: 6
Views: 5423

Code: Select all

Convert('"', "'", InLink.TheString)
by ray.wurlod
Fri Nov 26, 2010 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compile and Force Compile
Replies: 2
Views: 2764

For Version 7 the Chapter number may be different. Use the Search capability within the PDF reader. If you can't find Force Compile there, try the Parallel Job Developer's Guide.
by ray.wurlod
Thu Nov 25, 2010 11:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Find numeric characters in a string
Replies: 5
Views: 1926

Code: Select all

InLink.TheString Matches "1N0N"
by ray.wurlod
Thu Nov 25, 2010 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage - wI/O
Replies: 15
Views: 5848

DataStage processes fixed-width data wherever possible. It's far more efficient than having to scan for delimiters or calculated offsets.