The following may help you:
stageVar1 = If IsNull(src A) Then "" else If Trim(src A) = "" Then "" else Trim(src A)
stageVar2 = StringToDecimal(stageVar1)
Handle the null values with the first stage variable, and work with the second stage variable for your fields.
Search found 7 matches
- Tue Apr 21, 2009 1:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Record with Null getting dropped for Nullable col in PX 7.5.
- Replies: 11
- Views: 7011
- Wed Oct 17, 2007 5:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DsExecute for executing stored procedure.
- Replies: 3
- Views: 2261
- Tue Oct 16, 2007 11:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How Oracle Enterprise stage reformats SQL with /*+rowid(p)*/
- Replies: 4
- Views: 1668
- Tue Oct 16, 2007 11:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar is not trimming spaces while loadding to oracle EE
- Replies: 3
- Views: 1932
- Tue Oct 02, 2007 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Is there a limit on Oracle Stages
- Replies: 1
- Views: 1080
Is there a limit on Oracle Stages
I posted by mistake in the Server Editioin Forum. I would like to know if anyone knows whether there is a limit on the number of Oracle stages you can have in one job. I have a job that has 18 Oracle stages on it, and I am getting a very weird error that doesn't indicate anything. The error is: main...
- Tue Oct 02, 2007 8:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is there a Limit on Oracle Stages
- Replies: 2
- Views: 1211
- Tue Oct 02, 2007 8:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is there a Limit on Oracle Stages
- Replies: 2
- Views: 1211
Is there a Limit on Oracle Stages
I would like to know if anyone knows whether there is a limit on the number of Oracle stages you can have in one job. I have a job that has 18 Oracle stages on it, and I am getting a very weird error that doesn't indicate anything. The error is: main_program: Could not check all operators because of...