I am calling a Sybase stored procedure X from another stored procedure Y. Following the answer to a similar question , I create a #tmp_table to hold the results
Basically in the installation SDK of Sybase 16 we have jconn4.jar and jconn42.jar. What is the difference between jconn4.jar and jconn42.jar?
I have a string: "16680,16678,16677,16676,16675,16672" Which I got from the Stored procedure passed parameter while calling it. I want to insert these records
I have the following query: SELECT TOP 1000 * FROM MyTable WHERE Status = 'N' AND Type is not null ORDER BY mytable.id MyTable has 130 million rows. I also
How to pass TEXT(the list of id's as a string as I have long list of id's) to sybase ase stored procedure call? If I want to pass TEXT to stored procedure call
I have a query that works in Sybase SQL Anywhere 11 that I need to compile in SAP Adaptive Server Enterprise 16. The code doesn't want to compile in ASE though,
I am literaly following the SAP documentation 1st example on UPSERT a record in ASE: https://help.sap.com/viewer/cbed2190ee2d4486b0bbe0e75bf4b636/16.0.3.2/en-US
I am trying to move from a Windows-based pyodbc (Using the SAP Adaptive Server Enterprise 16.0 driver) to Red Hat Linux 7.9-based sybpydb solution. Current pyod
Anyone know how I can check if a role already exist in a Sybase database ... i have the name of the role There is a sysroles table but no name column! select