Search found 520 matches
- Wed Nov 03, 2010 3:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataSet rejecting null records
- Replies: 7
- Views: 7428
- Wed Nov 03, 2010 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 load error
- Replies: 2
- Views: 1953
- Wed Nov 03, 2010 1:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: This is about CDC stage
- Replies: 3
- Views: 3347
- Wed Nov 03, 2010 1:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How would you "over-partition" your data?
- Replies: 7
- Views: 3198
- Wed Nov 03, 2010 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create Unicode file for SAP Bapi RFM
- Replies: 6
- Views: 6001
BOM or Byte Order Mark will be added by default when using Notepad and writing UTF-8. No such behavior is present with Unix since files in Unix can be multi purpose and the BOM may interfere with processing correctness. The BOM is usually at the beginning of the stream to let the receiving appliatio...
- Wed Nov 03, 2010 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataBase loading
- Replies: 20
- Views: 6711
- Wed Nov 03, 2010 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataBase loading
- Replies: 20
- Views: 6711
- Wed Nov 03, 2010 6:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataBase loading
- Replies: 20
- Views: 6711
- Tue Nov 02, 2010 3:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: job status information for multi instance Jobs
- Replies: 2
- Views: 2605
- Wed Oct 27, 2010 2:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pad leading zeroes to a smallint field
- Replies: 9
- Views: 5658
- Wed Oct 27, 2010 8:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector - enable partitioning
- Replies: 3
- Views: 2959
thanks where in the sql do we put this? NODENUMBER(partition_key)=CURRENT NODE Also want to mention we have a dpf environment, didn't know if that makes a difference. SELECT COL1, COL2 FROM TABLE WHERE NODENUMBER(COL1)=CURRENT_NODE Choose Uncommitted Read in the stage and yes this is syntax specifi...
- Tue Oct 26, 2010 3:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector - enable partitioning
- Replies: 3
- Views: 2959
in your sql statement (if user defined) do you have the NODENUMBER(partition_key)=CURRENT NODE dbpartitionnum will work too The stage is running parallel in the sense of ETL - one db2 connector pid for each node in the configuration. The sql statement gets handed off to an instane on the dpf server ...
- Tue Oct 26, 2010 2:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Protected Project
- Replies: 14
- Views: 5121
- Tue Oct 26, 2010 2:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: VarChar Memory Usage
- Replies: 14
- Views: 9328
Hi folks, looks like everyone is getting on board with the unbounded varchar idea for reducing memory and disk consumption. Thanks, Doug I would not go so far as to say this. That is certainly not IBM's take on character string handling. The framework of DataStage moves fixed width data regardless ...
- Mon Oct 25, 2010 1:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pad leading zeroes to a smallint field
- Replies: 9
- Views: 5658