dbTalk Databases Forums  

Sponsored Links


comp.databases.sybase comp.databases.sybase


Discuss in the comp.databases.sybase forum.



Post New Thread
Threads in Forum : comp.databases.sybase Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
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 Go to last post
0 80
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 Go to last post
1 89
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 Go to last post
1 88
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 Go to last post
2 119
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 Go to last post
1 116
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 Go to last post
2 92
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 Go to last post
1 77
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 Go to last post
0 73
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 Go to last post
1 100
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 Go to last post
0 118
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 Go to last post
7 417
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 Go to last post
3 549
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 Go to last post
5 136
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-- Go to last post
2 143
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 Go to last post
0 104
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 Go to last post
0 97
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 Go to last post
0 103
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 Go to last post
2 89
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 Go to last post
3 105
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 Go to last post
1 88
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 Go to last post
4 97
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 Go to last post
1 86
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 Go to last post
4 100
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 Go to last post
0 82
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 Go to last post
2 96
Does the new Sybase versions support these ? Thanks
Pavels Samcenko
11-12-2003 10:34 PM
Ram DSL Go to last post
1 88
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 Go to last post
2 132
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 Go to last post
1 81
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 Go to last post
1 96
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 Go to last post
1 86
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 Go to last post
0 108
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 Go to last post
3 98
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 Go to last post
1 79
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 Go to last post
0 78
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 Go to last post
0 90
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 Go to last post
0 113
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 Go to last post
1 96
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 Go to last post
2 173
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 Go to last post
0 90
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 Go to last post
2 97
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 Go to last post
0 73
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 Go to last post
1 115
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 Go to last post
0 133
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 Go to last post
0 125
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 Go to last post
4 93
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 Go to last post
0 89
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 Go to last post
0 87
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. Go to last post
0 99
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 Go to last post
1 94
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 Go to last post
5 97
Post New Thread

Display Options
Showing threads 2501 to 2550 of 2967
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.