Search found 53125 matches

by ray.wurlod
Sun Apr 25, 2010 9:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read "Parameter Set" through Unix
Replies: 8
Views: 2686

Not that way. Does the Parameter Set have values files?
by ray.wurlod
Sun Apr 25, 2010 9:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Validation Criteria
Replies: 5
Views: 1496

DataStage can do all this in one expression although, for ease of maintenance, you may like to break it up into stage variables.

Code: Select all

Len(InLink.The String) <> 12 Or Index(InLink.TheString, " ", 1) > 0 Or Len(Convert("0123456789","",InLink.TheString)) <> 0
by ray.wurlod
Sat Apr 24, 2010 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is the default of DSJobStartDate
Replies: 3
Views: 5805

DSJobStartDate invoked from a Transformer stage is a Date. Therefore it has no default format or, indeed, any format - it's stored as a binary quantity. The only way to get a format is to convert the date to a string, for which the appropriate function in a Transformer stage is StringToDate() - or i...
by ray.wurlod
Sat Apr 24, 2010 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: which format the export file stored
Replies: 3
Views: 1629

And be careful to realise that it's not a "dsx" file per se. "dsx" files are produced by DataStage export utilities. Information Server Manager (istool) produces a compatible file IF the file only contains DataStage components, but the utility can create deployment packages conta...
by ray.wurlod
Sat Apr 24, 2010 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use Modify stage for converting null string to empty string
Replies: 4
Views: 2513

The function is handle_null().

Code: Select all

outcolumn=handle_null(incolumn,"value")
by ray.wurlod
Sat Apr 24, 2010 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is the main use hashing & modulus algorithm? and wh
Replies: 1
Views: 743

Tell us what language it is, and maybe you'll have a chance. It's not English, I can attest to that. You have made five "rubbish posts" today. "hi" is neither a sensible subject nor text. DSXchange is a community of professionals, and we react badly to unprofessional practices. W...
by ray.wurlod
Fri Apr 23, 2010 4:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Double Byte character
Replies: 5
Views: 1880

Moderator: please move to Server forum
by ray.wurlod
Fri Apr 23, 2010 4:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert Double datatype to Decimal from the Aggregat?
Replies: 3
Views: 1479

That's true. When Count is the operation you have to accept Double as the output data type (or tolerate the warning message). You can change it with a downstream stage, such as a Modify stage.
by ray.wurlod
Fri Apr 23, 2010 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Enterprise stage error
Replies: 2
Views: 3271

Is /tmp file system full? Is the executing process unable to write to /tmp?
by ray.wurlod
Fri Apr 23, 2010 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: operator combinability
Replies: 3
Views: 1560

eCollectAny means that, if a collector is required, (Auto) will be the algorithm used. op0, op1,... are simply generic names for operators. Actual names can be determined in the operators section. 1p means "one process", 2p means "two processes" on the node. p0, p1, ... are simpl...
by ray.wurlod
Fri Apr 23, 2010 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer error
Replies: 1
Views: 1022

Start by disabling operator combination so that you can at least determine which stage (operator) is throwing the error. Then Search DSXchange for the text of the error message.
by ray.wurlod
Fri Apr 23, 2010 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: imporing version 8 dsx in 7.5.3
Replies: 2
Views: 926

You may get warnings if there are any version 8 features in the export that are not supported in version 7.5.3.
by ray.wurlod
Fri Apr 23, 2010 4:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error loading data from csv into sql server 2005
Replies: 2
Views: 1210

Welcome aboard.

Are you sure this is a blank? Could it be some non-printing character, such as a line terminator character?
by ray.wurlod
Fri Apr 23, 2010 4:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to check for numeric characters field by field
Replies: 3
Views: 2387

Craig is right, and you can do all the matches using a multi-valued second argument. Put the pattern in a stage variable for ease of maintenance.

Code: Select all

svAreaCodePattern  <--  "'US'3N" : @VM : "'US'1A2N"

Link.AREA_CODE Matches svAreaCodePattern
by ray.wurlod
Fri Apr 23, 2010 4:33 pm
Forum: General
Topic: CheckSum() Function
Replies: 11
Views: 7878

Once the Routine exists, and has been compiled successfully, it will appear in the expression editor in the DSRoutines menu. Simply select it from there. Make sure you create a transformation function, not a before/after subroutine.