Dear all, I find I only add one OLEDB connection in Sybase central (to databases in AIX)? How can I add more than one connections? Regards, Peter

Hong Kong Is A Good Place

11-25-2003 08:57 PM
Hong Kong Is A Good Place

Hi all, I'm trying to set a database to read only, but I only know how connect to a specific database use the database file. How do I connect to...

wq

11-25-2003 08:02 PM
Klint Gore

Hello... We have a script to migrate an ASE database from one (internal) version to another. That script is really only actually a composite of...

bonzo

11-25-2003 06:33 PM
Bret Halford

create table #t (a real not null, b real not null) go insert into #t (a, b) values (1, 10000.1) insert into #t (a, b) values (1, 1000.1) go select...

Ed Avis

11-25-2003 04:05 PM
Bret Halford

Looking for free (open source?) jdbc drivers for a client on a windows machine to talk to a sybase db on a solaris machine. Any ideas? Thanks :)

ralph

11-25-2003 03:55 PM
Joe Weinstein

Hello everyone! I need an advice on a very simple task. I am looking to create exact copy of the existing Sybase database (all underlying structure,...

Dmitry

11-25-2003 10:00 AM
Dmitry

Hi, I need your help. I wrote following query: select NODE, PORT, MTIME, VALUE_A, VALUE_B, VALUE_C from TABLE where (NODE, PORT) in ...

michael

11-24-2003 02:02 PM
j_martinez

Hello folks, I've defined a resource limit in Sybase 11.9.2. I'd like to log anywhere the problematic queries (their text). Does anybody know how...

j_martinez

11-24-2003 12:54 PM
j_martinez

Hi, We're running Sybase 11.9.2 and recently increased our User Log Cache (ULC) to 16384 from 2048. Sysmon was showing that well over 20% of...

Chad

11-24-2003 12:02 PM
Ulrike Zintz

Hi all, I have an application on sybase. It sometimes gives me an error when I insert a record into database. The some insert SQL happens this error...

ppc_developer

11-21-2003 04:57 PM
ppc_developer

Folks, I need your help. I have a presentation to do about databases, which is a bit dry. I would appreciate any database oriented...

Tom

11-21-2003 04:53 PM
D. Joseph Creighton

Hi there Is there a way of creating a table in sybase like in oracle CTAS e.g. Create table MYTABLE tablespace MYSPACE as select *...

Maria

11-21-2003 03:13 PM
Subhas

Hello guys, I need some help. I need to check the parameters in Sybase database. Are they as recommended. How can I check this? If I need to change...

jo

11-21-2003 08:09 AM
Pablo Sanchez

My DBA has advised me that it is better to use the EXISTS statement than the IN statement. He says that it uses less server resources or is better...

Saul Margolis

11-20-2003 09:33 PM
--CELKO--

we have a table with a field of tpye binary(16) we unload this database, then try to rebuild from the script. the text files contains the correct...

Krisztian Pinter

11-20-2003 07:49 AM
Krisztian Pinter

Sybase 11.5.1, AIX 4.33 I am implementing an nightly batch job to kill user connections by database. I plan to use a shell script that firstly...

Thomas Richards

11-18-2003 10:23 AM
Thomas Richards

On Mon, 17 Nov 2003 03:46:10 +0100, Steve wrote: About 300 MB... Michael -- Michael Peppler Data Migrations,...

Michael Peppler

11-17-2003 11:12 AM
Michael Peppler

The following SQL runs on SQLServer: select col1, sum( col2 ) from ( select col1, col2 from table1 union all select col1, col2 from table2 ) as...

Andy K

11-16-2003 07:52 AM
Rene van Leeuwen

Hello, I am really new to Sybase I have the following problem: Dependent foreign key constraint violation in a referential integrity constraint....

Manuel Blechschmidt

11-16-2003 07:12 AM
Manuel Blechschmidt

Microsoft have added some new system procedures and functions since their divorce. Pete. You don't pay to get spam, why pay to clean it?

Petarian

11-15-2003 04:03 PM
Brian Ceccarelli

Are things like 'create proc' commands logged to the transaction log? What about things like DDL 'create table' and 'create index'? I have looked...

Chris Jack

11-15-2003 09:34 AM
Ed Avis

Hi. What's the DBMS configuration variable that toggles whether an arith-overflow is given a fatal or non-fatal level? I have a jdbc app that does a...

Joe Weinstein

11-14-2003 03:23 PM
Joe Weinstein

Hi, I've been looking at the documentation, but thougth I'd ask you to maybe save time. Say I have a temp table with the following columns create...

Amy

11-14-2003 10:21 AM
Navaneet Chola

At the present we are thinking of migration from Win workstation to Linux (RH9 or SuSe). We are running a kind of ERP system, which...

Sergei Kornilov

11-13-2003 02:20 AM
Sergei Kornilov

Hi, Does anybody have an idea how to cut off the decimals of a money variable, but to keep the thousand separator? e.g. change 12,345.00 into...

lhusmann

11-12-2003 11:56 PM
Andrew Kraftsow

Does the new Sybase versions support these ? Thanks

Pavels Samcenko

11-12-2003 10:34 PM
Ram DSL

Hi, I'm bcp'ing in a large volume of data with this command : bcp database..BcpTable in datafile -Uusername -Ppasswd -SSERVER -c -t\\t -r\\n -e...

Olufemi Anthony

11-12-2003 06:07 PM
Olufemi Anthony

Hi folks, I have seen something unusual. I am posting two queries with basically different approach to the same thing. One is fast and the other...

Subhas

11-12-2003 02:42 PM
Mariano Corral

Need some insight and help from the gurus. To set the knowledge foundation - I know nothing about stored procedures, blobs, and sybase. I have a...

Frank

11-12-2003 11:25 AM
Michael Peppler

My code declares a HOST variable this way: #define NAME_LEN 80 .... EXEC SQL BEGIN DECLARE SECTION; char sqlName; .... EXEC SQL END DECLARE SECTION;

Gabriel

11-12-2003 10:41 AM
Neal

Hi, During heavy load times I get the following contention (on ASE 12.5.0.3): sp_object_stats "00:10:00" Object Name: db..test (dbid=4,...

Ulrike Zintz

11-12-2003 09:51 AM
Ulrike Zintz

Hi all I have Sybase 12.5 and JConnect 4.5 I have a table with a varchar column. When I insert data of more than 255 bytes with the JConnect4.5's...

Simon Bieri

11-11-2003 03:00 PM
Michael Peppler

Hi, I am a newbie in databases, Sybase, ODBC, and al. I need to install a (Windows) software which makes use of ODBC to connect a sybase database. I...

SerGioGio

11-11-2003 12:53 PM
Paul

I have a stored prcoedure that checks for connections with a very old lastreqtime and then disconnects them. I wanted to add a bit more intelligence...

Lou

11-11-2003 09:09 AM
Lou

dave-au <dave-au_member (AT) newsguy (DOT) com> wrote: Hi! Excitement! Wow! You got one of the really cool bat systems? I want one! -am ©...

Anthony Mandic

11-09-2003 05:38 PM
Anthony Mandic

I have seen that before. Do you have clients connecting throught old MS SQL Server 6 or 7 tools? That could be one reason for it. -Karl "Naran...

Karl Ritter

11-08-2003 06:37 AM
Karl Ritter

I am using ASA 7 and have been advised to use COMMIT when using SELECT statements in order to prevent locks being left on tables. I have never...

Yahoo Sirius

11-07-2003 12:51 PM
Joe Weinstein

Hi All, I need help in writing a query to get the first row of the following query result. 1> select db_name, smiNumber,xyz =...

ars

11-07-2003 08:43 AM
ars

In terms of the Sybase Performance and Tuning Guide the following may occur: "When engine utilization is extremely high, the housekeeper...

Saul Margolis

11-06-2003 03:24 PM
Saul Margolis

Hi all I have Sybase 12.5 with jConnect4.5. I have a table with a varchar column. When I insert data of more than 255 bytes with the JConnect4.5's...

Simon Bieri

11-06-2003 10:32 AM
Michael Peppler

Hi guys, I have a client with an ASA 7 database that I need to import into an ASE 12.5 development server. Can anyone give me an idea as to the...

Ryan

11-05-2003 09:40 PM
Ryan

When I try to dump with compression and the file parameter I get the following error: 1> dump database STAT to...

bebe

11-05-2003 05:04 PM
Bret Halford

Hi all When i try to launch a bcp (valid or not bcp command line) i' ve got this : $ bcp

flavabre

11-05-2003 09:58 AM
flavabre

Hi, I'm having problem with formating date field to format DD.MM.YYYY. I have set date_format to DD.MM.YYYY and date_order to DMY. I have done this...

Jelen Bostjan

11-05-2003 07:54 AM
Jelen Bostjan

Hi I want a query which will return first n records from a table in Sybase. I do not want to use the SET Rowcount option. Can anybody suggest me...

Abhi

11-05-2003 07:47 AM
Rob Verschoor

I got the same error message: "Incorrect syntax near the keyword 'TEMPORARY'." when I ran command "ssxtract.exe" from window environment. That...

Hoang C

11-04-2003 11:57 AM
Hoang C

Hi Folks I saw this error in my sybase error log: "No valid licence for ASE..." Having traced it down I discovered that I had not started the...

Masroor Kazmi

11-04-2003 05:55 AM
Masroor Kazmi

Email to: dnautiyal AT objectgain.com Req. ID: OGI00133 (Sybase DBA) Rate: $50/hr Location: Houston, TX Job Type: Contract, Total Exp: 6...

ObjectGain, Inc.

11-03-2003 09:18 PM
ObjectGain, Inc.

Is there any way a can 'escape' characters ? I need to hide a '-sign but I dont know how . Im using jdbc/CallableStatement and inserting a lot using...

Magnus

11-03-2003 10:34 AM
Michael Peppler

HI All, I have got struck in a situation where 2 or more processes appear simultaneously read the data from a table and each one of them insert a new...

Zia

11-03-2003 09:43 AM
Willie Kraatz