Questions tagged [sybase]

Use this tag for questions related to products from Sybase Corporation - please also include the product tag, such as sybase-ase or sql-anywhere.

Filter by
Sorted by
Tagged with
-3 votes
1 answer
43 views

Migration from Sybase to IBM-DB2 or Oracle?

We are planning to modernize our robust power builder /sybase application , that has around 500+ stored procedures,300+ tables. PB application produces 300+ reports,nothing but datawindows which has ...
user avatar
0 votes
0 answers
17 views

Sybase SUM aggregation bug

we have sybase 15.7 ASE and it works super weird: create table test_data (x float, z float); insert into test_data(x,z) select sum(.1), sum(0.01) ; select * from test_data; and we expect to see "...
user avatar
0 votes
1 answer
57 views

In Sybase SQL, can multiple square brackets be avoided in a LIKE statement?

In Sybase SQL, I have a check that looks something like this: SELECT "VALID" WHERE @v_Test LIKE "X[A-Za-z0-9][A-Za-z0-9][A-Za-z0-9][A-Za-z0-9][A-Za-z0-9]" Is there a way to avoid ...
user avatar
  • 103
0 votes
1 answer
422 views

Where to download SAP SDK for ASE (Windows Server 2019)?

Where do we download SAP SAP SDK for ASE (Windows Server 2019)? Trying to connect to Sybase DB server using SQLDBX on Windows Server 2019 client and it cant find required dll (libsybct.dll). I I ...
user avatar
1 vote
1 answer
231 views

Ubuntu - Sybase - PHP not able to connect

I'm trying to connect Sybase 17 from PHP(7.4, 8.0) Laravel running on apache2 on Ubuntu(18.4) system. We are using SQL Anywhere. Sybase is not installed on the same server. We are getting this error -...
user avatar
  • 115
4 votes
3 answers
649 views

How can we restrict tempdb usage for specific users or queries on SQL Server?

In our SQL Server production environment some users run ad hoc queries that run huge data extracts into tempdb and fills it up, causing issues on a production server. And as these reports/queries run ...
user avatar
  • 324
0 votes
1 answer
637 views

SQL Anywhere 17 - Database server connection limit exceeded

I set up a new SQL Anywhere 17 Database in Sybase Server. I've got a lot of clients that should be able to connect to the Database over ODBC. The ODBC works fine but as soon as the third user tries to ...
user avatar
0 votes
0 answers
46 views

Sybase lead blocker in chain

What would be a query to list a blocking chain in Sybase ASE 16? In SQL server I'd use something like this: https://blog.sqlauthority.com/2015/07/07/sql-server-identifying-blocking-chain-using-sql-...
user avatar
  • 87
0 votes
1 answer
585 views

Map login to user in restored database in SYBASE ASE 16

After restoring a database from other environment is there a way to map a user in the database to a login in the server. I can drop and recreate or alias but in MS SQL Server there is a way: EXEC ...
user avatar
  • 87
0 votes
2 answers
137 views

Update the record from query result

Lets say I have a table X with following definition: CREATE TABLE X( id INT PRIMARY KEY, field1 varchar(100), field2 int, field3 double); Then I issue a query: SELECT field1, field2 from X; Let's ...
user avatar
  • 207
1 vote
1 answer
113 views

Why should I renew stored procedures?

Is there a reason significant reason to recompile stored procedures? Of course the data in a database changes over time and the resultset of some stored procedures could differ due to changed ...
user avatar
0 votes
1 answer
663 views

How to mark a Sybase ASE DB as offline for startup

I need to load a database dump into a target database, on Sybase ASE 16. In order to do that, the target database must be offline. Sybase ASE doesn't have a command to put a database offline, so my ...
user avatar
  • 103
1 vote
1 answer
29 views

Next 10% of rows

I know TOP can return first 10% of row results, but how would I then get the next 10%? I am trying to break up a query that crashes due to insufficient memory (java.lang.OutOfMemoryError), and want to ...
user avatar
  • 143
-1 votes
1 answer
222 views

Displaying only 1 row for each distinct value

This seems to be a problem I have quite frequently, but I have yet figure out (I'm not a dba). I'm running a query for a report I'm creating, however the user does not want any duplicate rows ...
user avatar
  • 153
0 votes
1 answer
258 views

Sybase ASE 15.7 sort ordering

I have my sort ordering in Sybase as: 45 190 altdict - Alternate (lower-case first) dictionary ordering Am I right that alternate means "aAbBcC..zZ" ordering? What should I do to change ordering ...
user avatar
0 votes
1 answer
104 views

Meaning of FETCH_CURSOR jconnect_implicit_1 in Sybase

Situation I am trying to troubleshoot performance when connecting to Sybase ASE Version 15.7 from Sqoop over JDBC. Though I cannot check things myself it appears to be 10x slower to extract data this ...
user avatar
0 votes
2 answers
580 views

INSERT values from .csv into database

We have a sybase database running an application our users use which contains client info. The situation is that address information for maybe 1000 clients or so is out of date. We were given a .csv ...
user avatar
1 vote
1 answer
57 views

Sybase query: How can I sort the extraction (by well formed columns)

community I built a Sybase query statement in a script (using the isql command/line ) below is the code: My script contains: isql -U databasename_dba -P password <<EOF! select ...
user avatar
0 votes
0 answers
198 views

Sybase ASE 16.0 BCP in character problem

I am using SYBASE ASE 16.0 and in my tables i have some values like "KOCAELİ", "İZMİR", "TALATPAŞA" . They are readable in csv file however when i put database with bcp in command, i have ...
user avatar
  • 264
0 votes
0 answers
135 views

Sybase 8 to Sybase 16 migration in Windows 10 OS

Currently we are using Sybase 16 db in our project. But there are few Sybase 8 db's (that clients are using in market) that needs to converted to Sybase 16 for any patch testing. I used to use the ...
user avatar
1 vote
3 answers
90 views

When I connect to DB, always connects as tempdb

I am trying to run a sybase DB query from a jsp session. I can connect to the DB fine, but when I run my query, by default it always runs against tempdb. Is there a way I can make a connection to ...
user avatar
  • 11
0 votes
1 answer
1k views

Determing when a stored procedure was last compiled

Is there a way to find when a procedure last had an execution plan compiled in Sybase ASE 16? I don't see a "modified" datetime column in sysobjects, and I haven't been able to find a Sybase ...
user avatar
  • 167
0 votes
1 answer
39 views

Find Source & Details of APL Heap Table Insert

I have been running system monitor(sysmon) on Sybase ASE 15.7(SP139) on HP-UX(Itanium) with below command: sp_sysmon "00:10:00" go Observed that number of inserts are very high in any time of a day, ...
user avatar
2 votes
1 answer
972 views

Function SCOPE_IDENTITY not found

When I call SCOPE_IDENTITY in Sybase, I get [Error] Script lines: 1-6 -------------------------- Function 'SCOPE_IDENTITY' not found. If this is a SQLJ function or SQL function, use sp_help to ...
user avatar
  • 170
1 vote
1 answer
2k views

Sybase to SQL Server Migration [closed]

What is the fastest/best approach to load data from SYBASE to SQL server DB. I have tables with 500 million records. I tried using SSMA and BCP, both are taking over 24hrs. I tried using datastage (...
user avatar
  • 19
0 votes
1 answer
1k views

How to restore one table from full backup in Sybase ASE

I need to retrieve 2 data records that were in a single table from yesterday's backup. How can I restore a single table from a full backup in Sybase? Or is it possible to retrieve the required ...
user avatar
  • 264
0 votes
2 answers
2k views

Processes can not be terminated on Sybase ASE

In 2 days, 1494 processes can not be terminated. This transactions, select data from IQ from ASE using by services. IQ was stopped yesterday and 1494 processes was occured. I killed kill spid but it ...
user avatar
  • 264
0 votes
1 answer
963 views

Get Updated_At for any change in row on Sybase?

I am working with a Sybase SQL Anywhere table that has horrible tracking of changes. I have a windows service that queries multiple tables every 5 minutes looking for changes, but one particular table ...
user avatar
  • 207
0 votes
0 answers
1k views

New Sybase User can't SELECT Tables From Other User

I am accessing a Sybase database and have created a new user using: CREATE USER "ThisNewUser" IDENTIFIED BY "ThisNewPassword"; I then granted privleges: GRANT ALL TO "ThisNewUser" I used the ...
user avatar
  • 207
0 votes
1 answer
293 views

Replicate encrypted data from Sybase ASE 15.5 to Sybase ASE 15.5

Recently I'm studying on how the replication of encrypted data works from Sybase ASE to Sybase ASE, and I have few queries on below:- What will be the datatype for columns that contain encrypted data ...
user avatar
  • 23
1 vote
0 answers
440 views

Another form of WHERE NOT EXIST

I have two complex queries and I have to filter out the results from the second one, it looks something like this: SELECT STH INTO #temp_table_1 FROM TABLE1, TABLE2, TABLE3 WHERE TABLE1.ID = TABLE2....
user avatar
  • 111
0 votes
1 answer
1k views

How to find index details on Temporary tables in SYBASE

I am a layman in SYBASE world. In order to improve performance, I am creating indexes after data load of temporary tables in many stored procedures. Say, one proc A has an insert into temporary ...
user avatar
1 vote
1 answer
1k views

Check current memory_limit of Replication Server version 15.7.1

Does anyone knows how to check the currently memory_limit of replication server? I need to increase the memory_limit of my replication server, but I couldn't check the current memory limit. Can anyone ...
user avatar
  • 23
0 votes
1 answer
71 views

I can't open my Pharmacy management software"based on sybase database"

I am stuck with my pharmacy management software running on Windows XP with a dongle as a security system. The database is Sybase. I tried many backup copies but failed to open the program. Two ...
user avatar
0 votes
1 answer
265 views

Problem creating subscriptions on Replication Server version 15.7.1

if anyone knows what is the error? Can not use active or standby connection names for subscriptions I got this error when I'm trying to create my subscriptions. I have already created a repdef WITH ...
user avatar
  • 23
0 votes
1 answer
289 views

Clarification on steps creating Database Replication Definition

I am being asked to create database replication definitions for a couple of databases (around 20 databases). I just wanted to clarify is the below-mentioned steps are the correct steps to be carried ...
user avatar
  • 23
-1 votes
1 answer
1k views

Permission denied to run set Identity_insert to table

I have just setup the ASE-ASE replication with a column as IDENTITY, when I tried to resume my DSI connection of my replication server, I'm hitting the error Message from server: Message: 10369, State ...
user avatar
  • 23
2 votes
0 answers
132 views

Get extract of Sybase data as INSERT statements, with order considering table dependencies

I want to create a SQL script to populate a DEV database using INSERT statements. (Preferably using INSERT statements, rather than binary form, so that I can safely check-in the script to version ...
user avatar
  • 121
0 votes
1 answer
948 views

Problem replicating IDENTITY columns from Sybase ASE 15.5 to Sybase ASE 15.5

I am trying to perform replication from Sybase ASE 15.5 to Sybase ASE 15.5 for a list of given tables via replication definitions and subscriptions defined in Replication Server(REP) Version 15.7.1. I ...
user avatar
  • 23
0 votes
1 answer
272 views

Data from Same Column Joined in Two Different Ways

In the following sybase query I would like to pull the vendor column twice: the first time I would like to pull the vendor associated with the ReceiveWorksheet table by associating it with a key ...
user avatar
2 votes
0 answers
129 views

Sample Sybase ASE 15.0.3 database

We are trying to migrate a database from Sybase ASE Server 15.0.3 to SQL Server 2016 with the help of a migration assistant application. We tried doing this by creating sample databases in the Sybase ...
user avatar
0 votes
0 answers
1k views

UPDATE JOIN VS UPDATE WITH SUB QUERY

I have 2 tables : Table A ID int, Name varchar, Address varchar Table B ID int, Name varchar, Address varchar, Col1... ... Col100 I want to update A.Name with B.Name based on both table's ID. ...
user avatar
0 votes
2 answers
1k views

How to login to Sybase ASE using OS credentials?

I come from an Oracle background, and I'm used to the concept of OS users that can login to Oracle with DBA privileges in the machine the DB is installed on using their OS credentials as long as the ...
user avatar
  • 131
0 votes
0 answers
14 views

How can I query which actions have been assigned to individual error numbers on SRS?

The DBA can modify the default rowcount mismatch behavior by assigning a different action to the corresponding error number in the replication server error class (see the assign action command for ...
user avatar
  • 183
1 vote
0 answers
317 views

Sybase IQ cannot select by a calculated date

Question: I have a query to select rows dated "last Friday from a given date", using the dateadd/datepart/modulo 7 trick. It works fine in Sybase ASE, but returns 0 rows in Sybase IQ. If I hard code ...
user avatar
  • 167
1 vote
1 answer
571 views

Projection index

I am studying about Projection index in a datawarehouse. According to the paper "Indexing Techniques for Data Warehouses Queries", by Vanichayobon,S. and Gruenwald,L., the Projection index on any ...
user avatar
  • 11
0 votes
1 answer
282 views

Replication Server version 15.7.1 - Sybase ASE 15.5 to Oracle EE 12.1.0.2 (64 bit) replication failing

I have 2 Sybase DB and 1 Oracle DB, I would like to replicate one of the tables in Sybase DB X (table name: customer_order) into my Sybase DB Y (table name: customer_order), and from the Sybase DB Y ...
user avatar
  • 23
1 vote
1 answer
546 views

Find out foreign key reference table

How to find out all the foreign key reference tables for a table in Sybase by writing a Query .
user avatar
1 vote
1 answer
515 views

ip address record in sybase ASE auditing database? [closed]

everone. I installed the sybsecurity database for auditing in sybase ase 15.5. The installation is OK. I configured the audit commands, for example, for auditing the sa user, and other users of the ...
user avatar
2 votes
2 answers
94 views

Any existing programs that track the origin of data in your database?

I am doing some integrity work at the moment, investigating cases when something goes wrong with incoming data. The system I am working with involves multiple servers, including Sybase and SQL Sever ...
user avatar