Hi All, Can someone tell me ways of determining whether a table is marked for replication?

Raj

12-25-2003 09:06 AM
Karl Ritter

I have created a segment and exclusively allocated for a database 'test' . After that i created few objects on the segment. Now if iam trying to drop...

Lalit

12-24-2003 12:33 AM
Stefan Karlsson

Greetings experts, I have an sql search that requires 'OR' search on two different _fields_ eg. (Sun -- Sybase databases) select f1, f2, ...,...

Rostislav Lyudmirsky

12-22-2003 05:12 PM
Pablo Sanchez

we have a need to connect to the /400 from our pb applicatin for a client. i've ran into many issues already. we're overcoming some of them for...

Woody Rao

12-22-2003 11:28 AM
Woody Rao

Hi, Is it possible to change case sensitive attribute for Sybase database ? Thanks, Laurent

Laurent RUHLMANN

12-22-2003 11:23 AM
Larry Coon

Does anyone know whether ASE 12.5 allows one to use the union operator in a view and if not, how to get around this limiation? Femi Anthony

Olufemi Anthony

12-19-2003 09:26 AM
Zia

Hi, I use "dbisqlc" in shell script to get the tables from a database. In the look up it shows the table name as "master.testDB etc". I want to...

spanda

12-18-2003 07:41 AM
spanda

Now you it is possible to use new tool - IEnterprise Application, for fast creation Windows application working with Sybase SQL. The basic...

radiy

12-18-2003 04:25 AM
radiy

Hi, I am trying to install Sybase ASE 12.5 on RedHat Linux 7.2 but everytime I start the 'asecfg' and configure the master device paths and click on...

Dermot

12-17-2003 11:11 AM
Michael Peppler

We're currently experiencing deadlocks with a production application. With the volume of transactions that we get, this behavior is not completely...

Evan Smith

12-17-2003 09:10 AM
Evan Smith

Hi, Is there any rumors about whether Sybase Inc. is going to develop a Requirements Management (RM) tool that will be integrated with...

Alex Petrov

12-16-2003 06:59 PM
Alex Petrov

I can execute a stored procedure and get some rows as results. For example sp_spaceused returns one row with six columns, and then a row with one...

Ed Avis

12-16-2003 01:22 PM
Michael Peppler

I am using the jConnect5.5 JDBC driver and I have run into an issue with quoted identifiers. It seems that quoted identifiers are turned on and I...

Ci-Ci Mills

12-16-2003 11:34 AM
Ci-Ci Mills

I am not a Sybase admin, but I have recently taken over responsibility for an old Sybase database running on: Adaptive Server...

Tom Brehony

12-16-2003 08:52 AM
Luc Van der Veurst

I am trying to do something like this CREATE PROC <mainProc> CREATE TABLE #tmp(...) subProcA subProcB <other code as needed> go

Shahzad Zafar

12-15-2003 08:46 PM
Larry Coon

I have an output file from another product which has a variable number of columns, followed by the row-terminator. The first four columns are always...

Anita Craig

12-15-2003 05:15 PM
Michael Peppler

Suppose that you have a stored procedure that performs several separate select statements. Is there any way to create a stored procedure that...

Asherian

12-13-2003 05:10 PM
Asherian

I have recently taken over responsibility for a Sybase database that has been in use for over 6 years. I am not a trainined Db admin, although I do...

Tom Brehony

12-12-2003 04:04 PM
Bret Halford

Hi, Where can I read something about "Statistics" in Sybase ASE and ASA? Is there any additional options? -> How may I specify my amount of data...

pater

12-12-2003 10:21 AM
pater

I got a permission denied on selecting data into #temp table. If I select the data out and not putting in a #temp table, I do not have the problem...

Amy

12-12-2003 10:15 AM
Amy

After much pain I have found a way to view the SQL being executed on Sybase Anywhere with all sp's removed. If anybody is interested. Within Sybase...

Thomas Tonneson

12-11-2003 10:22 AM
Thomas Tonneson

Hi Friends, Please help me out to get the procedure which gives me the name of all databases created on any particular device. For eg sp__devdb...

Lalit

12-11-2003 10:02 AM
Carl Kayser

anyone having any information when sybase will release ..net compliant managed driver for ase ? any betas available for testing?

jai hanuman

12-11-2003 09:38 AM
Neal

hi, in sybase6 i've had a sql statement something like: select number(*) as num, num+1, num*5 from tblObject now in sybase8 it doesn't work becouse...

riki

12-11-2003 08:15 AM
riki

Hallo, we have performance problems with an esql/c program. The select via isql works fine and is fast but takes some minutes in the...

J. Bajdala

12-11-2003 03:33 AM
J. Bajdala

Hi, How do you convert from the 'timestamp' datatype to a varchar? I tried variations on convert(varchar(20), timestamp, 101) to no success. All...

Lance

12-10-2003 06:20 PM
Bret Halford

I have just migrated from Sybase 11, to 12. A piece of code (select date from OPQ where STR(v) like '%NaN') that use to work before, converting...

ade talabi

12-10-2003 03:05 PM
Bret Halford

Do I have to create a default or use a rule? Is there a convert function I can use...

ade talabi

12-10-2003 09:45 AM
ade talabi

Hi All I have downloaded sybase ASE for linux..can somebody tell me for how many days will it run without a liscensce..i am not using this...

hrishy

12-09-2003 05:35 AM
hrishy

Hi all Apologies for what appears to be a repeat of previous postings but I can't seem to get this to work. I have a date column containing a 29...

Gary Johnson

12-08-2003 03:18 PM
Patti

How'd they do that? wrote: Oops, my suggestion didn't. I missed reading that part. Change it to something like this: delete from cust_hist where...

Glen K

12-08-2003 12:53 PM
Larry Coon

How'd they do that? wrote: Depends on what they bought to serve what purposes. If you go to http://store.oracle.com and look up Oracle Standard...

Daniel Morgan

12-08-2003 02:27 AM
hrishy

Hi everyone, I'm having a problem with an IQ 12.5 stored procedure. I need to create dynamic sql statements to run against the db because my user...

Patti

12-06-2003 06:14 PM
Patti

Dear all, I am working on a project where the storage device can provide mirror of LUNs of sybase server. I would like to know how to enable a...

Paul

12-06-2003 08:18 AM
Alex Li

How many editions are available in ASE? Regards Johnnie

Norris

12-05-2003 02:33 PM
Larry Coon

Hi, I have a immediate need for a Sybase Developer with a Major Financial client, NYC. The Duration of this project is 6months. Pls send your...

rajasekhar@pinnacle-sys.com

12-04-2003 05:16 PM
rajasekhar@pinnacle-sys.com

BACKGROUND Our Java app runs in unchained mode against ASE 11.9.2 under Linux at all times. All SProcs are set using sp_procxmode to "anymode". Our...

bonzo

12-04-2003 03:30 PM
bonzo

Sybase documentation for Strored Procs indicates that global variable @@error should be checked as follows... "Every Transact-SQL statement,...

bonzo

12-04-2003 03:04 PM
bonzo

I'm trying to convert the following query to ANSI form and am stuck when it came to convert the subquery in WHERE clause. ( (subquery)...

Ibrahim DOGAN

12-04-2003 02:56 PM
Ibrahim DOGAN

Hello, I am running both these stored procs for the same database, and I am getting different values for the suggested text workspace size and the...

David Dalle

12-04-2003 12:07 PM
David Dalle

Hi, I have a scenario as below. There is a process A which is related to drop index on table1 There is a process B which is related to bcp on...

Pavani

12-04-2003 01:31 AM
Pavani

We currently have a problem accessing 2 Sybase databases on the same ASE (12.0) thru the use of ODBC in MS Access 2000. If we use the same DSN for...

Bart Lemmens

12-02-2003 04:01 PM
Bart Lemmens

"How'd they do that?" <rmcgorman_usenet (AT) n__o__s__p__a__m__spamex (DOT) com> wrote in message news:paKxb.516658$9l5.256570 (AT) pd7tw2no (DOT)...

Carl Kayser

12-02-2003 07:37 AM
Carl Kayser

"How'd they do that?" <rmcgorman_usenet (AT) n__o__s__p__a__m__spamex (DOT) com> wrote in message news:kK3yb.524996$9l5.394375 (AT) pd7tw2no (DOT)...

Martin

12-01-2003 05:06 PM
Martin

I have an ASE 12.0.0.6 server running on Solaris 2.7. 12.0 End-of-Life is announced as 12/31/2004, so I'm planning to upgrade to 12.5. The...

L. Bertolini

12-01-2003 03:04 PM
L. Bertolini

Hi, I have an odd situation : the dataserver is running but there is apparently no shared memory attached. /home/sybase Adaptive Server...

Laurent P.

12-01-2003 01:36 PM
Laurent P.

CIS was working fine until a few days ago. It stopped working even though I haven't made any changes to the server. sp_configure "enable cis"...

Glen K

12-01-2003 11:14 AM
Glen K

I just downloaded the sybase ASE database for Mac OS X. During the installation, everything seems to work ok. However, when I used the...

J

11-30-2003 10:30 PM
J

Hi all, does someone of you know how to find a special row in a table, not using a WHERE clause? To make it more clear: What do I have to enter if...

Alfred Zentek

11-28-2003 07:40 AM
Alfred Zentek

I am trying to restore the backup files of a Sybase database (11.9.2) on another 11.9.2 server. Same indications: The two databases have the same...

j_martinez

11-27-2003 12:21 PM
Laurent P.