Search found 6 matches

Go to advanced search

by akbar2002
Sat Nov 20, 2010 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove leading zeros in decimal field in sequential file
Replies: 26
Views: 79090

Yes, made a typo. Sorry about that
SV1 : DecimalToString(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar

Derivation : SV2:'.':SV3 --> DataType = VarChar
by akbar2002
Sat Nov 20, 2010 6:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert value from -00005.55 to -5.55
Replies: 17
Views: 9151

ray.wurlod wrote:Did you mean DecimalToString() ?
Yes, made a typo. :oops: Sorry about that
SV1 : DecimalToString(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar

Derivation : SV2:'.':SV3 --> DataType = VarChar
by akbar2002
Sat Nov 13, 2010 12:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove leading zeros in decimal field in sequential file
Replies: 26
Views: 79090

SV1 : StringToDecimal(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar

Derivation : SV2:'.':SV3 --> DataType = VarChar
by akbar2002
Sat Nov 13, 2010 12:57 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Decimal to String conversion in a rule
Replies: 2
Views: 3222

:idea: Read it as Integer or Bigint. It will do the trick.

Let us know if it works.
by akbar2002
Sat Nov 13, 2010 12:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert value from -00005.55 to -5.55
Replies: 17
Views: 9151

SV1 : StringToDecimal(column_name) --> DataType = VarChar SV2 : Field(SV1,'.',1) --> DataType = Integer SV3 : Right(SV1,2) --> DataType = VarChar Derivation : SV2:'.':SV3 --> DataType = VarChar Let me know if you see find any issues Zak
by akbar2002
Tue Aug 17, 2010 11:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete data from an Oracle table Error
Replies: 4
Views: 3182

Re: Delete data from an Oracle table Error

Did you put "Write Method = Delete Rows" in Input > Properties > Target ?

Go to advanced search