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

How to list all the user tables in SQL Anywhere along with their rowcount?

I'd like to list all available tables in my DB, and be able to sort and filter by row count.
maf-soft
  • 2,335
  • 3
  • 26
  • 49
10
votes
1 answer

PHP PDO installation on windows (xampp)

I am trying to develop a web app that can connect to as many different databases as possible on PHP. PDO (http://www.php.net/manual/en/book.pdo.php) seems to be the right interface for it but I am having trouble installing all the extentions needed…
Constantinos
  • 139
  • 1
  • 1
  • 8
10
votes
7 answers

How to list all the user tables in Sybase along with their row count?

I would like to return all the tables and its count next to it. what is the quickest way to go about it? I know in Oracle, you can do something like below, but not sure about Sybase: declare n number; begin for rec in (select object_name from…
Neerav
  • 1,399
  • 5
  • 15
  • 25
10
votes
10 answers

SQL SELECT INSERT INTO Generate Unique Id

I'm attempting to select a table of data and insert this data into another file with similar column names (it's essentially duplicate data). Current syntax as follows: INSERT INTO TABLE1 (id, id2, col1, col2) SELECT similiarId, similiarId2,…
jrb
  • 101
  • 1
  • 1
  • 4
9
votes
4 answers

How to connect to Sybase database from .net core

I am trying to connect to Sybase database from .net core but I do not find any good library. Can someone suggest library to connect to Sybase?
Mikayel
  • 150
  • 1
  • 3
  • 8
9
votes
4 answers

How do I execute different SELECT statements based on a CASE

I am facing a problem in executing queries with CASE statement. Based on my condition,(for eg. length), I want to execute different SQL statement. Problematic sample query is as follows: select case when char_length('19480821') = 8 then…
surbhit4u
  • 133
  • 2
  • 2
  • 5
9
votes
3 answers

How to connect to Sybase via PHP

I'm trying to connect to a Sybase database with PHP5. I believe I've successfully compiled PHP with PDO_DBLIB, as phpinfo() lists dblib under PDO drivers, and freetds as the pdo_dblib flavour. However, when I try to test a connection, I get an…
zwiebelspaetzle
  • 250
  • 1
  • 3
  • 8
9
votes
4 answers

PDO To Connect to MSSQL Over MSSQL_* Functions

There is a range of mssql_* Which are not in the depreciation process. They work the same as mysql_* functions; they need to me manually escaped, please find the link to the manual below: http://uk1.php.net/manual/en/book.mssql.php MSSQL_*…
user1968541
  • 333
  • 1
  • 3
  • 12
8
votes
4 answers

Getting ExecuteBatch to execute faster

I'm trying to read a table from a sybase server, process the rows, and output the results to another table. (Below is my code) The code retrieves the table pretty fast and processes equally fast (get's to the part where it sends within 30 seconds).…
user1167650
  • 3,177
  • 11
  • 34
  • 46
8
votes
5 answers

Get current time without Date

How do I get the current time only? select getdate() Gives me: Dec 16 2016 5:41PM I want this result: 5:41PM
Moudiz
  • 7,211
  • 22
  • 78
  • 156
8
votes
11 answers

How do you identify the triggers associated with a table in a sybase database?

I am using SQL Advantage and need to know what the SQL is to identify the triggers associated with a table. I don't have the option to use another tool so the good old fashioned SQL solution is the ideal answer.
Bill Rawlinson
  • 600
  • 1
  • 4
  • 22
8
votes
1 answer

Error when connecting to Sybase from VBScript - internal Client Library error

I am writing a VBScript that connects to a Sybase database, reads some data from a table and stores it in variables, then connects to a MS SQL server and inserts data into tables with the variable data that was stored earlier. I'm not sure if this…
Armin
  • 1,736
  • 4
  • 19
  • 35
8
votes
7 answers

How can I "merge", "flatten" or "pivot" results from a query which returns multiple rows into a single result?

I have a simple query over a table, which returns results like the following: id id_type id_ref 2702 5 31 2702 16 14 2702 17 3 2702 40 1 2703 23 4 2703 23 5 2703 34 6 2704 1 14 And I…
dsm
  • 10,263
  • 1
  • 38
  • 72
8
votes
1 answer

Why does this sybase error go away with any change to the query?

A query I've been using for years has suddenly started throwing a weird error. When I made a cosmetic change to the query (1+x instead of x+1), the error no longer occurs. The stored proc it's complaining about doesn't even exist on the server…
anthonybell
  • 5,790
  • 7
  • 42
  • 60
8
votes
1 answer

Proper DSN to connect to Sybase using PDO

I'm trying to connect to a Sybase (SQL Anywhere 12) database using PHP's PDO. I spent hours trying to find the correct driver and DSN to use, with NO success AT ALL. Everytime I try to edit a single parameter I always get errors. I tried tens of…
tobia.zanarella
  • 1,246
  • 1
  • 17
  • 25
1 2
3
…
99 100