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

dbisql wrong output when ran via Windows batch script

I am querying a Sybase SQL Anywhere 17 database to get a count from a table, and outputting that count (number) to a txt file. Running in cmd window is fine, but running via batch script gives a different result. The following works exactly as it…
Mark Jones
  • 1
  • 2
0
votes
0 answers

Sybase Database Support on Node.js with SSL

I am working on this project that has been bugging me for a while and wanted to ask community's help on it. So basically we have an On-Prem Sybase database that needs to communicate with a cloud micro service running in Kubernetes in AWS. I am…
Sam
  • 57
  • 7
0
votes
1 answer

Unable to use SQL Anywhere Sybase packages for Java + SQL Anywhere 17 does not install Sybase Central in any systems

There are two parts to this question. I have been trying to install and test SQL Anywhere Sybase connection using an existing project in Eclipse. I did the following: Installed SQL Anywhere 17 Navigated to the SQL Anywhere 17 Java folder and used…
Arjun G
  • 53
  • 7
0
votes
0 answers

C# Dapper IN clause very slow

I just come across a Dapper performance issue. Pseudo code is like: connection.Query("select field1, field2, field3 from table1 where field1 in @inputs", new { inputs }); It has taken around 4 minutes when the variable inputs has 200 items. When I…
James Rao
  • 168
  • 2
  • 13
0
votes
0 answers

SybSQLException: SQL Anywhere Error -188: Not enough values for host variables with jdbc42 SybDriver

I use com.sybase.jdbc42.jdbc.SybDriver to connect to sybase. I get SQL Anywhere Error -188: Not enough values for host variables when I execute multiple statements like this : delete from CHARGING_PLAN2APPLICATIONS where CHARGING_P LAN_ID=?;update…
Igor_M
  • 308
  • 2
  • 12
0
votes
2 answers

How to distinguish trigger actions in sql?

I'd like to create on Trigger that is fired on insert, update and delete. Inside the trigger I need to handle those actions in different ways. How can I find out which action triggered the trigger ? Or, should I use multiple triggers for different…
user1119859
  • 669
  • 2
  • 9
  • 20
0
votes
0 answers

Migration from com.sybase.jdbc3 to com.sybase.jdbc42 leads to SybSQLException

I used net.sourceforge.jtds.jdbc.Driver driver for write connection and com.sybase.jdbc3.jdbc.SybDriver for read connection with Sybase. I replaced both with com.sybase.jdbc42.jdbc.SybDriver and now I on some operation I get…
Igor_M
  • 308
  • 2
  • 12
0
votes
1 answer

Fetching Live Data using C#

I am actually stuck at a point of development. I have written quite a big code in C# (have not so much experience in C#). What the code basically does is that it runs an infinite loop in which it calls another C# file or class. That file first…
Shahroz Ahmed
  • 1
  • 1
0
votes
0 answers

Sybase SQL to sqlAchemy query null is getting ingnored on left join

I am trying to convert below Sybase query into sqlAlchemy code but getting different result. select distict A.ip, isnull(HH.hn,'-') from DS d, IN I, DHC A, DBI H, DBI HH, DBI H2, where S.id = I.id and A.ip = I.ip and A.ip = H.ip and HH.df=0…
tempuser
  • 1,517
  • 3
  • 11
  • 15
0
votes
2 answers

SUP101: blackberry

I've been following the SUP101 tutorial for both IPhone and Blackberry. http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01208.0152/doc/html/vhu1236620712162.html I managed to make both work. But, when I tried to launch…
Jason Rogers
  • 19,194
  • 27
  • 79
  • 112
0
votes
0 answers

Displaying Binary data Correctly from Database

I have been fighting with this for days now. Can't seem to get to the bottom of it. I have a Sybase table that has a long binary field which contains a jpg. I am pulling the pictures from the table using this query. PHP.ini file has memory_limit =…
AmbientGuitar
  • 34
  • 3
0
votes
0 answers

AseConnection error : Cannot convert '08/10/09' to a timestamp

Data.AseClient for connecting to Sybase database from .Net Web API project. This is my part of the code calling the SP AseCommand dbCommand = new AseCommand("exec My_SP 202111,11488", connection); …
vivek v
  • 167
  • 1
  • 3
  • 16
0
votes
0 answers

Deleted a row in sysobjects in sybase

I was querying tables in sysobjects when I accidentally pressed "D", triggering the delete row option in the results pane. For some reason, I can still query the table using the select statement but when I use the lookup table option (F7), the table…
JC Tejada
  • 9
0
votes
1 answer

Android/JDBC:JTDS and Sybase

We are trying to use JTDS with Sybase and Android. We are using the "SQL Anywhere" formerly Sybase Anywhere (we think???), and it seems as if we are talking to Sybase (Sybase 9), because the exception is "Login Failure" and we are using a connection…
BitWiseByteDumb
  • 159
  • 1
  • 12
0
votes
1 answer

Sybase regexp, substr, instr function to split the string

I have the below data in a table. row_num desc 1 First Name/Last Name - Middle Name 2 FirstName/LastName - MiddleName 3 FirstName/LastName I am looking for the desired output as below row_num desc_1 desc_2 desc_3 1 First…
Bruce
  • 109
  • 8
1 2 3
…
99 100