DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 6 matches
Author Message
 Topic: Conversion from string to decimal
coolbin81

Replies: 2
Views: 1762

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 12, 2009 12:06 am   Subject: Conversion from string to decimal
Thanks Ray.
 Topic: Conversion from string to decimal
coolbin81

Replies: 2
Views: 1762

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 10, 2009 6:17 am   Subject: Conversion from string to decimal
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi all,

In one of my jobs, i am converting a field from string to decimal and then using this in the constraint. For eg: StringtoDecimal(Trim(Inputfield)) <> 0.0

I am getting the following ...
Resolved
 Topic: Use of special characters as delimiter in sequential file
coolbin81

Replies: 13
Views: 8156

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 08, 2006 9:05 pm   Subject: Use of special characters as delimiter in sequential file
Thanks a lot guys for your help!
Resolved
 Topic: Use of special characters as delimiter in sequential file
coolbin81

Replies: 13
Views: 8156

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 07, 2006 4:06 pm   Subject: Use of special characters as delimiter in sequential file
When we try to use the special character ý and compile the job, it gives the following error:

Property value cannot contain UniVerse mark characters.
Property name is: Value
Invalid data is : fi ...
Resolved
 Topic: Use of special characters as delimiter in sequential file
coolbin81

Replies: 13
Views: 8156

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 07, 2006 1:36 pm   Subject: Use of special characters as delimiter in sequential file
These solutions don't work! Typing 253 or ý (with or with escape character '\') in delimiter string option doesn't help either! And using normal delimiter option will allow us to enter only a single ...
Resolved
 Topic: Use of special characters as delimiter in sequential file
coolbin81

Replies: 13
Views: 8156

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 07, 2006 8:48 am   Subject: Use of special characters as delimiter in sequential file
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,
We have an input flat file with ý ( ASCII char 253) as the field delimiter.
How can i get DataStage to read this character as delimiter? I tried copy pasting it to the sequential file stage but ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours