Questions tagged [sybase-ase15]
120 questions
0
votes
0 answers
Apache Sqoop and Sybase Import to hdfs
I am looking for the exporting db table content into the csv file. For that I found that Apache Sqoop does it very fast. and also import into hdfs.
I am successfully able import to hdfs using Apache Sqoop for Oracle 11g. Now when I tried for Sybase…
Tej Kiran
- 2,218
- 5
- 21
- 42
0
votes
3 answers
Where to get sybase ASE 15.x for windows 64 bit
where can I find setup for sybase ASE 15.x for windows 64 bit.
Misha gupta
- 47
- 2
- 8
0
votes
1 answer
Join query returns more rows than nested select query?
I have the following queries:
SELECT count(*)
FROM User u
INNER JOIN NAME n
ON u.UserId = n.UserId
AND n.last = 'Joe';
--returns 1943
SELECT count(*)
FROM User u
WHERE u.UserId IN (
SELECT n.UserId
FROM NAME n
…
johng2
- 27
- 1
- 5
0
votes
1 answer
Does weblogic 10.3.6 supports Sybase version 15.7.x officially?
Does anybody knows how to verify the supported versions of Sybase by a particular version of Oracle Weblogic Application server?
We are using Oracle Weblogic Server 11g(10.3.6) on a solaris box. We are connecting to Sybase Database using jConn jar.…
user3172675
- 23
- 1
- 4
0
votes
1 answer
SQL Server Output Clause equivalent in Sybase
Is there a SQL Server Output clause equivalent in Sybase Version 15? As far as I know there's no Output clause in Sybase which gives the output rows from Update, delete query.
youfree
- 39
- 6
0
votes
1 answer
What is the Difference between global temp table and local temp table in SYBASE ASE 15
What is the Difference between global temp table and local temp table SYBASE ASE 15 ?
And how both would behave when access multiple time from java with different thread/connection/db method invocation ?
Global temp table's starts with ## and local…
barun
- 393
- 1
- 5
- 19
0
votes
0 answers
How to access temporary table(# table sybase ase 15) from java using mybatis
I have requirement such as
follow are the steps
step 1 : From java process I will create a temp table(# table ).
step 2 : Insert some data to that temp table(# table ) after parsing a csv file.
Step 3 : Will call a Procedure which will access…
barun
- 393
- 1
- 5
- 19
0
votes
1 answer
How to return just first parent element, but many children and grandchildren in Linq with Entity Framework - SYBASE ASE Connector bug
I have the following Linq statement:
car car = db.cars
.Include("wheels")
.Include("windows")
.Where(c => c.id == id)
.FirstOrDefault();
I have lazy loading turned off. I want to return a…
trees_are_great
- 3,881
- 3
- 31
- 62
0
votes
2 answers
Powerbuilder 9.0 application crashes on Windows Server 2008
Powerbuilder application on server crashes whenever we try to disconnect the database profile using database painter. We are using SYC Sybase ASE Database profile. Following are the problem details:
Problem signature:
Problem Event Name: …
Learner
- 3
- 3
-1
votes
1 answer
Dropping a constraint in sybase ASE [Cannot drop the constraint]
I want to drop constraint of a column, like this,
alter table dbo.menu_items
drop constraint FK_menu_items_menu_icons
but I am getting an error,
SQL Error [3701] [42S02]: Cannot drop the constraint 'FK_menu_items_menu_icons', because it doesn't…
Jabri Juhinin
- 21
- 6
-1
votes
1 answer
Sybase SQL: row number over a partition
please could you help me? I am trying to understand how Sybase ase SQL works.
Basically I have a query like this:
select ClientId,StartDate,EndDate from TableName
And I need to create a temporary table where I will have
ClientID = A, StartDate…
Coozmarr
- 3
- 2
-1
votes
1 answer
Altering Stored Procedures in ASE Sybase 15.7
I am new to ASE Sybase 15.7 but do have some background in other RDBMS systems. So i assumed there would be an equivalent of CREATE OR REPLACE for Stored procedures in ASE Sybase 15.7.
But I dont seem to see any way to do this. Most people i have…
Agni Srinivasan
- 3
- 2
-1
votes
2 answers
How can I create native Sybase BCP file?
I have data in my program's memory, that I need to import into a database.
For performance reasons I would like to do it via Sybase BCP, specifically using native file format.
Challenge: I need to know what the native Sybase BCP file format is, and…
DVK
- 126,886
- 32
- 213
- 327
-1
votes
2 answers
How does SELECT TOP with ORDER BY into DERIVED TABLE work in Sybase ASE?
I was wondering how this query is executed:
I got the error message "An ORDER BYclause is not allowed in a derived table." same using TOP.
NOT WORK:
SELECT
count(*),
sum(a_metric_1),
a_fld_1
FROM
(
SELECT
sales AS…
John L. Santos
- 13
- 5
-4
votes
1 answer
sql query transpose dynamic column to row in sybase or without using any pivot function
My input for table
id value
1 23
1 22
1 24
2 55
2 44
my output should be
1 23|22|24
2 55|44
Please help in providing query which can run in sybase database.
vijay
- 1
- 1