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'?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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)
September 22, 2023 at 4:23 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply