September 22, 2023 at 9:57 am
We are working on a project to migrate a client from a version of SAP Sql Anywhere (Sybase) to SQL Server 2022.
However, we have encountered a challenge.
The current application calls stored procedures and passes parameters, e.g.
CALL TheStoredProc @a, @b-2+@c, @d
However, to my knowledge, SQL cannot receive parameters that contain mathematical operators.
Does anyone know how we can get this working (we are not allowed to change the vendor's application).
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
September 22, 2023 at 10:31 am
If that is the syntax that the app will use, and you cannot change it, won't it fail anyway, because of the 'CALL'?
September 22, 2023 at 11:29 am
you will need to speak with vendor - and see if the application is already prepared to work with SQL Server instead of Sybase. It may well be just a case of installing a different version of the application or maybe changing configurations (or a reinstall with SQL Server as the target db)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy