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 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…

318 views
Course: Foundations of Front-End Development

Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

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"…

1243 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…

416 views

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?

321 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…

325 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…

124 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…

320 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…

1373 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…

531 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…

133 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Hi,

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

652 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            …

1038 views

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…

7115 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, …

561 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…

7102 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…

139 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"…

229 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…

3105 views

Create table #test...
Insert into #test...
Update #test
Select * from #test

Are all these sybase statements possible with a single prepare, execute and fetch call in perl dbi?
Otherwise whats t…

269 views
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Hi Experts

Since a long time I didn't follow the PowerBuilder technology, I've been using version 7.

Could you please give me a sumarized guidance on how to becoming actualized to the newest ver…

335 views

Within a stored procedure, it seems that some "set" directives are ignored by Sybase while others aren't. I'm having trouble understanding why the simple example below displays statistics details, but…

250 views

I have a table that has certain rows. I need a query to check if the data in the table were inserted in the ascending order.

E.g: Below. I will filter the value codes 80,81. CLCL_ID and CLCL_LINE_N…

1176 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",…

1862 views

Hello Experts,

I have a query that I need some help with. I narrowed down the problem to being with the HowPaid table. It seems all of my "Sums" are being summed erroneously because of multiple ent…

11101 views

Hi there,

I am trying to save files which are stored in BLOB fields in a Sybase database.

The routine below seems to work, files are being saved in my folder, but when opening them they seem to …

3127 views
Show more content
201506-LO-Top-001

RELATED TOPICS view all topics

  1. Databases
    (53,338)
  2. MS SQL Server
    (156,078)
  3. Query Syntax
    (47,106)
  4. Oracle Database
    (77,645)
  5. Editors IDEs
    (24,937)
  6. MS Access
    (214,939)
  7. MS SQL Server 2005
    (71,396)
  8. Unix OS
    (32,624)
  9. .NET Programming
    (131,275)
  10. MySQL Server
    (46,190)