Search found 395 matches
- Thu Jun 27, 2013 5:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: AsInteger function produces output minus 1
- Replies: 1
- Views: 2077
Update... The suspicion around breaching the bigint threshold proved unfounded, the same issue was also seen with lower values in lower ranges. The conclusion reached with the vendor showed that the same behaviour also exists in 9.1 and the solution is to perform only AsInteger on the inbound field ...
- Fri Jun 21, 2013 8:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use of peak stage
- Replies: 3
- Views: 3109
- Fri Jun 21, 2013 2:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to reject junk or unknown values
- Replies: 5
- Views: 2764
- Thu Jun 20, 2013 3:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to convert into decimal format
- Replies: 7
- Views: 3738
I'm slightly intrigued as to why there is a reference to decimal_from_ustring in there for a varchar - are you using extended metadata options? I wouldn't be surprised also if, under the covers, your transformation is going from a varchar to another datatype in an intermediate variable, before being...
- Tue Jun 18, 2013 4:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing two dynamic data files with header using datastage
- Replies: 4
- Views: 3039
For the handling part, unless I am misunderstanding something, it seems relatively simple. Does the required/expected number of columns not remain the same? If so, a count of the columns in the header can be checked. A failure to match can result in the process exiting as a failure, which you can ha...
- Tue Jun 18, 2013 4:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing two dynamic data files with header using datastage
- Replies: 4
- Views: 3039
- Mon Jun 17, 2013 4:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: AsInteger(StringToDecimal(Field1)) producing output -1
- Replies: 3
- Views: 3214
- Thu Jun 13, 2013 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best way to search through a DataSet
- Replies: 7
- Views: 4475
- Thu Jun 13, 2013 2:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: AsInteger function produces output minus 1
- Replies: 1
- Views: 2077
AsInteger function produces output minus 1
Hi all, To correlate that this issue also occurs in 7.5x, please also refer to http://www.dsxchange.com/viewtopic.php?t=107493 In our case we saw the same behaviour in 8.1. The incoming field is a Varchar (19) from a sequential file. A transformer performs the below derivation in an output link: AsI...
- Mon Nov 28, 2011 10:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Syncsort
- Replies: 0
- Views: 1189
Syncsort
Hi all, Has anyone had any experiences of this product when using it as a plugin to IIS Datastage v8 please? I'm particulary interested in any experiences that can show a cross-comparison of the 'before and after', to include system usage footprint and elapsed time or any other relevant measures. Th...
- Mon Jan 17, 2011 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Node Concern..
- Replies: 3
- Views: 2583
- Mon Jan 17, 2011 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Node Concern..
- Replies: 3
- Views: 2583
- Mon Jan 17, 2011 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: User maintained MQTs
- Replies: 1
- Views: 1759
User maintained MQTs
We have one of these in our environment and have found that when trying to import the table definition it cannot be viewed, only tables and views can be found when using the plug in metadata definitions (DB2). The same appears to hold true in v7x and v8.1. As such, it means the user maintained MQTs ...
- Mon Jun 28, 2010 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capturing user log-on and log-off activity from Datastage
- Replies: 12
- Views: 5207
- Fri Jun 25, 2010 9:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capturing user log-on and log-off activity from Datastage
- Replies: 12
- Views: 5207
Hi Mark, Did you try enabling the server trace option from the Administrator Client? And at unix server level also we can capture the log file I think, because we are doing it in our AIX server. Hi Tony, Which 'log file' are you referring to here please? Our o/s is also AIX. I haven't yet looked at...