I have a Java program in WebLogic, the database is Sybase.
When the Java program run a stored procedure return the error:
com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' comma...
Where can I get an odbc driver for Sybase SQL Anywhere 5.5?
Help is appreciated.
I'm looking for a way to loop through records in a table and insert the values plus a number which value I have to look up into another table.
Can anyone help me with the sybase syntax for ...
Hi,
I am trying to insert 30000 rows in a table in Sybase ASE 12.5.3
I created a tables called as test(id int not null) and following is the code to insert 30000 rows
declare
@target_...
System is Fedora 11 x86_64 (Red Hat).
I am under the impression that I can connect to our Sybase Adaptive Server Anywhere because when I run:
tsql -S prospect -U DBA -P password
it retu...
what is the replacement of rownum in Sybase? for eg in finding nth min salary in a table emp.
or how to write the following query in Sybase?
select * from (
select emp.*, row_number() over(...
can someone please explain what the isql commands do exatly in this code:
SQLDATA="XXXXX"
SEP="|"
SQL=${SYBASE}/OCS-12_0/bin/isql
function getFolderId
{
${SQL} -w2000 -s${SEP} -n -S$...
HI,
I am looking for a tool that I can use to view data, table information etc.. from a sybase database, something similar to TOAD for Oracle.
Right now I am using isql to connect the sy...
Hello All,
I need some help regarding the implementation of outer cursor. My inner ursors work fine but when I use the outer coursor both cursors doesn't work.
thanks for all the help
...
On Sybase 12.5.0.3, I have a table with the following structure:
CREATE TABLE dbo.app_number
(
application_short_name char(15) NOT NULL,
number_id char(5) NOT NULL,...
My table has around 10 existing records and their identity column value is numbered sequentially like 1,2,3,..........10. But when I insert a new record into the table, the new identity value ...
Hi all,
I have a problem that tempdb sometimes is full during a transaction. When I look at the contents of the tempdb after the rollback I notice that there are a lot of 'ghost'tables in t...
Hello experts,
I am trying to BCP a .txt file data into Sybase database but getting the following error:
"Unexpected EOF encountered in BCP data-file"
I am doing this from MS-DOS prompt...
I used the following on a mysql database... which works.....
String strcust = (String)session.getAttribute("w");
however I get the following error from sybase
Implicit conversion ...
Hi there I have a data model where BIGINT is used as the data type
for timestamps instead of the regular timestamp value. The system
using the database is written in Java, so the BIGINT va...
God! I allocate not enough space for temp database, now it is full, I do not know the exact use of system procedure and so on, but I need to solve the problem soon. I need to know how to dum...
Hi guys,
i have a sql query problem.
i have a table which has got a column named event_date which has date time datatype.
what i want to do is get the event_date column and compare it ...
Hello experts,
I want to know the difference about what does this command means in sybase and when to use them?
1. Set chained OFF|ON
2. Execute <Storedprocedure>, "anymode" (When to put ...
Hello,
We have a Sybase application which heavily uses the transaction log. The database option is set to "trunc log on chkpt." Sometimes, during he heavy usage, the transaction log get com...
We are building a system which needs the information from two Sybase databases.
The DBA proposed the proxy table solution so that we only need to access one database and the tables from the...
I am using a Sybase database for the first time. What query should I use to show all tables? for other databases like Mysql I have been using "show tables" which has been working fine
I am starting to use ASA to create tables. I am used to creating tables in SQL Server and have attempted to delete a table if it exists and then recreate it. I am using the following code
i...
I am trying to run a query in Sybase 11 and have the following code:
create table #temp_prod(
tin char(10) NULL,
tin9 char(9) NULL,
a...
In Sybase 12, is there a (relatively) simple way of replacing any occurence of CHAR1 with CHAR2 in a field pulled by a select statement? CHAR1 can be absent or occur one or more times at rand...
I have a sybase server (adaptive server anywhere v6) at one location and i have a SQL Server 2005 with SSIS at another location. What is the best and most economical way to get at the sybase ...
