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
0answers
6 views

Connection string works with dbping but not with mlsrv

I'm trying to start a Mobilink synchronization server, and my connection string works with dbping... dbping -d -c "uid=xxx;pwd=yyy" ...but fails to work with mlsrv mlsrv -c "uid=xxx;...
0
votes
1answer
58 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 ...
1
vote
1answer
34 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 ...
0
votes
1answer
24 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 ...
0
votes
0answers
13 views

Connecting to a SyBase 12 Database

I have been tasked to perform backups of a Sybase SQL Server 12 database, but was just given the user and password. I tried logging into the server where it runs as a domain admin and ran Sybase SQL ...
0
votes
0answers
22 views

What happens if a table with longer varchar column is replicated into the table with shorter column in Sybase ASE?

I have a table T1 (id int, xname varchar(10)) on two dataservers, D1 and D2 (Sybase ASE 16). "id" is unique identity column. There is a replication set up from dataserver D1 to D2 on that ...
1
vote
1answer
23 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 ...
0
votes
0answers
52 views

Moving SyBase to AWS Database as a Service

We have several existing Sybase ASE and IQ v16 installation on-premise that are not accessible via the internet. These databases have stored procedures. What's the best way to migrate these databases ...
-1
votes
1answer
56 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 ...
0
votes
1answer
58 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 ...
0
votes
1answer
35 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 ...
0
votes
2answers
209 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
37 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
110 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
71 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 ...
1
vote
3answers
65 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
704 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
26 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, ...
2
votes
1answer
433 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
924 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
748 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
921 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
377 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
762 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
219 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
299 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
860 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
642 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
67 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
199 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
242 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
532 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
120 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
660 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
234 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
114 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
704 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
889 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
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 ...
1
vote
0answers
268 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
1answer
289 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
229 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
389 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
400 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
78 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
1k 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
938 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
1k 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
2k 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
82 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 ...