Search found 459 matches
- Fri May 13, 2005 11:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error in viewing the data
- Replies: 3
- Views: 2763
- Fri May 13, 2005 11:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Thousands separator
- Replies: 3
- Views: 2863
- Fri May 13, 2005 11:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using GNU c++ compiler with PX
- Replies: 11
- Views: 8417
For AIX, I'm struggling to get a straight answer on the cost of the compiler. I've seen per user and per processor options. Per user is pricey, but not that pricey compared with DataStage. Per (named) user, on the other hand, wouldn't sit well with the DS Designer concurrent user licensing model. I...
- Fri May 13, 2005 10:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Designer eats 100% CPU and is very slow
- Replies: 9
- Views: 4765
- Fri May 13, 2005 10:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Solaris 5.10
- Replies: 10
- Views: 4599
That is not a fair attitude to have when we are dealing with an operating system. It is like saying that Windows 2000 and Windows XP are not much different. Ascential made a point on specifically saying what is supported and what is not. If you are able to get something to work on something that is ...
- Fri May 13, 2005 10:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key generator
- Replies: 2
- Views: 2135
The surrogate key generator always starts at 1, unless you provide it with an alternative value (using a parameter, perhaps), pull the latest value from somewhere (the database, perhaps), and doing the calculation in a transformer. There are several solutions. The problem you had was that you think ...
- Fri May 13, 2005 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [Help] Fatal error
- Replies: 22
- Views: 8771
- Thu May 12, 2005 5:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Data from Dataset
- Replies: 3
- Views: 2395
- Thu May 12, 2005 4:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Merging 2 files with specail handling if there is a match
- Replies: 2
- Views: 2149
Use the Change Capture Stage. Chapter 30 on your Parallel Job Developer Guide (parjdev.pdf). Handle the results on the following filter stage/transform stage. For fields that are not used, you can use a merge stage to combine those into the main stream after the Change Capture stage. Correction: Now...
- Thu May 12, 2005 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i want to add hours to timestamp .
- Replies: 9
- Views: 4324
Code: Select all
TimeFromMidnightSeconds(((HoursFromTime([input time]) * 3600) + (MinutesFromTime([input time]) * 60) + SecondsFromTime([input time])) + [hours * 3600])
- Thu May 12, 2005 4:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i want to add hours to timestamp .
- Replies: 9
- Views: 4324
- Thu May 12, 2005 4:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: surroagte key geneartor error
- Replies: 2
- Views: 2289
Make sure your metadata for input and output are correctly defined. That's all. Edit: RCP would not trigger this bug unless there was a pre-existing name being propagated. Considering that it's an string, not a number field (which Surrogate Key Generator stage only generates), this is an unlikely ca...
- Thu May 12, 2005 4:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stage variable usage
- Replies: 4
- Views: 2744
- Thu May 12, 2005 4:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Data from Dataset
- Replies: 3
- Views: 2395
When you are dealing with integers, you can give it any precision numbers you want, but... Datastage will ignore the precision number when it handles Integers. If you MUST have a specific length for numbers, either use Varchar, or Decimal. Integers are exactly the same as C's Integers. P.S. Integers...
- Thu May 12, 2005 4:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading rows using schema file
- Replies: 5
- Views: 3729
DataStage is dumb. Dumb. Dumb dumb dumb. It does not read minds. It does not know what the intent of something is. It does not know what is right, what is wrong, where things are, and where things should be. Keep that in mind, and whenever you tell DataStage to do something, you have to tell it ever...