sap-ase Questions
5
Solved
I would like to know the exact version of Sybase currently running on my machine.
Please let me know how to get this info?
5
Am working on sybase ASE 15. Looking for something like this
Select * into #tmp exec my_stp;
my_stp returns 10 data rows with two columns in each row.
Tabu asked 3/10, 2008 at 9:29
4
Solved
I am trying to connect to Sybase database from .net core but I do not find any good library. Can someone suggest library to connect to Sybase?
Strobilaceous asked 6/4, 2017 at 16:0
2
Solved
I am currently connecting to a Sybase 15.7 server using sybpydb. It seems to connect fine:
import sys
sys.path.append('/dba/sybase/ase/15.7/OCS-15_0/python/python26_64r/lib')
sys.path.append('/dba...
3
Solved
In sql server 2012 i'm using
USE myDatabase;
GO
SELECT *
FROM sys.objects
WHERE type = 'U';
Is it possible to do the same in syBase ?
6
I'm writing an application to move data from Oracle to Sybase and need to perform update / insert operations. In Oracle, I'd use MERGE INTO, but it doesn't seem to be available in Sybase (not in AS...
12
Solved
I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that?
Thanks.
2
Solved
Apparently when inserting an empty string ('') in a VARCHAR column Sybase (tested in ASE 15.7) inserts a single space character instead. Experimenting I verified that the option ansinull has no bea...
Lobbyist asked 11/9, 2018 at 21:40
5
Solved
I'm looking for an ADO.net 2.0 or later provider for Sybase database which seems to be known as Sybase ASE. To clarify, I'm interested in ASE, and not SQL Anywhere. Hopefully the provider will be i...
1
Solved
1. Has anyone successfully used ODBC from c# to Sybase ASE?
2. Or Better, has anyone successfully used Sybase ASE with .NET Core?
I am using .NET Core 1.1 and the current Sybase.AdoNet4.AseClient...
Beheld asked 27/7, 2017 at 0:8
11
Solved
So I have a Sybase stored proc that takes 1 parameter that's a comma separated list of strings and runs a query with in in an IN() clause:
CREATE PROCEDURE getSomething @keyList varchar(4096)
AS
S...
4
Solved
Why should I use GO when writing sql for sybase? In most of the existing sql my project has, there are no GOs but when DDL is generated for table creation, as an example, the application inserts ma...
8
Solved
Is there a good tool from either Sybase or elsewhere that will enable me to debug stored procedures in Sybase ASE? I need to be able to set breakpoints & watchpoints.
Previously, in Sybase ASA...
Fiasco asked 6/2, 2009 at 0:36
4
Solved
I am trying to migrate some legacy procedural code. I am having trouble figuring out the ANSI standard syntax to produce the same results.
Below is one of the many combinations I have tried. What...
Fatling asked 29/8, 2012 at 21:7
2
Solved
I know the statement in oracle which copies the structure and the data.
create table mytable1 as select * from mytable;
But how to achieve the same in Sybase ASE?
Lowly asked 10/4, 2012 at 11:15
5
Solved
I have this code:
select a.id as tableid,
a.name as tableName,
b.name as columnName,
b.status as columnStatus,
b.type as columnType
from sysobjects a
LEFT JOIN syscolumns b
ON a.id = b.id...
4
Solved
I am developing an app using node.js express framework and would need to connect to sybase ASE database. I did enough search and couldn't find the sybase driver for node.js. doesn't node.js support...
2
Solved
This should be simple.
The Sybase docs ("Example 1") say you don't have to specify the size parameter but even if I do:
create database pubs5 on default = '10M'
I still get an error :
Could no...
0
I am using ApacheMetaModel to Extract the data from Sybase ASE 15.5 database that installed on Windows 7 machine. I am Extracting data into CSV in multi-threading environment. I using these open so...
Chiquitachirico asked 11/2, 2016 at 10:21
3
Solved
I have a list of columns a co-worker has given to me, but these columns reside in different tables in the DB. Is there some kind of tool in Sybase where I can query the table a column belongs to?
...
5
I'm using a Sybase ASE database.
I have two tables that look like:
Table Shops:
---------------------
| ShopName | ShopID |
---------------------
| Sweetie | 1 |
| Candie | 2 |
| Sugarie | 3 |
-...
Ripp asked 17/9, 2010 at 18:5
1
I am unable to use sybase replace function to replace data.
Basically what i need is to update all the occurrences of 'abc' and change with 'zzz'.]
table_clmn is data type text
I am using the follo...
1
A query I've been using for years has suddenly started throwing a weird error. When I made a cosmetic change to the query (1+x instead of x+1), the error no longer occurs. The stored proc it's comp...
Frodine asked 30/1, 2015 at 17:4
9
Solved
OK, so Sybase (12.5.4) will let me do the following to DROP a table if it already exists:
IF EXISTS (
SELECT 1
FROM sysobjects
WHERE name = 'a_table'
AND type = 'U'
)
DROP TABLE a_table
GO
B...
Kathykathye asked 21/11, 2008 at 5:15
3
I'm looking for a methodology to compare the difference between 2 rows in the same table. From what I found here (How to get difference between two rows for a column field?) it's almost what I want...
1 Next >
© 2022 - 2025 — McMap. All rights reserved.