For Alpha:
Convert('<Enter all other Non-Alpha characters> ','',FieldName)
For Non-Alpha :
Convert('<Enter all Alpha Characters>','',FieldName)
Thanks,
Madhu
Search found 35 matches
- Thu Apr 05, 2007 3:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading the Target
- Replies: 13
- Views: 4553
- Wed Apr 04, 2007 5:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp
- Replies: 14
- Views: 5462
- Wed Apr 04, 2007 5:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Project Permissions on AIX
- Replies: 6
- Views: 2540
- Wed Apr 04, 2007 5:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: transform rows to columns end record value to null
- Replies: 8
- Views: 3448
- Wed Apr 04, 2007 4:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify Stage Column Name Change
- Replies: 9
- Views: 20782
- Wed Apr 04, 2007 4:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stage types vanished
- Replies: 4
- Views: 2645
- Wed Apr 04, 2007 4:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: handling decimals
- Replies: 6
- Views: 2911
- Wed Apr 04, 2007 4:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence number in Oracle DB
- Replies: 5
- Views: 2294
- Mon Apr 02, 2007 12:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fixed width in Seq file
- Replies: 15
- Views: 8026
- Mon Apr 02, 2007 12:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: unable to insert data into a table
- Replies: 7
- Views: 4517
- Mon Apr 02, 2007 12:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Warnings Turn OFF @ Project level
- Replies: 8
- Views: 3360
- Mon Apr 02, 2007 12:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: unable to insert data into a table
- Replies: 7
- Views: 4517
- Mon Apr 02, 2007 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Determine the month difference between 2 dates
- Replies: 5
- Views: 6031
- Wed May 10, 2006 3:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Number Of Stage Variables
- Replies: 2
- Views: 2263
Number Of Stage Variables
Hi,
Can any one tell Maximum number of stage variables Used in Parallel Transformer?
Thanks,
Madhu
Can any one tell Maximum number of stage variables Used in Parallel Transformer?
Thanks,
Madhu
- Wed Apr 19, 2006 3:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Usaing XML Stage
- Replies: 1
- Views: 1491
Usaing XML Stage
Hi,
Please give the steps to be followed while creating XML file using Datastage.
Thanks,
Madhu
Please give the steps to be followed while creating XML file using Datastage.
Thanks,
Madhu