Hello All, Does sybase has any exception handling feature like its availabe in Oracle to catch any error during execution of SQL. Please let...

Subind

12-11-2006 11:32 PM
Subind

....as always with full support for Sybase and other DBs. Altova is pleased to announce the availability of Version 2007 of its XML product line....

announce@altova.com

12-11-2006 09:40 AM
announce@altova.com

Hello, Is it possible to create a datatype in Sybase which can hold multiple basic data types. I need to do that in PL/SQL and not thru an...

Santoshkumar

12-10-2006 10:28 AM
David Kerber

Hi All, Anyone know how to list all the databases available on a sybase server? I know about sp_helpdb which lists all the database names, but I'am...

Subind

12-08-2006 04:20 PM
darkknight56

Hi All, I've a table which has a column of Text type. In my stored procedure i've to retrieve the value of this column based on some criteria and...

sumeshabraham

12-07-2006 10:58 AM
bret@sybase.com

Hi, I'm doing some Sybase tuning (ASE 12.5.3) and I'm getting a strange error when I run sp_poolconfig to configure 4K pools. The error is: 1>...

snoop75

12-07-2006 01:44 AM
snoop75

Hi All, I am new to the sybase database, I need to know what is the command equvivalent to "SPOOL" command of oracle for the SYBASE.I am using the...

yarlly

12-06-2006 03:03 PM
David Kerber

I'm trying to mess around with an application that performs this query: SELECT count(1) FROM master ..sysprocesses What is "master ..sysprocesses"?...

yawnmoth

12-06-2006 08:29 AM
Aalam

Hi, I'm using Sybase ASE 11 and iSQL Viewer. How can i find out the processes(quries/stored procedures.. etc) running currently on the...

sumeshabraham

12-06-2006 04:53 AM
Subind

Hi, Does Sybase have exception handling functionalities? Regards,

Subind

12-06-2006 04:42 AM
Subind

hi, I need to retrieve data from a table from MS SQL database and then populate sybase database tables from the same. The procedure i thought of is:...

rohan

12-06-2006 01:10 AM
rohan

Does anyone have any experience they would like to share regarding porting a C++ application written against Versant to a Sybase ASE back end? Are...

chris_jack@msn.com

12-05-2006 08:06 AM
chris_jack@msn.com

Hello, What is the function to test if a blob field is empty or not in ASE 12.5 Regards

ploc77

12-01-2006 12:57 PM
bret@sybase.com

Hello Is there a way of bcp out and then in all tables in sybase? if so can someone please help? I just dont want to hard code every single table in...

tpreto7@sapo.pt

11-30-2006 03:15 AM
mail2Shabeer@gmail.com

I have one query inside a procedure when running parallel with some other procedure is not moving , and I/O movement is very less or zero. Could u...

minaj

11-28-2006 10:13 PM
minaj

Dear comp.databases.sybase: (Announce): Who: Jonathan Robie is the XQuery Technology Lead at DataDirect Technologies, which specializes in data...

Stylus Studio

11-28-2006 03:18 PM
Stylus Studio

I am starting to tune the Metadata cache, but I am having trouble in identifying one particular data structure: dbinfo. I am able to identify and...

Jack

11-22-2006 03:01 PM
bret@sybase.com

If I change, on table, data_type char size from 25 to size 45 In PowerBuilder10 I must make, by mouse, the same change to all data_windows to...

a4

11-22-2006 08:28 AM
a4

Hello All, I am new to Sybase and I am using the Sybase API's to do a bulk copy. But the blk_init function keeps on failing for me. I am trying to...

santoshkumar.shukla@lehman.com

11-21-2006 12:32 PM
SybaseNeal

I have customers that want to use timestamps as part of a unique key, mainly to insure its uniqueness so I was wondering if there are any good...

darkknight56

11-20-2006 07:25 AM
David Kerber

I have a single table (tradeData) with 3 date fields (settle_date,mat_date,value_date), and I am trying to determine the largest date value within a...

ckmehta@gmail.com

11-17-2006 06:37 PM
bret@sybase.com

Hi, Can someone tell me whether the value for usertype for base datatypes like char, varchar,int, decimal etc. changes from one Sybase ASE release to...

Kartika

11-17-2006 01:54 AM
Kartika

Hi, I would like to announce the Beta release of Majoree. http://marjoree.rubyforge.org/ Marjoree is ruby library that eases the pain of unit...

jiggypete@googlemail.com

11-16-2006 12:20 PM
jiggypete@googlemail.com

Hi, This might be a generic question, but when to use trigger and when to use stored procedures? Similarly when to use views and when to use stored...

Rose

11-15-2006 04:35 PM
Rose

Hi, This might be a generic question, but when to use trigger and when to use stored procedures? Similarly when to use views and when to use stored...

Rose

11-15-2006 04:26 PM
Rose

We have a stored procedure (developed by a third party) that runs a number of queries to pull out monthly reporting data. This procedure uses temp...

IanK

11-14-2006 09:33 AM
joeNOSPAM@BEA.com

I know in SQL Server i can created Indexed Views and was wondering if I can created them in Sybase. They will be used for Full-Text Searches.

teewebco

11-13-2006 11:08 AM
teewebco

Hello, I have some questions about Full Text Search and how to handle a scenario that I have. The database that I am going to hit up against has 80...

teewebco

11-09-2006 01:03 PM
teewebco

Hello, we're currently experiencing some exceptional behaviour with one of our production Sybase databases. The situation is as follows: Back...

Graeme

11-09-2006 11:09 AM
Graeme

Hello Does someone know how to get only user defined tables? I mean SYSTABLE contains all tables in database, so all system tables are there too....

panczo

11-09-2006 04:57 AM
Carl Kayser

Hi, I am trying to execute a query when starting isql. Some resources have mentioned about -Q option to execute a query. It worked with isql for SQL...

Karthik

11-08-2006 07:39 PM
Rose

Hi, I am doing a project on the database industry and would appreciate if you all could answer a few questions for me! · What do you think of...

d-licious

11-08-2006 05:41 PM
d-licious

Hello I have a sp where the last statement is a "select * from...." Now can I capture this resultset that is returned , into a table ? (without...

joejosephmul@gmail.com

11-07-2006 01:59 AM
species8472

Hi! In our Business Application we are using the jconnect driver for years. Now I read an...

Michael Postmann

11-06-2006 06:08 PM
Galen Boyer

Hi I'm trying to query off of Sybase tables using Embarcadero Rapid SQL and I am trying to figure out the code to use to get date formatted...

jmanzano3@gmail.com

10-31-2006 09:35 PM
othellomy@yahoo.com

Dear comp.databases.sybase, Stylus Studio, a provider of XML tools and components for advanced data integration, is inviting paid customers of...

Stylus Studio

10-31-2006 01:43 PM
Stylus Studio

Hiya, That's the best subject I could come up with.. here goes the question. Given Items: Table: AllocationList...

dufffman@gmail.com

10-30-2006 10:10 AM
dufffman@gmail.com

Hi, I am not able to find the answer to the following query. A table has three columns: Year, Quarter and Sales price. Each year has four quarters...

Rose

10-27-2006 03:55 PM
DBAGAL

Help, I have this error message "THE TRANSACTION LOG IN DATABASE XXX IS ALMOST FULL YOUR TRANSACTION IS BEING SUSPENDED UNTIL SPACE IS...

Chris

10-26-2006 09:40 PM
Chris

Is there a way to get JDBC Driver to throws SQLException in other language then english? If so what is the procedure. Thanks, MarcM

Marc Melancon

10-26-2006 01:35 PM
Marc Melancon

Hi, I have 3 tables x,y,z all identical and indexed. 1) I create a view of x union y union z 2) I create table A containing data from x,y,z and...

DC

10-26-2006 11:36 AM
David Kerber

I've heard that when Sybase does a reorg, it creates a copy of the table being worked on, loads this table via an insert..select statement, drops and...

darkknight56

10-25-2006 11:37 AM
bret@sybase.com

Hello, Under SunOS 5.1 and Sybase12.5, I try to run a simple C test program which loads dynamically the CT-LIB ..so (libcs & libct) But each time I...

stef.pellegrino@gmail.com

10-25-2006 09:57 AM
SybaseNeal

I have DBAs who have full rights to the database, and limited rights to the operating system. In SQL, this is easy enough to do. I am finding it...

jwgoerlich@gmail.com

10-24-2006 10:51 AM
jwgoerlich@gmail.com

Some of our application people want some of the system tables (such as sysprocedures) reorg'd. Is there any benefit to having this done? What are...

darkknight56

10-24-2006 10:03 AM
Carl Kayser

Hello! An identity gap is causing problems in one of my tables. And I also have several foreign keys on other tables pointing to that defective...

ArchonMk

10-23-2006 07:59 AM
--CELKO--

Hello, I get an error on a cursor fetching the result set of a stored procedure : "Cursor is not updatable: UNION is used in the query" on the...

patrick

10-22-2006 06:30 PM
Galen Boyer

I made ahuge loading script in SQL server 2000 which load data from many tables in one table and i want to test the loaded data against the original...

tamatem

10-22-2006 04:15 PM
tamatem

I made ahuge loading script in SQL server 2000 which load data from many tables in one table and i want to test the loaded data against the original...

tamatem

10-22-2006 04:14 PM
tamatem

I have the following 3 SQL statements that need to be combined, if possible. The output of one feeds the input of the next. I need to view all of the...

wgblackmon@yahoo.com

10-18-2006 11:50 PM
othellomy@yahoo.com