Stack Overflow
Stack Overflow

Questions tagged [sybase-ase15]

120 questions
0
votes
1 answer

How to translate Sybase SQL to HSQLDB dialect?

I'd like to translate this very simple stored procedure from the Sybase SQL dialect to the HSQLDB dialect: CREATE PROCEDURE dbo.some_proc AS BEGIN SELECT int_param1 FROM control WHERE id_param = "SOME_PARAM" AND id_active = "Y" END In my humble…
foundationer
  • 85
  • 2
  • 9
0
votes
0 answers

Sybase ASE monitoring tool of choice

I have inherited an Sybase ASE 16 database server and my initial task consist on deploy some Key Performance Indicators to monitor the RDBMS instance performance. I have 3 tools available in the company: Cacti Nagios Ganglia And I'd like to have…
dnaranjor
  • 31
  • 7
0
votes
0 answers

Group by improvements?

I have a requirement to improve below distinct slow query to use group by(or any other suggestion...) insert into #temp1 select distinct col1, '', 'known',col2, col3 from mytable Help please. Index is only on col1 which is int type. Rest…
Sandiyan
  • 1
  • 1
0
votes
1 answer

How to recover SA password for Sybase AWE?

I lost SA password for Sybase ASE, and Googled about this issue is about how to recover it. I have found some hints like edit the RUN_SERVER.bat and type -psa in the end of command line as: C:\sybase\ASE-15_0\bin\sqlsrvr.exe…
scass
  • 35
  • 9
0
votes
1 answer

create a dynamic sql from parameters passed in sybase

I have a parameter which can have n inputs which are , separated. example : asd,qwe,zxc Now I need to create an sql from based on the parameter passed inside a stored procedure. example : select asd ,qwe,zxc from table1 Is this possible in sybase…
doubting
  • 13
  • 1
  • 6
0
votes
1 answer

hoe generate license after install sysam license server

Dears, while I am installing sybase ase 15.7, I install sysam license server, but I don't know now how to generate license (EE:enterprise) by default, Sysam generates a license file in licenses directory but this license is developer edition, anyone…
scass
  • 35
  • 9
0
votes
2 answers

sybase external login for proxy table

Dears, kindly note I have created an external login and a remote login as following: sp_addremotelogin remoteserver,locallogin1, remotelogin1 sp_addexternallogin remoteserver,locallogin1, remotelogin1 and I log in by user locallogin1 to the…
scass
  • 35
  • 9
0
votes
1 answer

Powerbuilder Datawindow + Datetime2 Error

I am in the process of Converting a large application to work against SQL Server 2014. It is currently running against Sybase ASE 15. The Problem is when I try to retrieve a value from a column that is defined as Datetime2, I get "Error: Invalid…
shai4444
  • 43
  • 9
0
votes
1 answer

Getting Error 605 in sybase ASE 15.0

We are getting error 605 in sybase ASE15.0 server Error: 605, Severity: 21, State: 1 server An attempt was made to fetch logical page '64000' from cache 'default data cache'. Page belongs to database 'testdb' (30), object '' (0), index '' (0),…
gopesh
  • 161
  • 1
  • 1
  • 6
0
votes
1 answer

How to handle syntatical errors in sybase

I am new with Sybase. I am using below version of Sybase: Adaptive Server Enterprise/15.0.3/EBF 24162 ESD#4. Here I am trying to run multiples queries at a single hit. I have created a perl script which will capture data from sysMonSQLText at every…
HBK
  • 55
  • 1
  • 10
0
votes
1 answer

Kerberos security mechanism inside PowerBuilder

I am trying to setup 'Single Sign On' authentication on our client-server application. Through using a 3rd party application we are able to authenticate user against the AD to connect active user when logging into Sybase/SAP iSQL tool. When…
drewglew
  • 149
  • 1
  • 13
0
votes
1 answer

Extrainfo column in Sybase audit table

i'm using Sybase ASE 15.0 and when reading the extrainfo column from sysaudits_01 there are missing values. The manual says that in case of an update, the previous value and the current value will appear in the column. Tested different scenarios of…
MisterM
  • 81
  • 1
  • 10
0
votes
1 answer

Sybase ASE stored procedure creation date

Is there any way of finding what is the creation date of a stored procedure in Sybase ASE 15? The actual version is 15.0.3. I know i can find information on this in the sysobjects table, but due to the fact that stored procedures are dropped and…
andreih
  • 423
  • 1
  • 6
  • 19
0
votes
1 answer

How to find TOP N rows in sybase without using TOP and rowcount keywords?

I need to find out first 1000 rows of a table without using top and rowcount. I must use where clause in my query. The query should look like this : select * from where I do not have any good column that can be used in…
Neo
  • 93
  • 1
  • 12
0
votes
1 answer

Sybase insert into temp table with identity column

I'm trying to insert records for couple of columns from a physical table into a temp table with customized IDENTITY. It creates the identity column (field name = idnum), but the values are 0 for all rows. I'm using below code. If anyone can help me…
superachu
  • 823
  • 3
  • 16
  • 34
1 2 3 4 5 6
7
8