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
0
votes
1 answer

ASP.NET WebSite and Sybase ASE Database

Is it possible to use data from a Sybase ASE Database in a ASP.NET Website?
aF.
  • 64,980
  • 43
  • 135
  • 198
0
votes
1 answer

why pyodbc query to Sybase db returning partial data with some garbage?

I recently started using a Windows 7 box. I am trying to query a Sybase database using 32-bit ASE drivers (Adaptive Server Enterprise). The Sybase client installed on the machine is v15.5. The issue is that when I query for small data I get correct…
Alok
  • 3,160
  • 3
  • 28
  • 47
0
votes
1 answer

Copy a database table to flat file using unix shell and perl

I need to backup a database table to flat file. Generally this can be done with ETL tools. However, I can only use shell scripts and perl out here. I am using Sybase Adaptive Server Enterprise/12.5.0.1
Lordlebu
  • 411
  • 1
  • 6
  • 15
0
votes
1 answer

connect to a sybase database using visual studio 2003 and the .NET Framework 1.1

I'm developing an interface between my application (built with Visual Studio 2003 and the .NET Framework 1.1) and a Sybase database. I installed the Adaptive Server to store the database. The problem arises when I tried to reference the neeeded dll…
user994432
  • 97
  • 1
  • 1
  • 5
0
votes
1 answer

How to execute .sql script (sybase) file using cmd

I am having .sql (sybase) file which creates the table i.e. "Create_table_mytable.sql" But before creating the table it check of the existing table and drops the same. here is how scripts looks like: - setuser 'dbo' go IF EXISTS (SELECT 1…
Anil Purswani
  • 1,857
  • 6
  • 35
  • 63
-1
votes
1 answer

Sybase --Create Trigger giving syntax error for Referencing new as new old as old clause

I am using Sybase ASE 15.0.3 and DBArtisan 8.5.3. I am trying to create a trigger that puts data into audit tables when a table gets updated. My code is something like CREATE TRIGGER AUDIT_TRG ON TABLE A FOR INSERT,UPDATE REFERENCING OLD AS OLD…
Shubhankar
  • 1
  • 1
-1
votes
0 answers

Why is the record count different for a Select Statement vs. a Delete Statement which are identical in DBeaver?

Using Dbeaver 23.1.0 connected to a Sybase Adaptive Server Database I run 2 simple select queries which both return a record count of 5333 which is expected. Select * from Availability Where ProductId in (select ProductId from Products where…
user200709
  • 31
  • 4
-1
votes
2 answers

Facing Problem like "Cannot select from or insert/update variable '@TableName' because it is not a table variable." in Sybase ASE

I am writing a stored procedure that will get some tablename as a parameter and it will do "select @TableName from @TableName" But Sybase ASE SQL is not allowing me to do that. I am getting this message Cannot select from or insert/update variable…
Yash
  • 25
  • 6
-1
votes
1 answer

Update query to Increment column value based on set of other column values in Sybase ASE

I am trying to update the SeqNum column value based on the StudNo, StudentName. There will be sequence which should be incremented for every same set of StudNo, StudentName. create table #student ( StudNo int, StudentName char(50), SeqNum …
M.S.Naidu
  • 2,239
  • 5
  • 32
  • 56
-1
votes
2 answers

Going from SQLite to SAP ASE/SQL Server need some assistance on query rewrite

I wrote the following query in SQLite, which works fine, but have found out the office utilizes SAP ASE (Sybase SQL Server) and it does not display the same result…
Gabbelgak
  • 1
  • 2
-1
votes
1 answer

How to get the min value of a column after selecting it. Cannot perform an aggregate function on a column

My error is in this part (select min(sc.name) from so.name ), how to solve it ? In the select I am getting the table and column name, in the same time i want to get the min value of the column from the table. Is that possible?. select so.name…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
-1
votes
1 answer

How to convert Sybase ASE smalldatetime/datetime/bigdatetime into a standard format

I needed to move some large amount of data (100Ms of rows) from a Sybase database to a MySQL database. One of the issues I ran into is the conversion of columns of type smalldatetime, datetime and bigdatetime into a format that MySQL will readily…
Jerome Provensal
  • 931
  • 11
  • 22
-1
votes
1 answer

Get next value of AUTO INCREMENT

How do i determine what the next value is of the Primary Key Auto increment? I have been looking in the system databases but i couldnt find any answers.
Wvs
  • 45
  • 1
  • 9
-1
votes
1 answer

Using Sybase ASE 12.5.4 and looking to list / concat string values

I have a table that looks like this I want to create a query so that same values of column 1 and column 2 (tcbname and status) are grouped and column 3 (scope_name) lists all the scopes related to that status and tcb_name. Below is my expected…
A boy has no name
  • 19
  • 2
-1
votes
1 answer

how to connect to sybase and execute sql file using cmd

I want to connect to sybase than execute a file.sql I tapped this command: sql -U Login -P MotDePasse -S ServeurASE -d NomDeLaBase -i Script.sql -o JournalDErreur.log I also tried isql -U Login -P MotDePasse -S @IPserveur:Port -d NomDeLaBase -i…
user3446229
  • 95
  • 3
  • 3
  • 14
1 2 3
…
86 87