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