Search found 53125 matches
- Wed May 04, 2005 9:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple server version in same host
- Replies: 5
- Views: 1967
Version 4 keys were of the form 0xace... Version 7 keys are of the form 0xade... So, yes, there would be no clash in shared memory identifiers. And the "location" file is /.uvhome versus /.dshome, so that's OK too. Not so sure about /.unishared, though - would version 7 pick this up if it were there...
- Wed May 04, 2005 9:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic Relational Stage
- Replies: 2
- Views: 1313
- Wed May 04, 2005 6:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to view Design info
- Replies: 2
- Views: 712
Job number 2 has not been cleanly deleted from the project. You need the Cleanup Project button that "they" have removed from the Adminstrator client. Since you don't have it, use the DS.TOOLS menu on the server, and execute options 2 and 4. At a pinch, use the CLEAN.ACCOUNT utility, which will crea...
- Wed May 04, 2005 6:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: job run limits!!
- Replies: 7
- Views: 1306
- Wed May 04, 2005 6:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom users or processes
- Replies: 2
- Views: 885
- Wed May 04, 2005 6:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Version Control
- Replies: 6
- Views: 2184
Version Control client is on your DataStage clients CD, separately installable (but no extra licensing). You will also need to create a separate project in which the versioned objects can be stored. The version number's minor number is incremented by a promotion (e.g. 50.0.0 to 50.1.0) UNLESS the te...
- Wed May 04, 2005 5:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Missing Column in Hash File
- Replies: 14
- Views: 2816
- Wed May 04, 2005 5:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: RESIZE 32 to 64
- Replies: 11
- Views: 8640
- Wed May 04, 2005 2:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Hashed File Calculator
- Replies: 8
- Views: 3065
- Wed May 04, 2005 2:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem while Running a Parallel Job
- Replies: 4
- Views: 1964
- Wed May 04, 2005 2:00 am
- Forum: IBM QualityStage
- Topic: Error while running QS job from DS
- Replies: 2
- Views: 2553
- Wed May 04, 2005 1:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TCP ports used by DataStage?
- Replies: 3
- Views: 2235
- Mon May 02, 2005 9:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage has a new name!
- Replies: 9
- Views: 2662
- Mon May 02, 2005 9:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trimming 'Carriage Return' from data in a column
- Replies: 5
- Views: 2216
Slightly more efficient, so that you're not evaluating the Char functions for every row, would be to initialize two stage variables, say svChar10 and svChar13. The expression then becomes
Code: Select all
Convert(svChar10:svChar13,"",InLink.TheString)- Mon May 02, 2005 9:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trimming 'Carriage Return' from data in a column
- Replies: 5
- Views: 2216
Are you SURE it's a Carriage Return?
Could it be Line Feed?
Could it be a Windows line terminator (both)?
You can represent these by Char(13) and Char(10) in an expression such as
Could it be Line Feed?
Could it be a Windows line terminator (both)?
You can represent these by Char(13) and Char(10) in an expression such as
Code: Select all
Convert(Char(13):Char(10),"",InLink.TheString)