Stack Overflow
Stack Overflow

Questions tagged [sap-ase]

SAP Adaptive Server Enterprise (ASE), formerly known as Sybase ASE, is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language.

SAP Adaptive Server Enterprise (ASE) is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language. Until version 15 it was known as Sybase ASE, but as of version 16, SAP has retired the Sybase name.

SAP ASE is an enterprise RDBMS which has been developed by Sybase Inc (now an SAP company). SAP ASE is available for various platforms like Unix, Linux and Windows.

1291 questions
0
votes
2 answers

insert the row to another table when delete a row in a table with text column -- sybase

For example, create table t1 ( a int, b text ) create table t2 ( a int, b text ) insert t1 values ( 0, 'abcde' ) When I delete t1 rows, I want it to move in t2. Maybe we can name t2 as t1_hist if it helps you to understand. It's easy to come up an…
Ming Yang
  • 1
0
votes
1 answer

Sybase Linux vs Sybase Windows BCP - Can't Connect

I've been doing some Sybase stuff on Linux and have bcp in's and out's working great. Here's my working bcp out on linux: bcp drd02.dbo.APPL_ENVIRONMENT out APPL_ENVIRONMENT.bcp -U sa -P SyAdmin -n When trying the same in Windows, I get the…
Beatscribe
  • 423
  • 8
  • 17
0
votes
2 answers

Create a Dynamically Growing Sybase Database?

I am building a little installation/packaging script that deploys various database schema items and procedures. Right now, I just use this to make the database: CREATE DATABASE dbname GO However, when i point my little package at my larger…
Beatscribe
  • 423
  • 8
  • 17
0
votes
1 answer

how does the caching process work in ASE 15.0.3

I am monitoring a Sybase server (ASE 15.0.3) for it's performance. One of the things it monitors is the cached data. but I want to understand how the caching process really works in ASE 15.0.3. Can one instance of ASE 15.0.3 cache statements running…
user2976863
  • 3
  • 1
0
votes
1 answer

Sybase SQL Query Clarification

I have a sybase sql query and its returning an integer as the result. Can anyone explain the logic of this query. select b.length from sysobjects a, syscolumns b where a.name = 'StuComm' and a.id = b.id and b.name = 'StuCD'
Dark Matter
  • 2,231
  • 3
  • 17
  • 31
0
votes
1 answer

Extract data from Sybase ASE 15 using SSIS 2008 in Unicode format

I'm attempting to use SQL Server Integration Services (SSIS) 2008 R2 to extract data from a Sybase ASE 15 database. I've managed to configure the OLE DB Source with the correct connection information and can see the tables and data. However no…
Cynicszm
  • 96
  • 1
  • 8
0
votes
1 answer

java sybase connection with invalid database name

I am connecting to Sybase ASE with JDK7u25 and JConnect_JDBC3.jar (it appears to be Sybase JDBC version 6.0). My URL is as follows: jdbc:sybase:Tds:MYSERVER:5004/myDB I can connect to the server without any problem. However, even if I specify the…
ParagJ
  • 1,566
  • 10
  • 38
  • 56
0
votes
1 answer

Error in Insert query in a table by executing one system proc in sybase

I am getting error while inserting data inside table TableSizes with below query, Could anyone please help me in this regard. declare @name varchar(256) select @name ='TestTable' begin insert into workdb..TableSizes exec sp_spaceused…
Manoj
  • 1
0
votes
1 answer

show an error while create own default constraint name in datetime datatype column

CREATE TABLE [guest].[m_WORKING_HOUR_SETTING]( [GROUP_ID] [int] NULL, [WORKING_START_HOUR] [varchar](10) NULL, [WORKING_END_HOUR] [varchar](50) NULL, [CREATED_TIME] [datetime] NULL CONSTRAINT [DF_WORKING_HOUR_SETTING_CREATED_TIME] …
Mani Kandan
  • 11
  • 4
0
votes
2 answers

java sybase setAutoCommit(false)

This could be a silly question, but please bare me as I have little knowledge on database with Java. I am developing a component for which I want to give an option to user so that auto-commit can be set to false. This is for performance boost. I am…
ParagJ
  • 1,566
  • 10
  • 38
  • 56
0
votes
1 answer

How to get text that is printed into console using sybase procedure into shell script

I have a sybase procedure which prints data like: print 'Hello World'. How can I get that text into shell script. In other words how can a shell script read from the console of the database?
Ravi Teja
  • 19
  • 1
  • 7
0
votes
0 answers

Getting out parameter from stored procedure to shell script

I have a shell script which executes a stored procedure in the Sybase database. How should I get the out parameter from the procedure?
Ravi Teja
  • 19
  • 1
  • 7
0
votes
1 answer

Error while creating TEMP table

I have this query CREATE TABLE tempdb..TEMP_DET( DB_ID NUMERIC(5,0) NOT NULL, DB_D VARCHAR(30) NOT NULL, LAN VARCHAR(3) DEFAULT ''N'' NOT NULL) and I got this error: Server user id 13 is not a valid user in database 'model' Does anyone…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
1 answer

Datatype to store large text values in stored procedures in sybase

Is there a datatype to pass as an out parameter to a stored procedure in Sybase that can hold indefinite amount of data? I learnt that we cannot use text as a datatype. Please help me out
Ravi Teja
  • 19
  • 1
  • 7
0
votes
1 answer

Count of repeated column values in Sybase

I have a requirement wherein I have to find how many times a particular column has repeated. For Example: Col1 | Col2 ------------ 1 |2 2 |2 3 |3 4 |3 5 |3 in the above table, value '2' in the column is repeated twice and value '3'…
Ravi Teja
  • 19
  • 1
  • 7
1 2 3
…
86 87