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: BETWEEN vs "<=" and ">=" operators

Is there a fundamental difference in terms of performance with regards to using BETWEEN versus the comparison operators? One of the wikis recommends the latter: 3: Replace the BETWEEN with >= and <= operators because BETWEEN in turn converted to…
Ver Argulla
  • 71
  • 2
  • 9
0
votes
1 answer

Sybase - Change a table column datatype on an IDENTITY column which is a User Definied Datatype

I'm pretty good around Oracle but I've been struggling to find a decent solution to a problem I'm having with Sybase. I have a table which has an IDENTITY column which is also a User Defined Datatype (UDD) "id" which is numeric(10,0). I've decided…
raven-king
  • 1,550
  • 2
  • 18
  • 40
0
votes
1 answer

Resolve concurency during updating table in Sybase

I have a procedure in Sybase with the following code. begin transaction get_virtual_acc UPDATE store_virtual_acc SET isProc = 1, Uid = @uid, DateReserv = getdate() from store_virtual_acc (index idx_id) WHERE id = (SELECT min(id) FROM…
leonart81
  • 3
  • 2
0
votes
1 answer

collecting result of exec in some variable in sybase

How to collect the result of exec(some_dynamic_query) statement in some variable? This is my code snippet exec('Select count(*) from'+@tabname) where table name is fetched by a cursor into a variable and the above statement is inside a loop
Aditya
  • 549
  • 1
  • 6
  • 11
0
votes
1 answer

SyBase: Creating a Unique Index Based on The Value of The Columns

I want my table to prevent duplicate entries only if the value of ColumnA is equal to a certain value. For example, let's say there are already two records in my TableA( ColumnA, ColumnB, ColumnC ) with the values ( 0, 'Damage', 'Inc.') and ( 1,…
Halo
  • 1,524
  • 3
  • 24
  • 39
0
votes
2 answers

PowerBuilder: Disable menu item in web form only

I've deployed a PowerBuilder application to a .net web form application. There are some menu items which I would like to disable in the web-application only. After deploying the application to web form application, I have two targets in my…
user966585
  • 830
  • 3
  • 10
  • 15
0
votes
1 answer

Blackberry: Sybase(SUP): LoginToSync: register callback

I'm new to Blackberry and Sybase and I must admit that I'm really hating the lack of info for both... trying to write a plugin that will allow me to connect and login to my sybase. I'm currently blocked by this line…
Jason Rogers
  • 19,194
  • 27
  • 79
  • 112
0
votes
1 answer

Sybase compare number of values from 2 queries in one query

Is it possible to compare the count of 2 separate queries in one step? I have table A which has x records. From table B, I want to check that all x records are within it. I'm struggling to find a way to go this. I've been looking at this for days…
pm13
  • 735
  • 7
  • 23
  • 36
0
votes
1 answer

Can i use cursor inside a cursor in sybase?

i want to use cursor inside a cursor or can i write query like select t.name,t1.name from dbo.sysobjects as t, dbo.sysobjects as t1 where t.name like 'a%' or t1.name like "b%a" and use a single cursor to fetch the both kind of table name?
Aditya
  • 549
  • 1
  • 6
  • 11
0
votes
1 answer

sybase boolean variable or workaround?

No bool (variable) in sybase I guess? Is there a workaround? select @w=width, @h=height from Rectangles where id=1 select @a = @w * @h select @isWide = @w > @h -- doesn't work
Gary
  • 241
  • 2
  • 13
0
votes
1 answer

How to collect value returned by select statement in sybase if select returns multiple row of value?

I have a query say "select name from books_det" ,and this query returns say 10 rows(name) , now i want to access the value of each and every row(i.e name) . How will i accomplish this in sybase? I have tried declare @var varchar select @var=name…
Aditya
  • 549
  • 1
  • 6
  • 11
0
votes
0 answers

Msg 4845, Level 16, State1 Bulk copy failed. Client does not have the capability to bulk copy into the data-only locked table

I am trying to insert data from file to sybase table but while using bcp_init I get this error Bulk copy or insertion. When I am trying to insert an empty file with bcp on terminal it works. But fails via code using bcp_init
Siddhi Thakur
  • 1
0
votes
0 answers

Improve performance query on SYBASE ASE

I hope you could help me on the following problem. I have the below query which is taking too munch time (hours) and it is eating all the resources available ( currently I have 2 engines of sybase ase 15 and 4GB of memory assigned to them). The…
user3303852
  • 1
0
votes
1 answer

Create unique char value in Sybase

I need to create a Syb15 stored proc that takes a char(6) @parent and returns a unique char(6) based on @parent. I want to truncate @parent to a max of 3 chars, and then append letters [A-Z] to that value such that the new symbol has not been used…
Jared
  • 2,043
  • 5
  • 33
  • 63
0
votes
1 answer

How to query a Sybase database from the shell?

I want to write a shell script wherein I have to find out the name of the tables begining with ad (I have written a query for that) and then I have to take backup of each such table present in database. I am using sybase database. How can I process…
Aditya
  • 549
  • 1
  • 6
  • 11
1 2 3
…
99 100