Search found 53125 matches

by ray.wurlod
Fri Mar 08, 2013 7:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: look up stage interiors
Replies: 4
Views: 1407

The key values are NOT sorted. A hash table index is built.
If there is more than one value associated with any one row in that hash table, then there are duplicates for that value.
by ray.wurlod
Fri Mar 08, 2013 7:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to truncate Chinese Char ?
Replies: 9
Views: 4802

The inbuilt functions that you are likely to use, like [1,50] or Substring(), or Left(), all operate on characters (not on bytes). So, provided you have specified the correct character map (the one used to encode the data, for example BIG5 or GB2312) then all should be well. The error message does n...
by ray.wurlod
Fri Mar 08, 2013 7:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reject link creates a file
Replies: 6
Views: 1735

Discover such instances using cross-able analysis in Information Analyzer.
by ray.wurlod
Fri Mar 08, 2013 7:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII Delimiter for a sequential file
Replies: 3
Views: 1459

Same deal. Or you could read the on-line Help about how to specify non-printing delimiter characters.
by ray.wurlod
Fri Mar 08, 2013 7:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String Tokenizer
Replies: 5
Views: 1599

Once you've effected the conversion, change the space characters to Char(10), write to a text file with no formatting, and read back from the text file with line terminator specified.
by ray.wurlod
Fri Mar 08, 2013 12:12 am
Forum: General
Topic: How can I check if MKS Toolkit is installed?
Replies: 3
Views: 1188

Do something (maybe a before-job subroutine) that requires a UNIX commmand. I'd suggest id as that command, executed through ExecSH subroutine.
by ray.wurlod
Fri Mar 08, 2013 12:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trim the first characters
Replies: 3
Views: 1480

Code: Select all

Right(InLink.TheColumn, Len(InLink.TheColumn) - 4)
by ray.wurlod
Fri Mar 08, 2013 12:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot rows
Replies: 12
Views: 4255

You could use a Transformer stage with 60 output links brought back together in a Funnel stage.
by ray.wurlod
Fri Mar 08, 2013 12:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII Delimiter for a sequential file
Replies: 3
Views: 1459

Type 154 into the Delimiter property on the Format tab when importing the table definition for the sequential file.

Once the table definition has been imported open it and click Sync Parallel
by ray.wurlod
Fri Mar 08, 2013 12:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String Tokenizer
Replies: 5
Views: 1599

There's no function out of the box, but it would be very easy to create one. Assuming that the string is already space-separated there is no real need to tokenise - if you think there is, please provide a more exact specification. FUNCTION ReplaceNonAlphaNumerics(aString,aReplaceChar) AlphaNumerics ...
by ray.wurlod
Thu Mar 07, 2013 11:56 pm
Forum: IBM QualityStage
Topic: Reference Match Input Considerations
Replies: 12
Views: 5346

A reference match can be (and often is) against the database.
by ray.wurlod
Thu Mar 07, 2013 1:44 pm
Forum: General
Topic: dsjob command failed
Replies: 7
Views: 4343

Check that Engine credentials (set in Web Console for Information Server - Domain Management > Engine Credentials) are set correctly.
by ray.wurlod
Thu Mar 07, 2013 1:41 pm
Forum: General
Topic: Help on Error Code 39202
Replies: 4
Views: 2044

Check that the Engine credentials, set up in the Web Console for Information Server (Domain Management > Engine credentials) are set up correctly.
by ray.wurlod
Thu Mar 07, 2013 1:39 pm
Forum: General
Topic: How to identify all job names using local handlers
Replies: 3
Views: 1525

Local Message Handlers OnlyUse find to determine the location of each Local.msh file.
Get the job number from SCnnnn in its pathname.
Look up the job name in DS_JOBS.

However, if you're using named message handlers the above method won't work.
by ray.wurlod
Thu Mar 07, 2013 1:36 pm
Forum: General
Topic: IS 9.1 on Linux RHEL 6.4 Installing error
Replies: 5
Views: 2435

Try opening Firefox on the Linux machine.