Stack Overflow
Stack Overflow

Questions tagged [sybase]

Sybase, a subsidiary of SAP, produces a variety of data management products. For their flagship RDBMS, Adaptive Server Enterprise, please use [sap-ase]. For Adaptive Server Anywhere versions 6-9, use [sybase-asa]. For ASA v10 and above, use [sqlanywhere]. For the columnar data warehouse IQ, please use [sap-iq]. For the Advantage Database Server, please use [advantage-database-server].

Sybase, now a subsidiary of SAP, was the first company to put a client/server relational database on the market.

Early versions of Microsoft SQL Server were based on Adaptive Server Enterprise, Sybase's flagship RDBMS.

Other popular Sybase products include:

  • IQ for data warehouse and big data applications
  • Adaptive Server Anywhere (ASA), an RDBMS for mobile and lightweight deployments
  • Sybase Unwired Platform (SUP) for developing mobile, data driven applications
  • Afaria for enterprise mobile device management
  • Replication Server for database replication

SAP has fully integrated the Sybase products into it's current offerings, and has dropped the Sybase name on all new product releases.

3333 questions
0
votes
0 answers

AWS Glue reading data from Sybase table

While loading data from Sybase DB in AWS Glue I encounter an error: Py4JJavaError: An error occurred while calling o261.load. : java.sql.SQLException: The identifier that starts with '__SPARK_GEN_JDBC_SUBQUERY_NAME' is too long. Maximum length is…
Gandalf
  • 155
  • 1
  • 12
0
votes
0 answers

Trigger in sybase

I have requirement where trigger needs to be created on same table. Here is the condition, When A code is inserted into table at the same time trigger gets involved and writes B code Where Type is column which will be having value as A then need to…
user19589616
  • 11
  • 1
0
votes
0 answers

Powerbuilder 2019 LDAP login

I have an application that needs an LDAP (Active Directory) login. In my previous project I have managed to create an application that has LDAP login. I created it using webservice but I am not quiet happy with its speed. Sometimes, it takes 1…
xtian
  • 9
  • 4
0
votes
1 answer

SyBase to Access port needed

I have a SyBase database and have been tasked with exporting it to MS Access. What is the best way to do this? (Note: This is half an "I'll answer it my self when I figure it out" question and half a "If someone known off hand..." question, so don't…
BCS
  • 75,627
  • 68
  • 187
  • 294
0
votes
3 answers

PowerBuilder application login

I am using PowerBuilder PFC library to login to the database. n_cst_appmanager/ pfc_open: IF this.of_LogonDlg() > 0 THEN Open(w_myapp_frame) END IF n_cst_appmanager/ pfc_logon: SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = False SQLCA.DBParm =…
asam
  • 3
  • 1
  • 2
0
votes
1 answer

How to do 'Generate DDL' in Sybase Central in isql on the command line?

In Sybase Central when I right click on a stored procedure and choose 'Generate DDL', then I see the definition of the stored procedure, but also the grants for example. How do you do that on the command line with isql?
ericj
  • 2,138
  • 27
  • 44
0
votes
2 answers

Sybase Systypes relationship between Syscolumns, why is it many to one?

I've been trying to capture the datatypes of particular columns and noticed that you must use a join on the system tables to capture it. It doesn't seem to match up with what I'm seeing in Aqua Studio on occasion as well. For instance, the datatype…
Godstar
  • 11
  • 2
0
votes
1 answer

Sybase PowerBuilder Pipeline question

I am very new to PowerBuilder. I have a question regarding the data transfer from one table to another using Pipeline. The source table has one addition field, lets say 'transfer'. Initially this column has value 0. After the data has been…
amz
  • 19
  • 5
0
votes
0 answers

SQLExceptionHelper : Input parameter not set, Index : 0

I am using spring-data-rest & hibernate to expose a table "File(Id, Name)" from a SAP IQ(Sybase IQ) database. The below error occurs when I do a "GET" on the "File" table using "curl http://localhost:8080/files/1". 2022-07-20 20:01:03 WARN …
sankardevisharath
  • 19
  • 3
0
votes
0 answers

Inserting Value from CSV file to Sybase Table

I'm trying to insert the value from a CSV file (with 5 columns) into a Sybase table (with 3 columns). I have tried a fair amount of commands such as BULK INSERT, LOAD TABLE, INPUT INTO, but all gives me error messages. EDIT: I am using the Sybase…
Alex Zhang
  • 1
  • 1
0
votes
0 answers

Lots of finalizations when using AseClient

We have high volume .Net Framework API's that execute stored procedures on Sybase, using the AseClient driver (Sybase.AdoNet4.AseClient.dll version 16.0.2.6). I have run PerfView on a production machine and I see enormous numbers of Finalized Object…
Michel van Engelen
  • 2,791
  • 2
  • 29
  • 45
0
votes
0 answers

Database migration from Sybase ASE to Azure SQL managed instance

We planned to migrate Sybase ASE database to Azure SQL managed instance. Our source Sybase database collation is Binary as like below Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. Sort Order = 50,…
Yuvaraj
  • 1
0
votes
1 answer

Cannot cast result from Sub-Select to numeric

I am selecting a list of IDs as a sub-query in a condition but it says it cannot convert '123,456' to numeric. The problem occurs in the last line. DB is Sybase-SQL-Anywhere. SELECT ISNULL(SUM(a.menge), 0) AS menge, ISNULL(SUM(a.wert), 0) AS…
nicht verfügbar
  • 132
  • 12
0
votes
2 answers

Can a table and a column within it use the same name in Sybase?

I am using a Sybase database and would like to know if it's valid to have a table contain a column with the same name as that of the table, e.g.: CREATE TABLE foo ( foo int not null, etc... )
Graeme
  • 4,514
  • 5
  • 43
  • 71
0
votes
1 answer

Multiple field result in select statement in SYBASE DB

I am trying to get a result like shown below in sybase db. Select fruit = select names from Food where food_type = 'fruit', veg = select names from Food where food_type = 'veg', * from Food And the result will be ID fruit veg -- ------- ---- 1…
CKuttan
  • 49
  • 2
1 2 3
…
99
100