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

Sybase select value from XML field

I have a table named data_values stored in SYBASE in the following format: data1 | data2 | data3 | value The value field has the following XML format: I want to select from the value field values…
epushor
  • 66
  • 6
0
votes
0 answers

SQLAnywhere CURSOR TEMPORARY TABLE

Im trying to process rows using CURSOR and write values for each row to a temporary table. This works if I use the FOR loop e. g. FOR myLoop AS myCursor CURSOR FOR ... but I want to use the cursor as documented for T-SQL and as soon as I uncomment…
Dlanod Kcud
  • 517
  • 5
  • 13
0
votes
0 answers

Simple query running slow, using the wrong index

The query: SELECT first DebtCase.SourceID FROM DCS.DebtCase WHERE DebtCase.SourceInterfaceType = 'ABC' AND DebtCase.DebtNr = 'XYZ' order by ID desc My problem that this simple query runs for almost a second. The query currently using this index…
Blaazs
  • 5
  • 1
0
votes
0 answers

Sybase C library dbbind

I am using the following in "c" program to copy data from database into a program variable. I suspect that the data while being copied into the program variable is being transformed to an unexpected value. Is there a way I can print the value coming…
Pradeep
  • 15
  • 1
  • 5
0
votes
1 answer

Smallint stayed null after executing update SQL statement in Sybase

The DB was Sybase. I executed update SQL statement like UPDATE table_name SET smallint_col = 0, datetime_col = CONVERT(datetime, '1999-09-09') WHERE some_col = 'sth'; to set a null smallint attribute into a nonnull value. I checked the update…
anndexi99
  • 189
  • 3
  • 18
0
votes
2 answers

How to add unique column in sybase?

I have a sybase db table in which i need to add a new column. The conditions: The column must not allow nulls and be unique. what is the alter table sql to achieve this? EDIT: It is a varchar type column.Yes the table as of now is empty, but when…
jch
  • 1,155
  • 3
  • 14
  • 27
0
votes
1 answer

Syntax error near 'unlock' - 'alter role warehouse_user unlock'

Trying to run - 'alter role warehouse_user unlock' on Sybase IQ Failed due to SQL Anywhere Error -131: Syntax error near 'unlock' on line 1 someone knows why?
Orly Orly
  • 367
  • 5
  • 16
0
votes
0 answers

Connection refused (Connection refused) between containers | ifnazar / docker-sybase

I have two containers in my docker-compose and my node application does not connect to Sybase database but my local machine connects version: '3' services: api-sybase: build: .docker/api entrypoint: .docker/entrypoint.sh …
Diogo Henrique Fragoso de Oliv
  • 101
  • 5
0
votes
2 answers

Why the indexes not speeding up the query?

I have the following query: SELECT TOP 1000 * FROM MyTable WHERE Status = 'N' AND Type is not null ORDER BY mytable.id MyTable has 130 million rows. I also created these indexes: CREATE INDEX "MyTableIndex_1" ON MyTable (Status); CREATE INDEX…
Blaazs
  • 5
  • 1
0
votes
1 answer

How to cast or convert numeric to varchar data type on sybase?

DECLARE @k numeric, @acc numeric SET @k = 651393561522 , @acc = 1231234560 WHILE (@k < 651393563552) BEGIN SET @k = @k + 1 , @acc = @acc + 1 insert into recipients (id, client_id, inn, name, bic, bill,…
Aleksandr Mushtat
  • 3
  • 1
0
votes
1 answer

How to remove quotes in sybase ASE

I have a string: "16680,16678,16677,16676,16675,16672" Which I got from the Stored procedure passed parameter while calling it. I want to insert these records in where in like Where in (16680,16678,16677,16676,16675,16672). How can I make this…
Rahul Mankar
  • 910
  • 9
  • 17
0
votes
1 answer

How to pass TEXT(the list of id's as a string) to sybase ase stored procedure

How to pass TEXT(the list of id's as a string as I have long list of id's) to sybase ase stored procedure call? If I want to pass TEXT to stored procedure call then how can I use same TEXT in where IN query of sybase? CREATE PROCEDURE…
Rahul Mankar
  • 910
  • 9
  • 17
0
votes
0 answers

Sybase Python SQL Anywhere 17 SQL Central

I don't know which module for python can I use to connect to DB. And use SQL commands INSERT INTO , SELECT to manipulation DB TABLE. Pls help me to find module and example. I have UserId , Password , Host , Port , Server Name , Database Name
Makstvell
  • 1
0
votes
1 answer

odbcinst symbol lookup error SQLManageDataSources

I've just installed unixODBC on Pop-OS (Ubuntu 20 base). there's no odbcinst.ini file, just odbc.ini and when I run odbcinst -j I just get the following odbcinst: symbol lookup error: odbcinst: undefined symbol: SQLManageDataSources I'm not an…
Marc Nealer
  • 374
  • 1
  • 4
  • 10
0
votes
3 answers

Is there a way to only show first non-zero value but if all values are zero then show 1st instance of a column in a separate table from joining tables

These two tables are quite large, and my select statement has more values I am obtaining, but I think I can simplify this data and query so my question can be answered. Here is my select statement: SELECT invoice.InvoiceNum, Layer, InvoiceItemNum…
Justin Frossard
  • 51
  • 1
  • 7
1 2 3
…
99
100