Stack Overflow
Stack Overflow

Questions tagged [sybase-ase15]

120 questions
4
votes
1 answer

How to get stored proc input parameters and values by MDA tables in Sybase ASE 15.7?

I am trying to get executed stored procedure input parameters and their values by using mda tables. I have used monProcessProcedures and monProcessSQLText but both tables are only returning proc name and not parameter names and values. Please…
Shishir
  • 89
  • 3
3
votes
1 answer

SQL Merge. Update when exits, insert if it doesn't, using variables in stored procedure

Never used MERGE before nor Sybase ASE 15.7 I need a stored procedure for updating existing data or insert it if it doesn't exist. I know how to do it without MERGE but I want to learn to use it. This is my table and test data: CREATE TABLE…
Horaciux
  • 6,322
  • 2
  • 22
  • 41
2
votes
0 answers

Sybase/SAP ASE T-SQL: Why ltrim() and rtrim() native functions return null when evaluaten for empty and only-spaces strings?

I noted an (for me) unexpected behavior on ltrim() and rtrim() functions on Sybase ASE T-SQL engines. The weird behavior I observed occurs on ltrim() and rtrim() functions for empty and only-spaces strings arguments; they return NULL. I consider…
Mauricio Ortega
  • 301
  • 2
  • 12
2
votes
1 answer

How to clear transaction log in sybase15.7?

I'm using Sybase15.7, after many transactions I'm getting an error like The transaction log in database fims is almost full. Your transaction is being suspended until space is made available in the log. Help me resolving this. Thanks in advance
Raja Shekhar
  • 31
  • 1
  • 5
2
votes
1 answer

create table in sybase with auto_increment primary key,after truncate the table the primary key is not zero

I used below SQL to create a table with auto_increment primary key,but found after truncate the table the primary key is not reset to zero ,because after insert data to it the primary key continues to increase from the last time truncate. I believe…
Tom
  • 121
  • 2
  • 14
2
votes
0 answers

Sybase databases, schemas, users and tables

Can someone explain the difference in semantics between the following: select count(*) from dbo.SomeTable; select count(*) from SomeTable; select count(*) from ..SomeTable; select count(*) from somedb..SomeTable; select count(*) from…
Marcus Junius Brutus
  • 26,087
  • 41
  • 189
  • 331
2
votes
1 answer

ASE-15 isql command can not find sybase home on CentOS 7

I installed ASE-15 under directory /opt/sybase on CentOS 7 VM, then I ran SYBASE.sh to set environment variables, but it didn't work, because it outputs nothing when I typing echo $SYBASE on OS. So I set environment variables manually by typing cat…
robothy
  • 1,132
  • 11
  • 18
2
votes
3 answers

Sybase ASE 15 Aggregate Function for strings

I'am findind a way to aggregate strings from differents rows into a single row in sybase ASE 15. Like this: id | Name Result: id | Names -- - ---- -- - ----- 1 | Matt 1 |…
Herman Zun
  • 471
  • 1
  • 6
  • 21
2
votes
1 answer

Equivalent to WITH clause in Sybase ASE

It appears that WITH is supported only in Sybase SQL Anywhere: http://dcx.sybase.com/1100/en/dbusage_en11/commontblexpr-s-5414852.html ...but not in Sybase ASE :( Can someone suggest if there is a equivalent construct in Sybase ASE? There are other…
praveen_r
  • 869
  • 2
  • 10
  • 19
1
vote
2 answers

Sybase ASE create foreign key constraint ignoring case

I am trying to get same functionality out of ASE 15.5 that exists in MSSQL 2008 in terms of case insensitivity. Sort order has to remain binary for the application to work in standard mode, however new tables - enhancement to the product have…
Alex
  • 1,192
  • 14
  • 30
1
vote
2 answers

Can a Sybase SQL table have a computed column?

I am trying to modify an SQL table so that one of the columns is "computed", in this case it always holds the LOWERcase of another column. This would enable me to use this column in an index and speed up results. However, I cannot make it work with…
HugMyster
  • 329
  • 1
  • 4
  • 14
1
vote
0 answers

How to insert stored procedure resultset into Temp table and query it

I am trying to insert the data into temp table from stored procedure. For instance Insert into TempTable EXEC dbo.MyProcedure(CustomerID) In SQL Server it worked fine but in Sybase ASE 16 it gives me error: Incorrect syntax near the keyword…
user17503319
  • 11
  • 1
1
vote
2 answers

How to backfill missing values in Sybase (outer apply and derived tables work in MSSQL but not Sybase)

The problem I have some tables with dates and numerical values; some numerical values are missing. I want those missing values to be filled in with the value available at the last date. I need to do it: In a Sybase database, to which I only have…
Pythonista anonymous
  • 8,140
  • 20
  • 70
  • 112
1
vote
1 answer

Using Postgresql Bablefish to connect Sybase app to Aurora Postgresql

I have a large Sybase ASE C/C++ app which I would like to migrate to Postgresql. The application is using the Sybase CT library (nothing complex: simple SQL, few bulk uploads, etc.). Application is built and run on Linux using SYBASE OCS-16. I'm…
dash-o
  • 13,723
  • 1
  • 10
  • 37
1
vote
2 answers

Combining Left Outer and Inner Joins + Aggregate Function - Empty result set issue

This may be quite simple but I'm not seeing it at the moment. Trying to combine Left outer joins and inner joins in order to fetch whatever info is available from a given set of tables, all related to a customer_id Example may not be perfect by…
Juan M
  • 4,063
  • 4
  • 19
  • 28
1
2 3 4 5 6 7 8