DSXchange

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 No need to check the rest 123456|789.12 123456|789.01 | = cut point 123456 = 123456 compare 789.12 with 789.01 normal substract...

asitagrawal wrote: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 comparing? Are the numbers that large?

We have Datastage 7.5.1 (no A mentioned) running on Windows 2000.

I can't find a 'smat' executable on the client.

I get these results.

It seems that my results are as expected.

We're using Datastage server 7.5.1 on windows. Maybe there's a bug in your version?

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?

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 keep using in every project and might be usefull for others too. And if a specific code snippet isn't post...