Sybase Database

4K

Solutions

2

Articles & Videos

3K

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.

Related Topics

  1. Databases
  2. Microsoft SQL Server
  3. Query Syntax
  4. Oracle Database
  5. Editors IDEs
  6. Microsoft Access
  7. Microsoft SQL Server 2005
  8. Unix OS
  9. MySQL Server
  10. .NET Programming
Refine results

UNABLE TO CONVERT THE DLI_MAIN_CODE AND | CHAR

--SQL================================
CREATE TABLE #PROOF
(
    dli_barcode numeric NOT NULL,
    all_dli_main_code varchar(10) NOT NULL
)

1552 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

i want to check if the Windows server has the following software installed on it.

IBM DB2
IBM IMS
Unisys RDMS
Unisys DMS
Sybase
Oracle

I believe we can check this if there are services …

372 views

Below is the output set I want from an SP. I will have count as input parameter to the  SP
so If count in 3 and I want the result to be c1, c2, c3, c4, c5,c6,c7,c8,c9
If the Count is 2, then …

469 views

hi,

as I know replication server is belongs to the Sybase server and any technology different between Sybase replication server( need a separate license I know) and MS SQL build replication.

why…

1382 views

I have a table in which one column(attribute) have multiple values on the coma seprated basis. Now i need to break them Or convert into 1nf, So please tell me how to do this.
EX-      name      phone…

467 views

hi,

i know how to select top 100 rows or bottom 100 rows from sybase sql statement but how can get only middle rows like from 501 to 1000 rows,

for top 100.. i use
select top 100 * from tablename

456 views

Hi,
I've Sybase ASE 15.7 version.

Often I have a process that fill up my transaction logs, to see which process is responsible for filling up the logs I run this query:

select …

198 views

Hello Experts,

I am running the below query then displaying the results in a DataGridView in VS2015 (C#)

(CODE)

When the query runs and the results display, the "Dollars" column shows 6 …

870 views

This question seems to be pointless. But we have an old stored procedure inserting data without a column list and there is a new column. Procedure is not working in test environment giving an error …

16122 views

We run a number of reports for our business throughout the day.
These queries are executed by the Task Scheduler via VB scripts.

The queries query our CRM database, and use an ODBC connection.

1175 views
[Webinar] Code, Load, and Grow
[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Hello Experts,

I have a SyBase database and when I select the field I get

9/19/2016 4:05:00 PM

I want to return only the the time portion in HH:MM 24 hour format....desired return is: 16:05…

462 views

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 …

2107 views

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 …

5248 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.

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

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

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

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

880 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 :

391 views
On Demand Webinar - Networking for the Cloud Era
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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

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

477 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?

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

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

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

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

Sybase Database

4K

Solutions

2

Articles & Videos

3K

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.

Related Topics

  1. Databases
  2. Microsoft SQL Server
  3. Query Syntax
  4. Oracle Database
  5. Editors IDEs
  6. Microsoft Access
Top Experts In
Sybase Database
<
Monthly
>