Hello, I've been at this problem all morning. Below you can see select sql with included select in where statement. I have to use the max function...

sergei.sheinin@db.com

03-15-2007 02:15 AM
sergei.sheinin@db.com

Hi, I would like to know if there is a way to identify the specific record that has a lock on it. EG. If SPID 111 holds a lock on a row in a table,...

Disco Octopus

03-14-2007 06:52 PM
Disco Octopus

I notice in the Bloor report on the Sybase website (http:// www.sybase.com/detail?id=1039410) that Sybase is planning full grid computing support in...

chris_jack@msn.com

03-14-2007 04:55 PM
Rob Verschoor

Hi, I have a stored proc SP2, which returns some data as the result. Another stored proc SP1 needs to call SP2 inside it. How do I receive the...

arbitary

03-08-2007 03:53 AM
Galen Boyer

Greetings, How would I add sequence numbers to a set of numbers I am quierying from a table? For example: I have a set of random numbers 2, 8, 9,...

rawee327@gmail.com

03-07-2007 02:51 PM
rawee327@gmail.com

Hi! I work with Oracle and Sybase database. On Oracle I develop my program using bind variables, so all executed queries include bind...

silvia.fama@googlemail.com

03-06-2007 08:14 AM
SybaseNeal

Hi all! I got the error when running sp_addprimaryconn: Script lines: 1-2 -------------------------- Command <sp_addprimaryconn> failed - Could...

Aquila Deus

03-03-2007 12:40 AM
AqD

hello again How can I do a select in only one statement like below but including 6 tables? select * from sysobjects where type ='U' and name not...

tpreto7@sapo.pt

02-28-2007 09:12 AM
Carl Kayser

On Feb 26, 8:29 pm, Luc Van der Veurst <nom... (AT) nomail (DOT) com> wrote: Hi Luc, you are right, as suggested by you the query works on...

jignesh

02-28-2007 12:55 AM
jignesh

Hello I have Sybase 12.5.3 on Solaris 5.8 and I need a generic bcp out and then in for all tables, but I have 3 tables which have identity columns...

tpreto7@sapo.pt

02-27-2007 03:57 PM
ThanksButNo

Ok, I've read the instructions. Honest. I try (as per instructions), bcp database.dbo.table out tableFile -c -Usa -P -Jutf8 And the error message...

ThanksButNo

02-27-2007 03:30 PM
ThanksButNo

Hi friends, I am having following query from oracle. I want to use the same in sybase. insert into AGS_TEMP (TOTAL_KEY,tft_plate_id,strip_id ) ( ...

jignesh

02-26-2007 04:25 AM
jignesh

In a stored procedure, I have a simple SELECT by the primary key, followed by an INSERT or UPDATE (depending on the result of the SELECT query - if...

Milan

02-23-2007 10:05 AM
saragirl3s@hotmail.com

My simple java application can not connect the sybase database server over LAN. The client application is running on linux. The sybase database...

kapkara@

02-23-2007 08:54 AM
Keith

I have 2 tables and i have to map a decimal field in table A with a character field in table B such that only the numeric part of the character field...

Maya

02-23-2007 06:13 AM
PDreyer

I have a character field which may have alphabets, numerals or both. Is there any command to check if the first character or second character of that...

Maya

02-22-2007 11:26 PM
ThanksButNo

Hi, I'm doing some recovery testings. Can anyone show me the detail steps to recover master by using bcp after rebuiding master database? 1. I...

jally.li@gmail.com

02-22-2007 11:39 AM
jally.li@gmail.com

I inherited a collection of Sybase servers that are configured as follows. 64 bit AMD processors. (Something like 10 on each machine.) They run...

Wayne Happ

02-22-2007 10:05 AM
saragirl3s@hotmail.com

Hi Friends, By mistake I deleted some rows from one of the tables in my sybase database. Is there any way to rollback that particular operation ?...

Phoenix

02-22-2007 08:50 AM
Jürgen Bajdala

Hello I am writing a web front end for some tables. For some reason i can do select * from table where id=1 but i cant do where id='1' . Is there a...

joe

02-21-2007 01:04 PM
Michael Peppler

I was planning to install Sybase EX on a Linux host. Since the product is free, how does one get patches and updates after it is installed? Sybase's...

Jack

02-21-2007 01:01 PM
Michael Peppler

www.addict3d.org/news/50314/Paper:%20Database%20Benchmark DevLoop has just published afree paper benchmarking some popular database systems such as...

admin@neobasic.biz

02-21-2007 03:36 AM
admin@neobasic.biz

As a follow up to my previous question. Does anyone have any experience with sybmigrate? I found it perusing the Sybase site. I'm not sure how robust...

Wayne Happ

02-20-2007 12:21 PM
Jack

Hi everybody, looking for more info refering SCSYBTHETIC CURSOR to use ti in my store procedure. I checked in T-SQL Guide on sybase 12.5.x ...

adisabat@gmail.com

02-20-2007 09:42 AM
Keith

Dear Users Can anyone help me solving the follwoing problem We are trying to fetch data from sybase system through vb.net using DSN connection. we...

deepakgupta66@gmail.com

02-17-2007 06:58 PM
Azhar

I had a strange deadlock recently. I may be wrong, but it looks like an update query deadlocked with its own subquery??? My question is such a thing...

Jack

02-16-2007 01:39 PM
bret@sybase.com

I am going to attempt to install Oracle 10gR2 and Sybase 15 Express on a RH Linux 4 machine. I was wondering if anyone in the group has been able to...

Jack

02-14-2007 10:48 AM
Michael Peppler

Can anyone help with a SQL query to give me the following result set from 3 different tables (defined below)? Thanks. DESIRED RESULT SET from...

dbadude

02-14-2007 04:34 AM
seemanthiniv@gmail.com

I have a question about setting the fill factor when adding a constraint. When I issue the below command. I would think that the the fill...

Wayne Happ

02-13-2007 04:08 PM
Wayne Happ

Can anyone explain what might cause the following error message, what we should do about it, and how concerned we should be: Feb 12 05:05:06 otcpr1...

chris_jack@msn.com

02-12-2007 06:08 AM
chris_jack@msn.com

hi, I am planning to take up sybase certification(ASE 12.5 SQL developer associate) exam.Can any one tell me where can i get the sample question...

anu

02-12-2007 12:37 AM
anu

Hi guys, In sysmon output I/O busy is showing quiet high. Does it mean that disk read is quiet high and we should increase the "default" data cache...

surajkumar1@gmail.com

02-09-2007 05:50 AM
Mariano

Here's a problem I have at work and am trying to think of ways to make it better. I have a table with a two key clustered index. (id, date) where...

Wayne Happ

02-09-2007 05:22 AM
Mariano

Today I had a strong debate with my office collegues on which database is better Sybase/Oracle. I might me wrong this, but, I would really like to...

Subind

02-08-2007 10:21 AM
DA Morgan

Has anyone benchmarked the difference in performance between these 2 techniques of inserting data within a stored proc? Technique #1 select @col1 ...

rlind55@yahoo.com

02-06-2007 01:41 PM
max39

Is there a way to monitor Transaction Per Second in Sybase without using monProcessActivity as this is transient. Thanks, MarcM

Marc Melancon

02-06-2007 08:23 AM
Marc Melancon

Hi all, I've been trying to setup ASE express edition on a (Gentoo) Linux system with little joy. When running the command as user...

Stack

02-05-2007 03:30 PM
Phil Jackson

Hi, MSSQL server supoorts aitresource field in the form of dbid:fileid:pageid in the waitresource field in sysprocesses does sybase has the same...

Neo

02-05-2007 02:12 PM
Michael Peppler

All, this seems to be a weird situation. We have our databases in DEV, UAT and PROD as usual. When I run a particular procedure in DEV and UAT it...

Sashi

02-05-2007 12:14 PM
Sashi

Hi: I am using the Sybase OLEDB driver 12.5. I was running into problems accessing these datasources both with SQL Server Integration services and...

Kayda

02-03-2007 11:46 PM
Kayda

Is there a way in Sybase to select a column and return the result in a single row? What I am trying to do is to join one entry in a table to a...

Javier Godinez

02-01-2007 10:15 AM
bret@sybase.com

(SNIP) Previous code is for 12.5.3. For earlier versions you probably have to change "set @var = <value>" to "select @var = <value>".

Daoud

02-01-2007 06:32 AM
Carl Kayser

select * FROM O_MY_TEMP C, O_MY_TEMP2 D,PS_PO_HDR E WHERE C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.PO_ID = D.PO_ID AND C.LINE_NBR = D.LINE_NBR AND...

cbriel@gmail.com

01-30-2007 03:00 PM
cbriel@gmail.com

Hi, I'm writing some SQL queries where the problem can be well formed in terms of subqueries. However, I'd like to be able to refer to the table in...

Sashi

01-30-2007 10:57 AM
Sashi

Hello, I have written a Sybase ASE 12.x TSQL parser and object model in Java and I figured that it may be of interest to people on this group. The...

Trimbo

01-28-2007 09:45 AM
Trimbo

Hi, New to SQL. Got some questions about it. Suppose I have two tables. Each of them has a single column, named as c1. For table T1, I have: 1 1 1 3

DE

01-28-2007 02:17 AM
Jonathan Leffler

Is there an easy way to distinguish between sybase system databases (ie. master, tempdb, sybsystemprocs, sybsystemdb, model, sybsyntax) and...

cbriel@gmail.com

01-27-2007 07:36 AM
Carl Kayser

I have a table with cols A,B,C,D... If I run select A, B+D-C-E from my_table is it guaranteed to give me the results from each row? For example,...

Sashi

01-26-2007 12:41 PM
bret@sybase.com

One of the key components for a ASE client is that the address for the server in the interfaces/ini file is constant. Using DHCP by definition means...

Jack

01-26-2007 07:39 AM
barlowedward

I have three tables: orders, manufacturer and items. order table has item_id and order_value. (For example order 33 was worth 3000). item table has...

Sashi

01-25-2007 01:49 PM
Sashi