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
0
votes
2answers
44 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 ...
1
vote
1answer
31 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 ...
0
votes
0answers
48 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 ...
0
votes
0answers
44 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 ...
0
votes
0answers
83 views

How to reset Maintenance User password in Replication Server version 15.7.1

I am going to reset a Sybase ID (abc) in my primary data server (pubs1). This ID abc@pubs1 is used as my maintenance user when I setup Replication Agent for pubs1 in my replication server. If I am ...
1
vote
3answers
53 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 ...
0
votes
1answer
393 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 ...
0
votes
1answer
24 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, ...
0
votes
0answers
118 views

How to modify a column in a result set returned by a stored procedure (Sybase)

I have a Stored Procedure in Sybase that selects a bunch of columns. The result set contains multiple rows. I want to modify one of the columns in the result set before the Store Procedure returns. ...
2
votes
1answer
267 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 ...
0
votes
1answer
465 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 (...
0
votes
1answer
455 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 ...
0
votes
1answer
505 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 ...
0
votes
1answer
105 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 ...
0
votes
0answers
453 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 ...
0
votes
1answer
150 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 ...
1
vote
0answers
195 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....
0
votes
1answer
671 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 ...
1
vote
1answer
448 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 ...
0
votes
1answer
65 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 ...
0
votes
1answer
174 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 ...
0
votes
1answer
219 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 ...
-1
votes
1answer
345 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 ...
2
votes
0answers
95 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 ...
0
votes
1answer
493 views

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

I am trying to do replication from Sybase ASE 15.5 to Sybase ASE 15.5 for a list of given tables via replication definitions and subscriptions in Replication Server Version 15.7.1. I found there is a ...
0
votes
1answer
187 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 ...
1
vote
0answers
107 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 ...
0
votes
0answers
420 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. ...
0
votes
2answers
727 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 ...
0
votes
0answers
13 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 ...
1
vote
0answers
226 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 ...
1
vote
0answers
213 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 ...
0
votes
1answer
187 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 ...
1
vote
1answer
315 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 .
1
vote
1answer
320 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 ...
2
votes
2answers
73 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 ...
-1
votes
1answer
996 views

How to move databases to another drive in same server for sybase ASE 16 on windows.

I am trying to move sybase user database from one drive to another drive, can you please help me with procedure. My database : Sybase ASE 16 OS windows.
0
votes
2answers
766 views

Need script for new login creation in sybase ase

I have 470 new database accounts in SYBASE ASE I certainly don't want to do it manually since it is definitely time consuming. Here by I have old script which I try to add logins Can someone help ...
3
votes
1answer
816 views

Sybase ASE to Microsoft SQL Server Replication

I am currently working on several projects to migrate legacy applications from a Sybase ASE (12.5 and 15.0) to a Microsoft SQL Server 2014 platform. There will be a need to replicate data in both ...
1
vote
3answers
1k views

How can I rectify an “arithmetic overflow occurred error” when trying to merge these two queries?

Let us consider the first query: SELECT r.cnum as cnum, c.name as name, r.assets as assets FROM research..complex c, research..retirement_simple_ira r where r.date = '9/30/2016' and c.cnum = r.cnum ...
2
votes
2answers
60 views

How do I merge these two queries so that the result set is “combined” and consistent?

Please consider my first query: SELECT cf.cnum as cnum, rc.name as name, SUM(rs.dh_simple + rs.ha_simple) as sums FROM retirement_survey as rs INNER JOIN currentfunds as cf ON rs.fundid = cf.fundid ...
2
votes
2answers
372 views

how to confirm or refute that performance degradation is due because of too many indexes maintained

We know that indexes improve select statement and at the same time, indexes have a cost of maintenance on every update/insert/delete statement. I don't know how to measure/evaluate this cost. Some ...
2
votes
1answer
662 views

DELETE statement not working

I'm running my database on a Sybase ASE 15.7 server. A simple delete statement fails without printing any error , I presume there is no permissions problem as I used to delete rows by the past. Here ...
1
vote
1answer
314 views

What do these error messages mean?

This is running on an AWS AMI EC2 Linux instance in a PHP script using dblib and PDO to connect to remote Sybase databases (Sybase version 11.0.1.2596). The server has freetds with these settings: ...
1
vote
1answer
620 views

Passing a table name to a stored procedure

Once a new table is created, we have to execute the same SQL code segment, that grants some users rights to the table and does similar maintenance. This code is identical for all cases, differing only ...
2
votes
1answer
986 views

how do I know whether I am currently in chained or unchained mode

In Sybase server-side language how can my code test whether it's running in chained or unchained (auto-commit) mode? Examining the status of @@TRANCOUNT is not really conclusive. I gather that there ...
1
vote
0answers
327 views

why is the 'Dynamic Ownership Chain' mode of a stored procedure mutually exclusive to “chained” / “unchained”?

How is the "chained" / "unchained" / "any" transaction mode for a stored procedure related to the "[no] dynamic ownership chain" mode? Reading the Sybase ASE documentation on the sp_procxmode system ...
0
votes
1answer
372 views

sybase errors - meaning and resolution

We have a server that connects to 40+ different remote computers which are running Sybase 11.0.1.2596. Our server is hosted on an aws ec2 AMI Linux instance, and the connections are set up using ...
2
votes
0answers
687 views

allow multiple NULL values in unique key

I am trying to allow for multiple NULL values in a unique key as allowed by ANSI SQL. E.g. in the below table I want to allow multiple NULL values in column f1 and still have a unique constraint on it:...
0
votes
1answer
130 views

differences (if any) between Select count () from table vs select count (*) from table

I was looking at script in Sybase when I read something like select count() from table; the result it's exactly the same to select count(*) from table; I'm curious, and I was looking out ...