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

Are CTE's used in sybase?

i JUST WANT TO KNOW IF cte's are used in sybase too...i knw that cte's used for sql server..but have no idea whether they are used for sybase... If Cte's are not used for sybase, is there a any other method in sybase that it performs as CTE in sql…
sonu
  • 95
  • 2
  • 7
0
votes
2 answers

Query for summation up to certain rows in a table

I have a query like: select CONVERT(VARCHAR(7),[startdatetime],111) AS [year-month], nm.nameLine1, sum(datediff(hour, startdatetime, enddatetime)) as total from srl inner join sr on srl= sr.ServiceRequestId inner join Name nm…
sonu
  • 95
  • 2
  • 7
0
votes
3 answers

Find all stored procedures with particular starting name

I have many stored procedures in my database. I have to transfer a few of them to a different server. I need to find the procedures starting with "ABC". How do I search all these stored procedures?
Aniruddha
  • 3,157
  • 4
  • 32
  • 48
0
votes
1 answer

PowerDesigner (Database design) - add PK to cross-reference table

i would like to know how to add PK to cross - reference table which is created from converting Conceptual Model to Physical Model and associate it with other table as FK. Conceptual Model Physical Model Expected Result Physical Model Job…
xyz
  • 2,277
  • 2
  • 25
  • 41
0
votes
1 answer

Nhibernate dialect and driver to use for connecting to a sybase database in .net

In version 2 of Nhibernate, I had it working with below fluent nhibernate configuration: NHibernate.Dialect.SybaseAdoNet12Dialect,NHibernate
dreamerkumar
  • 1,540
  • 1
  • 18
  • 28
0
votes
0 answers

Fetching all rows at once into the memory with Sybase

In our application which is completely in C++,we are using the Sybase libraries for firing select queries and after the connection is established we are fetching each row using next(). My query here is is there a way where we can fetch all the rows…
Vijay
  • 65,327
  • 90
  • 227
  • 319
0
votes
1 answer

Sybase-Perl DBLib mapping of fourth argument to DBI Connect

I am converting a perl script from DBlib to DBI for sybase connections. I am Implementing kerberos. what is the function of the fourth argument (the name of the perl script) in the DBLib connection and equivalent in DBI? eg. DBLib Connection: $dbh …
Mohit
  • 2,239
  • 19
  • 30
0
votes
1 answer

NamedParameterJdbcTemplate jconnect decimal issue

I am using NamedParameterJdbcTemplate to insert data into a table. (Spring 2.5.3/Java 1.6) I am using jconnect driver to connect to sybase jdbc:sybase:Tds::. For some reason the decimal values the decimal part is truncated. With the…
Fundoo
  • 19
  • 3
0
votes
1 answer

isql DECLARE statement to psql

I have a PostgreSQL DB and have a script which calculates dates from an old Sybase DB. How can I do the same thing is PostgreSQL ? isql DBCOMMAND="eval isql -d $DATABASE -U user -P passwd " $DBCOMMAND << MSG > $LOG_MEM_EXCEP DECLARE…
Sharon
  • 401
  • 1
  • 4
  • 5
0
votes
4 answers

Bulk insert in SYBASE using .NET

How can I do bulk data insert in Array in SYBASE table using in .NET. I don't want to use BCP utilities.
Nps
  • 1,638
  • 4
  • 20
  • 40
0
votes
2 answers

how to join on varchar(32) and binary(16) columns in sybase?

I want to join two tables on a UUID. table A's UUID is represented as varchar(32). table B's UUID is represented as binary(16). what's the best way to join a varchar to a binary column? I've tried using some sybase functions for this, but I'm…
Paul Sanwald
  • 10,899
  • 6
  • 44
  • 59
0
votes
2 answers

sysbase sql query a tree

I have seen a lot of answers to this question, but I still can't figure out how to do it. I'm using Sybase. But I prefer a standard SQL answer. I have a table that forms a number of tree structures. I would like to get the list of all child nodes…
Charbel
  • 14,187
  • 12
  • 44
  • 66
0
votes
1 answer

Sybase Temporary Table and Indexes

Is this a misconception? Sybase query optimizer can not consider index on temporary table if it is created and used in same batch or procedure. I'm a bit confused about this as there seem to be differing opinion. Thanks heaps.
Ver Argulla
  • 71
  • 2
  • 9
0
votes
2 answers

Update model (edmx) with system tables (SYS.xxx) - Sybase

When selecting 'update model from database' none of the system tables (SYS. schema) is available from the list of tables. How may I add a system table to my EF model. Sybase (ASA12) is the database platform which I am using.
Kman
  • 4,809
  • 7
  • 38
  • 62
0
votes
1 answer

Optimal update in resultset on Sybase IQ

Im looking to rewrite code that update a table on a Sybase IQ database v14 that does the following: selects all the records in the table and extracts some data to file updates the extracted to file flag for each record in the table Currently, once…
biosFF
  • 223
  • 2
  • 9
1 2 3
…
99 100