I have one PowerBuilder application that uses embedded SQL to change the context to a different database using the transaction object.
Execute Immediate "Use Database_Name";
where Database_Name is the database name
But when this application is deployed on PowerServer Web and executed, the above statement shows error and can be verified using the error log. Below is the error:
"Stored Procedure 'Use' not found"
My question is whether we can point to a different database using this embedded SQL for a PowerServer deployed application.
PowerBuilder 2019 R2 Build 2353
PowerServer (PB Edition) 2020 Build 2323 64 Bit
Windows Server 2012 R2
.Net Application server
Sybase ASE 16