Search found 53125 matches
- 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
- 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- 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...
- 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
- 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")- 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
- 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
- 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
- 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
- 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
- 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.
- 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
- 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
- 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- Fri Apr 23, 2010 4:33 pm
- Forum: General
- Topic: CheckSum() Function
- Replies: 11
- Views: 7878