Stack Overflow
Stack Overflow

Questions tagged [sap-ase]

SAP Adaptive Server Enterprise (ASE), formerly known as Sybase ASE, is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language.

SAP Adaptive Server Enterprise (ASE) is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language. Until version 15 it was known as Sybase ASE, but as of version 16, SAP has retired the Sybase name.

SAP ASE is an enterprise RDBMS which has been developed by Sybase Inc (now an SAP company). SAP ASE is available for various platforms like Unix, Linux and Windows.

1291 questions
-1
votes
1 answer

Python loop and if statment weird issues

Ok, I dont understand what is happening. I am looping over output from my query. A pretty normal loop and if. The issue is when I try to do results[o] < 30. It does not print out the variable. There are column data less than 30 for some reason…
user3525290
  • 1,557
  • 2
  • 20
  • 47
-1
votes
1 answer

List [a,b,c] to a,b,c

I receive a proc with this on parameter: exec do_something [a,b,c] I need to make a query like: select * from B where b not in ("a","b","c") How can I make this transformation?
Goldbones
  • 1,407
  • 3
  • 21
  • 55
-1
votes
1 answer

Accessing on premises Sybase database server from Linux VM in Azure cloud

I am working on Azure Poc . Is it possible to connect to on premise Sybase database from Azure cloud ? Can I read and write data into Sybase from Azure cloud ?
Srikant
  • 1
-1
votes
1 answer

How to find the trigger status (enabled or disbaled) in Sybase ASE 16.0?

I have a table with multiple triggers defined in different schemas. I want to know the enabled status of each trigger. Example, I created a table in s1 and created 2 triggers in s1 and s2 with same names. Create table s1.sometable (---); create…
Saurabh Garg
  • 39
  • 11
-1
votes
2 answers

How does SELECT TOP with ORDER BY into DERIVED TABLE work in Sybase ASE?

I was wondering how this query is executed: I got the error message "An ORDER BYclause is not allowed in a derived table." same using TOP. NOT WORK: SELECT count(*), sum(a_metric_1), a_fld_1 FROM ( SELECT sales AS…
John L. Santos
  • 13
  • 5
-1
votes
1 answer

i want to get the server name through Process from os level itself without connecting to DB

sybase 1215 30224 0 20:44 pts/3 00:00:00 grep dataserver sybase 6138 6137 0 Feb04 ? 00:28:10 /u01/sybase/ASE15_0/ASE-15_0/bin/dataserver -d/u01/sybase/ASE15_0/data/aashish1_master.dat…
sreejith babu
  • 1
-1
votes
2 answers

How to join servername, database name and database size in a single select query in Sybase

I want to join server name ,database name and database size in a single select query. Server Name Database Name Database Size in MB Report_Time SYBD012 CBA_ATM 3856.81 MB 08-02-17 16:40 SYBD012 CBA_CM_PPP …
Rajendran S
  • 1
  • 1
-1
votes
2 answers

Does String concatenation in database query cause performance issues?

I have a table named T_PERSON with rows such as FIRSTNAME varchar, LASTNAME varchar, CUSTOMERTYPE int, SELLERID int (and more) Additionally I have a large "SQL IN statement" list of persons like this :( 'JOHNxSMITHx12345x1337',…
Lars Hartviksen
  • 1,163
  • 11
  • 19
-1
votes
1 answer

Import excel column in Sybase table

I need to import a column from excel sheet into a Sybase ASE table. The column is a varchar value. Could you please help me with a solution? /Niraj
Niraj Kulkarni
  • 35
  • 1
  • 5
-1
votes
1 answer

SQL Query for Max records for Multiple dates

Hi I am looking for an SQL Query to select max records based on specific criteria for customers. the current situation is as below Customer Activity Date 1 1 01/02/2015 1 1 …
MAhmad
  • 5
  • 5
-1
votes
1 answer

How to restore database schema using DDLgen utility

I am using the ddlgen tool to get DDLs or whole databases. Now I need to re-generate databases into another location (structure only). Can anyone help me to re-create database schema in another location?
Mamta Vyas
  • 93
  • 1
  • 2
  • 9
-1
votes
1 answer

How can I get ddl of granted objects in SYBASE ASE 15.5?

I am trying to create a application that will export ddl for the given schema. I created sample in java using ddlgen command. In which, I can get ddl for all objects for the schema of logged. Command is: java -cp…
santosh
  • 435
  • 1
  • 7
  • 24
-1
votes
1 answer

get relevant data from Database

I have 2 tables employeeAccount and employeeInfo. I am not allowed to modify the tables. Using Sybase databse. employeeAccount ============================= employeeID parentID S1 P1 S2 P1 S3 P1 S4 …
user1841046
  • 93
  • 10
-1
votes
1 answer

Permission denied for object sysmonitors [Sybase]

I got permission denied problem which executing query for Sybase. 1. Exception: SELECT permission denied on object sysmonitors, database master, owner dbo. 2. Exception: master.dbo.monCachePool not found. Specify owner.objectname or use sp_help to…
Tun Lin Aung
  • 339
  • 1
  • 4
  • 17
-1
votes
1 answer

Autonomous transactions in Sybase ASE 15.5

I'm working on Oracle to Sybase ASE SPs conversion and trapped into the autonomous transaction usage in PL/SQL. Could you please let me know if there is any equivalent for this feature in Sybase Adaptive Server Enterprise? May be there are some…
Ispirer SQLWays Migrations
  • 1,028
  • 9
  • 16
1 2 3
…
86 87