Search found 1274 matches
- Fri Jun 14, 2013 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in using @INROW function
- Replies: 9
- Views: 5302
With any partitioning scheme running on two or more nodes you are not guaranteed that there will be no holes...it's just the nature of assigning a partition-based calculated value in a multi-process environment. Round-robin will evenly distribute so long as the number of rows is a multiple of the nu...
- Thu Jun 13, 2013 12:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data initialization
- Replies: 10
- Views: 3915
- Wed Jun 12, 2013 12:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data initialization
- Replies: 10
- Views: 3915
Possible options: 1) Don't run the job if the dataset is empty (a job sequence can control this) 2) Retrieve the timestamp from the sequential file and pass it into the job (job parm, copy of the sequential file, etc.), creating a dummy record with that value and combining it with the records from t...
- Mon Jun 10, 2013 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup output values
- Replies: 9
- Views: 4846
- Fri Jun 07, 2013 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to connect to Oracle Connector
- Replies: 9
- Views: 11796
- Fri May 31, 2013 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Binary datatype issue
- Replies: 13
- Views: 4915
This looks to me to be an issue with unicode vs non-unicode string data. The example from IS 8.5 appears to be a unicode string (2+ bytes-per-character), while the DS 7.5 example appears to be a non-unicode string (1-byte-per-character). As you're moving from Windows to Linux: how was the source fil...
- Wed May 29, 2013 8:41 pm
- Forum: General
- Topic: It took more than ten years
- Replies: 11
- Views: 7058
- Wed May 29, 2013 10:06 am
- Forum: General
- Topic: DataStage Parallel Routine -- Compile Location
- Replies: 6
- Views: 8245
You selected Windows as the operating system when you originally started the thread, thus people's answers will generally be with regards to that choice. Just be as clear as possible with accurate information when you start a new thread in the future :) Why not simply use SFTP directly from one serv...
- Sat May 18, 2013 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: need logic to achieve requirement
- Replies: 5
- Views: 3476
In v8.5 or above of DataStage, you can accomplish this with a sort and a 2-pass loop in a parallel transformer. In any version, you can accomplish this with a transformer-sort-transformer combination. v8.5+: Partition/Sort on id In the Transformer: Loop Iteration 1: Determine if India is present in ...
- Fri May 17, 2013 9:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Doubt on partitioning
- Replies: 3
- Views: 3027
If the reference data is NOT Entire partitioned, then only certain reference records will be in certain partitions--this is the essence of partitioning--and the input dataset will need to be identically partitioned in order to match data together. The same is true of the Join and Merge stages. By us...
- Wed May 15, 2013 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: not able to convert string to time stamp
- Replies: 4
- Views: 2708
Check the validity of your format string against the specifications in the product documentation. Pay close attention to the valid formats for month.
Date Formats
Regards,
Date Formats
Regards,
- Tue May 14, 2013 12:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup issue
- Replies: 14
- Views: 7729
- Tue May 14, 2013 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator stage internal processing
- Replies: 4
- Views: 2036
No, it means just as Ray indicated: It does a count on each node that Agreggator is executing on. If you need a single count across all nodes, you must run an Aggregator (or other stage) in a single node (i.e. sequential) in order to combine the counts. Aggregator is no different from other parallel...
- Thu May 09, 2013 2:36 pm
- Forum: General
- Topic: datastage 8.7 installation on windows 8
- Replies: 10
- Views: 10405
- Thu Apr 25, 2013 10:12 am
- Forum: General
- Topic: AIX Unable To Detect DataStage Process
- Replies: 18
- Views: 7771