Sybase Database

4K

Solutions

2

Articles & Videos

2K

Contributors

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Refine results

I am inserting records into a Sybase Table using
I am using a C# program to read in the records from a txt file named InputFile.txt into a Sybase table titled tableA.
One of the fields I read into …

239 views
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Windows 2012, SQL 2008 STD.
I have a database of 60GB size, not too big.
I am trying to rebuild index and update statistics using SQL SMSS Maintenance Plan.
Rebuilding index went smooth, took le…

567 views

Dears, what does mean the 'unknown device type' in description column in the result of sp_helpdevice ?

And for these devices, is it preferred to set dsync option to true and directio to false.

A…

421 views

Dears,
kindly note we have two servers: sybase ase 15.7 and sybase 15.0.3

I need to upgrade sybase ase 15.0.3 to ase 15.7, I read about that and I will do the following steps:
as I will install a…

221 views

Dears, kindly note that I have installed a new sybase ase 15.7 on my server, and I have dump of mydb taken from 15.0.3 before install new version of sybase, now I want to:
load mydb dump (and I read …

216 views

Dears, kindly note I have created an external login and a remote login as following: sp_addremotelogin remoteserver,locallogin1, remotelogin1 sp_addexternallogin remoteserver,locallogin1, remotelogin1…

517 views

I need to convert this Sql server sql to Sybase Sql. I am getting an error message : "Incorrect syntax near TOP'. How do I change the code below so that it will run on Sybase?


IF NOT EXISTS (SELE…

821 views

I downloaded sybaseOT and was able to install it. I vpn to the system then opened Sysbase Central , go to tools then connect.  I entered "sa" for user id and provided the password. However, I get :
c…

337 views

Hello Experts,

Running the SQL query below is inflating numbers for net total, transaction count, and labor. Not sure why...

(CODE)


Ideas?

I believe it may have to do with the "transact"…

1263 views

I am not able to create the below Sybase stored procedure. The Sybase error indicates that it does not like the line where
my TRUNCATE command is. The error message says incorrect syntax near @inTab…

434 views
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

In Sybase, I can run this query - select * from sysservers

and get a list of servernames which host my database(s). So how do I find out which databases are associated with my list of servers?

339 views

Can a Sybase expert look at my Sybase sql below. I am building a query and then I need to pass it off to be executed at line 3 below.
The table being truncated is on a linked server, and so I am appe…

345 views

Hello Sybase Experts. I am porting some SQL Server sql to Sybase sql. The SQL Server sql uses several TRY CATCH blocks in sql server.
Is there any similar type of structure in Sybase to handle except…

155 views

In SQL server I can get the date in military time using the following Query:
SELECT CONVERT(TIME,GETDATE())
Example of output : 22:03:15.4700000

Is there any type of similar query in SYBASE which…

350 views

Hi SQL Admins

I would like to ask you for professional recommendation and suggestions regards new MS SQL server setup.
My plan is to upgrade entire SQL system so it would be reliable and would hav…

1393 views

I am wondering if there are any SYBASE sql coders who can spot any syntax errors at line 355. I am getting this error message,
and cannot spot what the problem is?

Incorrect syntax near '+'.

35…

546 views

We have a Sybase Database that  needs to sync with a service, however they are asking for a read only DB user. I am not sure there is a default user already in  place. I just need to provide credentia…

174 views

Hi,

when we use surrogate key in database world. what is its importance of it. please advise

672 views

Hello Experts,

I am trying to update a table and set a value equal to another value where some IDs match.

Store Number      Product Number      BOHMax
1                                    100            …

1054 views
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

I so often hear "There is no use case with us that supports in-memory HANA database for our applications. As HANA is useful for only data warehousing (OLAP) applications like SAP BW and not for OLTP a…

7183 views

I have a very large range partitioned table in ASE 15.7. I would like to migrate this table to a new empty copy. The extraction from the old table will perform various calculations and manipulations, …

5117 views

I've been learning about in-memory computing (both Oracle and SAP Hana) and this is looking like a major revolution, no ? Making the architecture of the 90's a relic of the past ? Just trying to under…

7127 views

I have  a table like this
id,name,email
1,John,john.s@gmail.com,john.s@yahoo.com,john.s@aol.com
2,Mark,mark.s@gmail.com,mark.s@yahoo.com,mark.s@aol.com

I want to display the comma separated emai…

162 views

I'm having trouble fixing the syntax in this statement:
 SELECT Administrator_VhStock.[NO], Val(Right([BR],1)) AS BR2, IIf(Administrator_VhStock.Usage="D","D",IIf(Administrator_VhStock.Usage="L","L"…

242 views

What was the logic of SAP buying Sybase for $5.8 billion when SAP was building SAP HANA from the grounds up as a contender for all other databases especially Oracle and Sql Server.

It would have be…

3139 views
Show more content
201506-LO-Top-001
Top Experts In
Sybase Database
<
Monthly
>

No Top Experts for this time period. Answer questions to earn the title!

RELATED TOPICS view all topics

  1. Databases
    (53,488)
  2. MS SQL Server
    (156,654)
  3. Query Syntax
    (47,287)
  4. Oracle Database
    (77,856)
  5. Editors IDEs
    (24,951)
  6. MS Access
    (215,524)
  7. MS SQL Server 2005
    (71,484)
  8. Unix OS
    (32,678)
  9. MySQL Server
    (46,354)
  10. .NET Programming
    (131,532)