Search found 4 matches
- Wed Oct 01, 2008 1:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do we Remove Alphanumeric characters
- Replies: 4
- Views: 1775
Team i Got the Solution ..Thanks For ur Time
In the transformer i have used the Convert Function
- Wed Oct 01, 2008 12:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do we Remove Alphanumeric characters
- Replies: 4
- Views: 1775
How do we Remove Alphanumeric characters
Team, Im getting data from a sequential file. My Columnname is "Name" which is varchar(20). Suppose if the data is like ricky.johnson i need to pass it as rickyjohnson. I need to remove all the special characters from the Source. Please help me Regd This. Thanks in Anticipation.
- Thu Sep 25, 2008 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How To Change the Length Of a Column In ModifyStage
- Replies: 2
- Views: 1255
How To Change the Length Of a Column In ModifyStage
Hi, My Input is A Column Length of 16 ..I need to do a look up.The lookup column length is 20. I have to change the lookup column length from 20 to 16 in the modify stage. then i want to perform the lookup. Can you please tell me the syntax of how to do that in MODIFY STAGE in the specification. Tha...
- Thu Sep 25, 2008 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regd An Error Calling a Routine
- Replies: 7
- Views: 2278
Regd An Error Calling a Routine
Hi, At my Sequence level,im calling a Routine which will call a Script that calculates a Date value. The Sequence is getting aborted And there is warning as Follows " MIS_BAHTNET_EDW_SUM_TXN_MIS_SSeq..JobControl (@Validate_Postdate): Controller problem: Unhandled failure (20061130) encountered ...