DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 6 matches
Author Message
 Topic: String maths
robvonk

Replies: 18
Views: 4395

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Aug 22, 2007 8:44 am   Subject: String maths
If it's only to see if there are differences:

Cut the string in pieces.


For example:


123456|789.12 vs 6|789.01

| = cut point

12345 is larger than 6 so you have a difference

N ...
 Topic: String maths
robvonk

Replies: 18
Views: 4395

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Aug 22, 2007 7:30 am   Subject: String maths
smat.exe is available in ..\Ascential\DataStage\Engine\Bin\

I'm a developer and have no access to the server.. I'm affraid i can't help you with smat output.

Do you really need the SSUB for comp ...
 Topic: String maths
robvonk

Replies: 18
Views: 4395

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Aug 22, 2007 6:13 am   Subject: String maths
We have Datastage 7.5.1 (no A mentioned) running on Windows 2000.

I can't find a 'smat' executable on the client.
 Topic: String maths
robvonk

Replies: 18
Views: 4395

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Aug 22, 2007 3:46 am   Subject: String maths
I get [url=http://www.capire.nl/fileadmin/capire/datastage/ssub_test.gif]these results.

It seems that my results are as expected.

We're using Datastage server 7.5.1 on windows. Maybe there's a b ...
 Topic: String maths
robvonk

Replies: 18
Views: 4395

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Aug 22, 2007 2:27 am   Subject: String maths
I tried the 'Ans = SSUB(1234567890.12,1234567890.2)' code in a routine and it gives back 0.08 correctly.

Are you trying to put it into an integer?
 Topic: New subforum 'Code Snippets'
robvonk

Replies: 1
Views: 1817

PostForum: Site/Forum   Posted: Wed Aug 22, 2007 2:07 am   Subject: New subforum 'Code Snippets'
Hi there,

I think the forum would benefit from a 'Code snippets' subforum. A place where people can post/request routines, transforms or other code.

I've created some routines for myself that i ...
 

 Jump to:   



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