| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Dear all,
in the CIS environ i run the command
connect to MYLOCALSERVER
and i got the error message:
Cannot open a connection to site...
Roberto Lammoglia
|
02-25-2005 01:53 AM
Roberto Lammoglia  | 2 | 164 |
| | | Hello,
is there a fast war for calculating the density of a
column/column group
Regards
Kurt
ktklin
|
02-24-2005 04:43 PM
Eric Miner | 2 | 220 |
 | | It's been over two years since I've worked with stored
procedures and I'm trying to see if it comes back to me.
IF I have an SP with several SELECT...
James
|
02-24-2005 12:38 AM
manoj | 3 | 122 |
| | | I tried looking around the Sybase website but could not find anything
(when the links worked that is....most didn't, sheesh).
Is the Developer's...
Bill Weissborn
|
02-23-2005 09:21 PM
Bill Weissborn | 0 | 125 |
| | | Made an earlier mistake to name the ASE server similar to the hostname.
Probably is, this ASE server is on a shared disk, and any of the two...
noone
|
02-23-2005 04:37 PM
tester | 2 | 158 |
| | | I am writing a script that would generate database and server related
information for some reporting purpose.
I want to know how do I get the...
dans
|
02-23-2005 01:56 PM
wkraatz@csc.com | 2 | 119 |
| | | I've just upgraded a bunch of servers from 12.5.0.3 to 12.5.3#1, and I
also upgraded the full text search to the 12.5.2 version that comes...
Michael Peppler
|
02-23-2005 12:57 PM
Michael Peppler | 0 | 135 |
| | | I have an existing 12.5.1 installation, which was upgraded from
12.5.0.3. I remember clearly that during the 12.5.0.3 installation,
during setup /...
tester
|
02-23-2005 02:11 AM
tester | 0 | 211 |
| | | I have a table with two primary key : field_1 and field_2
I have a third field which is "father_field_1"
I have the following recursive foreign key...
FD
|
02-22-2005 04:59 PM
Bret Halford | 1 | 130 |
| | | Sangeetha,
Two suggestions;
1. Perhaps an index is not being used. How often do you run "update
statistics" on the tables used by...
Andrew
|
02-22-2005 03:05 PM
Andrew | 0 | 169 |
| | | In or shop we have some processes that utilize or depend upon the table DDL
to record when a record was created.
This is achieved through the use of...
125_2_?
|
02-22-2005 01:48 PM
Bret Halford | 3 | 157 |
| | | Does Sybase have a "personal" version of ASE available? If they do, what is
it called and where can I find the download.
Thanks
Johan Burger
|
02-22-2005 04:50 AM
Johan Burger | 2 | 163 |
| | | Does anybody know how to connect to a Sybase 11.9.2 database using Delphi
2005? Apparently Delphi 2005 ships with connectivity to 12.5 only.
Johan Burger
|
02-22-2005 04:38 AM
Johan Burger | 2 | 132 |
| | | create proc procTest @myPar char(20) null
as
begin
declare @localPar varchar(22)
if @myPar in (null, '')
select @localPar = '%'
else
begin
XYZ
|
02-21-2005 06:07 PM
XYZ | 3 | 163 |
| | | Anyone who has experience of how to best implement full text searches in
ASE ?
Buy the full-text engine
Split the text to varchar(255) pieces with...
Henrik Glimberg
|
02-21-2005 04:28 AM
Henrik Glimberg | 0 | 129 |
| | | Once in a while a runaway query will fill tempdb. At that point, our
production systems come to a standstill and the only solution is to
reboot the...
Mark Maslow
|
02-20-2005 06:15 PM
Mark Anderson | 6 | 269 |
| | | Hi Jayvee,
Si Jesus Salvo ito, your classmate from BS CoE, now living in Australia.
Anyway, as someone has posted, earlier versions do not delete...
tester
|
02-20-2005 05:48 PM
tester | 0 | 181 |
| | | Information returned from a SQL select statement includes a space after
each field for readability I'm guessing. Is there a way to suppress
this...
Adontech
|
02-18-2005 02:17 PM
Adontech | 1 | 165 |
| | | can a 'group by' be used in an update query? (could not
find refernce in documentation - if you can point me to the
document that addresses this...
smonet
|
02-18-2005 01:48 PM
Eugene Korolkov | 1 | 172 |
| | | Dear all,
i need to join a result set of a my own stored procedure with others tables
(like a view).
It's possible to do ???
Example:
exec...
Roberto Lammoglia
|
02-18-2005 10:01 AM
Bret Halford | 6 | 215 |
| | | The distribution is redhat 9.0 .
Even after I try with 12.5.3 express edition, it gives the
same error after some minutes of operation.
One such...
faruk
|
02-18-2005 04:04 AM
faruk | 0 | 185 |
| | | After installed Job Scheduler, I cannot find Job Scheduler folder from
Sybase Central, why? How to show or activate this function?
Thanks.
DS
|
02-18-2005 01:25 AM
DS | 0 | 178 |
| | | I have a Open Client C program running on AIX - UNIX,
calling a program from mainframe and get a set of data
return but I got the following error...
Philip Kwok
|
02-17-2005 11:24 PM
Jason L. Froebe [Team Sybase] | 1 | 446 |
| | | Hi,
yes, I also have not seen EBF for ASE Windows NT 12.5.1 to upgrade to
12.5.2 or 12.5.3
if choose latest 12.5.2 EBF for example EBF 12393:...
Altair
|
02-17-2005 08:57 AM
Bret Halford | 1 | 217 |
| | | How do I update a datetime field
bonsu_charles
|
02-17-2005 08:48 AM
wkraatz | 2 | 258 |
| | | Hello,
there are a lot of abbreviations used, like:
EBF - Efficient Bug Fix;
but what do mean others?
ESD - ?
IR - ? (ex. EBF 12150: 12.5.3...
Altair
|
02-17-2005 08:33 AM
Bret Halford | 2 | 218 |
| | | On 3 Sep 2004 02:50:53 -0700,
in sybase.public.ase.general
Rob Verschoor <rob (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
i had the...
togi
|
02-17-2005 08:16 AM
togi | 0 | 223 |
| | | If I am in the Newsgroups sybase.public.ase.general, how do
I search any thing in this specific group ? It only has the
Worldwide Sites and the...
Lieu
|
02-17-2005 12:53 AM
Dmitri | 1 | 162 |
| | | Hi,
In order to reduce impact on a production system, we want to perform offline
DBCCs. If we are running ASE 12.5.3 on two different platforms, I...
Tim Mottershead
|
02-16-2005 11:07 PM
Bret Halford | 1 | 178 |
| | | I have a Open Client C program running on AIX - UNIX,
calling a program from mainframe and get a set of data
return but I got the following error...
Philip Kwok
|
02-16-2005 07:38 PM
Philip Kwok | 0 | 239 |
| | | I have a system where I want to archive old rows of data from the OLTP
database into another database on the same server. This will ensure dumps
and...
Frank_Hamersley
|
02-16-2005 06:57 PM
FlyBean | 4 | 183 |
| | | gene wrote:
Prior to ASE 12.5 this wasn't supported.
Will Banta
|
02-16-2005 04:44 PM
Bret Halford | 3 | 240 |
| | | How do I update a datefield
bonsu_charles
|
02-16-2005 02:32 PM
bonsu_charles | 0 | 212 |
| | | Hello, I am trying to run this simple statement:
create view v1
as
select col1, col2 from t1
union
select col1, col2 from t3
and get message:
Msg...
gene
|
02-16-2005 02:00 PM
gene | 0 | 239 |
| | | ALTER TABLE uses a minimally-logged SELECT INTO under the
covers, so it cannot be rolled back, so it is not allowed within a
transaction
regardless...
Bret Halford
|
02-16-2005 01:13 PM
Bret Halford | 0 | 274 |
| | | 12.5.3 ESD #1 is the latest, and is recomended.
See http://www.sybase.com/detail/1,6904,1034520,00.html
-bret
Albert, Au wrote:
Bret Halford
|
02-16-2005 09:44 AM
Carlos Orozco | 1 | 272 |
| | | Hi,
First of all,I consider myself a newbie in ASE 12.5 so forgive me for
my lack of knowledge in this product. I encountered some problem with
my...
TheanKeong
|
02-16-2005 03:23 AM
TheanKeong | 0 | 271 |
