Search found 763 matches
- Thu Jun 23, 2005 12:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: replace mm/dd/yyyy with mm/01/yyyy
- Replies: 6
- Views: 2103
- Thu Jun 23, 2005 11:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File Stage in PX
- Replies: 4
- Views: 2736
One final note - the goal of multiple readers is to take advantage of multiple nodes - instead of one single stream of data, you have as many as there are readers. On the other hand, if you are using either filesets or the file pattern, you will already be taking advantage of multiple nodes - one pe...
- Thu Jun 23, 2005 11:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Easy Buildop
- Replies: 4
- Views: 2116
transferRecord(); outputRecord(); You don't need these unless you are trying manually write to the output link. If you have autowrite on/true, then you don't need this. We use these function with autowrite off/false when we have a 1-to-many relationship between input and output records (ex. splitti...
- Thu Jun 16, 2005 9:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Terawrite worked once, now won't work again
- Replies: 5
- Views: 5067
- Wed Jun 15, 2005 4:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Invalid string or buffer length. SQLSTATE=HY090
- Replies: 7
- Views: 7918
- Mon Jun 13, 2005 10:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Make Vector Stage
- Replies: 5
- Views: 2780
- Fri Jun 10, 2005 2:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update Job Design: Comments?
- Replies: 10
- Views: 5737
Hi lshort, Look into the CDC stage. The documentation in parjdev.pdf gives additional information on CDC stage. It is used to identify new inserts, updates as well as deletes. Rich Pardon a potentially dumb question. What is the CDC Stage? I couldn't find references to it in the parjdev manual. Is ...
- Fri Jun 10, 2005 2:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Column Generator : Column Method = Schema File
- Replies: 5
- Views: 1912
Hi, The stage you need is PxSurrogateKeyGenerator not column generator, column generator is a dev/debug tool. IHTH, Is there a reason why the Column Generator should not be used outside of development? Just wondering... From what I've seen, the Column Generator is far more flexible than the PxSurro...
- Thu May 26, 2005 3:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Terawrite worked once, now won't work again
- Replies: 5
- Views: 5067
- Thu May 26, 2005 3:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata write created hundreds of sessions
- Replies: 3
- Views: 4747
Well, unfortunately, it really is a (slow!) single node 7-AMP system: *** Query completed. 7 rows found. 2 columns returned. *** Total elapsed time was 1 second. vproc count ------ ----------- 0 1973 1 1848 2 1848 3 1847 4 1848 5 1846 6 1847 So, how did you come up with 16 for RequestedSessions and ...
- Thu May 26, 2005 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Commit Frequency
- Replies: 8
- Views: 4214
- Wed May 25, 2005 10:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: User Defined Query
- Replies: 4
- Views: 1714
You can put a query in a parameter, but you will probably run into a similar problem due to the length of the query. Off the top fo my head, I don't know what the max length of a parameter is but I'd be willing to bet that it is shorter than your query. Another possibility, one that my project uses ...
- Tue May 24, 2005 2:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: User Defined Query
- Replies: 4
- Views: 1714
There are many options 1) You could embed the query in a view and use the same DB2 read stage, just accessing the view instead of running the actual query. 2) Put the query into a stored procedure and return a result set. Not sure which version of PX you are using, but I think hte latest (7.5) has a...
- Tue May 24, 2005 2:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Terawrite worked once, now won't work again
- Replies: 5
- Views: 5067
Unfortunately I already thought of that (sorry, didn't mention it in the first posting). The tables I found were <database>.terasync and <database>.ORCH_WORK_######## (where #'s appear to be a generated unique id per execution). Are those the tables you were thinking of? I have tried running both wi...
- Tue May 24, 2005 9:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: More problems with Pesky Floats
- Replies: 15
- Views: 7415
Can I add a final note? We are a banking institution as well and all our numbers are stored as decimal. For performance and Torrent conversion issues, we do not use Transforms, we use buildops. If we do calculations, we convert temporarily to float and then back to decimal. As a very simple example,...