In my application I would like to load data into a staging table using Java. My tests show that PreparedStatement addBatch/executeBatch approach is...

Alexander Miroshnikov

11-14-2004 04:15 PM
Alexander Miroshnikov

Short of not using identity columns, can the gaps be eliminated? Even when a perfectly good backup is restored it creates identity gaps. I wouldn't...

Thomas Gagne

11-13-2004 11:05 AM
Thomas Gagne

Greetings, I have a couple of the questions. The latest version of ASE 12.5... which one could run on AIX 5.2, since on sybase's site matrix -...

SamVittorio

11-12-2004 08:46 PM
SamVittorio

Need help! I've been having trouble connecting to a Sybase database. Here's the error. Note the empty connection string. DBG_21438 Reader: Source is...

Seven

11-12-2004 07:11 PM
Seven

I got the following error messages from BACKUP Server, Jul 10 09:45:19 2004: Open Server Error: 16144.10.0: Server process '11' is not allocated in...

Peter Yu

11-11-2004 02:32 AM
mohammed78

Is there a way to pinpoint which SQL statement(s) or store procedure transaction(s) are running slow when DB is in poop performance?

Willy Jair

11-10-2004 08:11 PM
SybaseNeal

Solaris 9 Syabase 12.0.5 We have several different servers all basically running the same software and hardware running the same code against them.....

Mike

11-10-2004 05:05 PM
Mike

We normally create a db login that is the database owner that allows users to dump the transaction logs themselves. This login is distinct from...

Thomas Richards

11-10-2004 06:14 AM
Thomas Richards

Hi, Could anyone advise what is the meaning of -M option in ASE RUN_ file. Where can i found more detail information about the RUN_ file...

jerke szabo

11-10-2004 05:26 AM
Michael Peppler

Hi, I am trying to create an ASE 12.5 server under windows NT. My IP address isn't static. How can I use and define a named pipe? I use the...

Nic

11-09-2004 04:52 PM
Nic

I have ASE12.5. I just restored from dump a database (after creating the new database without "for load"). I need to change it's ID. How can I do...

Rob L

11-08-2004 05:26 AM
John Gardner

Hi, I read the following in the manual : Loading a database from a previous dump causes any triggers defined in the database to fire, which can...

ashish

11-06-2004 08:04 AM
Bret Halford

I have this Sybase database server on Solaris 5.8 Sybase 12.0, recently I have bcp out a table, drop the table in question, created and bcp in the...

Teresa

11-05-2004 03:27 PM
Chandan

what is the best practice for sizing and useing default data cache? when I really need named data cache? what size and config is work best in a mid...

David McGeorge

11-05-2004 09:30 AM
David McGeorge

I am trying to make an ODBC connection to a Sybase 11 adaptive server on a Windows XP machine. I am using the Sybase System 11 ODBC driver. My...

Steve

11-04-2004 03:10 PM
SybaseNeal

I have a machine that is running a sybase database. Other than the database name, port number, user and password, I don't know much more about this...

JustSomeGuy

11-04-2004 03:04 PM
Roy Stewart

Hello, After reinstalling Sybase ASE 12.5 on Mandrake 9.1, I can now login to the database. I can use isql just fine: % isql -Usa...

php newbie

11-04-2004 12:38 PM
Byrocat

Hi, I'm a student of Gdansk University of Technology. Now I'm getting prepare to write my M.A. thesis. The topic of my work is "An interface...

Dariusz Dzingielewski

11-04-2004 11:47 AM
Dariusz Dzingielewski

I am gettin error when I am trying to configure PHP # ./configure --with--apache=../apache_1.3.33 --with-sybase-ct=/opt/sybase checking for...

Pavel

11-03-2004 12:42 PM
Pavel

I would like to convert from an ASA 7.0.4 database (very simple 8 tables) to the ASE linux express. I current have the users connecting by ODBC with...

LHradowy

11-03-2004 10:10 AM
Pavel

I am getting ready to do the third edition of SQL FOR SMARTIES this month. If anyone has an SQL programming technique, trick or tip that they would...

--CELKO--

11-02-2004 01:23 PM
--CELKO--

Hi everybody I use sysmon to do tuning on sybase 12.5. Since I have a lot of reports saying me "Tuning your subsystem network i/0" What's means ? If...

Antonio73

11-02-2004 11:35 AM
Antonio73

I work with several databases from 5 to 20 GB. When I run the command sp_heldb <database name> I can see that the database is spread among multiple...

Simon

11-01-2004 10:11 AM
Larry Coon

Do you guys shutdown & restart ASE server periodically? Is there any document or statistics mentioning about periodically restarting ASE server for...

Peter Yu

10-29-2004 12:57 PM
Byrocat

Hi everybody I need some comand to debug several store procedure in sybase 12.5 and some examples how to use it ! could somebody help me please ...

Antonio73

10-29-2004 11:19 AM
Michael Peppler

Hi! Sybase 12.5.1 for Solaris. I am trying to create a table with 40 fields, some are int and some are varchar. But I'm getting this error...

Kjell Pettersen

10-29-2004 01:44 AM
Michael Peppler

I'm trying to dynamically allocate memory (on the heap) to store data I retrieve from a Sybase database. Now I have code that uses stack memory...

Karl Stahl

10-28-2004 07:08 PM
Karl Stahl

hi everybody, I'm developing a vb application ; Me (at client side): Win XP and Office XP database : sybase 11.9.2 on win 2k server ...

hazly

10-28-2004 08:21 AM
SybaseNeal

I have a Sun Java Station W1100 running Solaris 9.0 and Java Desktop. j2sdk1.4. The install shield program says "searching for java virtual machine"...

Wayne Happ

10-28-2004 03:46 AM
Michael Peppler

Hi all, I'm new to Sybase, I have a simple question, my current database owner is 'sa', are there any adverse affect on the database, on...

Vance Wu

10-27-2004 05:17 PM
Vance Wu

Which distros does it run on? This is for DW application hence the need for large memory access ( NUMA preferable )

ramesh

10-27-2004 02:59 PM
ramesh

Is there a short-cut to update statistics of all tables because my databases contain a lot of tables.

hazly

10-27-2004 06:39 AM
Rob Verschoor

I am looking for someone for a long term contract in Wisconsin. Perhaps someone can help me out? This is an integration from AS400 to SQL Server. I...

awittman@teksystems.com

10-26-2004 05:17 PM
awittman@teksystems.com

We have backup file from our customer that their Sybase is installed on Unix. We have Sybase installed on Windows, can we install from their Sybase...

Rao

10-26-2004 12:34 PM
Michael Peppler

has anyone some howto/doc on good default security for sybase ase ? (setup is unix, mostly linux) for example setting user with access on only some...

julien Touche

10-26-2004 06:09 AM
Carl Kayser

Hi all I'd be grateful if you help me with the following problem: I'm trying to install ASE 12.5.1 on Linux (the free version). I downloaded the...

berdzi

10-24-2004 12:38 PM
Michael Peppler

Hi, We are useing DCA between Sybase ASE 12.5.0.3 and DB2 on Mainframe/OS390. I got errors trying to define a DATE field in the DB2 db to my...

POW

10-24-2004 04:25 AM
POW

Please explain - 1>use master 2>go 1> select db_name(0) 2> go ------------------------------ master

Parag

10-22-2004 06:20 AM
Carl Kayser

Hello all, I have read somewhere that from ASE 12.0 onwards the way ASE locks tempdb system tables when a 'select into' operation is performed has...

geoffrey scholtes

10-21-2004 01:48 PM
Michael Peppler

Hi I am trying to get the output of a stored procedure to a table (using SQL in ASE 12.5). I have seen some posts that say you can do this using...

Dave

10-21-2004 10:19 AM
Dave

Hi, By default, the ASE listens at one address (ip, port). Is it possible to have the ASE listen to multiple addresses? Thanks, Ashish

Ashish

10-21-2004 12:39 AM
Michael Peppler

Could anyone know how can I check which stored procedure is running? Peter

Peter Yu

10-20-2004 10:55 AM
Sara Law

Hi, list! I've a question that not has response on ng faq's: Has Sybase something like interbase generator's or oracle sequence's? In interbase, when...

Alberto Salvati

10-20-2004 08:43 AM
Rob Verschoor

I have been working with RIBO to capture SQL and store procedure text. For the most part it's working, but it is way too verbose. I really want...

Brian Dick

10-20-2004 12:37 AM
Michael Peppler

My client a major Investment Bank is seeking 4x Sybase DBA to take part in a large scale migration project which will last for two years plus. The...

Danieloakes@pentaconsulting.com

10-19-2004 11:48 AM
Danieloakes@pentaconsulting.com

Hi All, I have a application running on Pocket PC. we are using Sybase as a Database. I have an index in most of the tables, but application is very...

Balasubramani

10-19-2004 05:00 AM
Balasubramani

Archive-name: databases/sybase-faq/part19 URL: http://www.isug.com/Sybase_FAQ Version: 1.7 Maintainer: David Owen Last-modified:...

David Owen

10-17-2004 11:20 PM
David Owen

Archive-name: databases/sybase-faq/part12 URL: http://www.isug.com/Sybase_FAQ Version: 1.7 Maintainer: David Owen Last-modified:...

David Owen

10-17-2004 11:19 PM
David Owen

Is there any way to find out the last time a procedure was executed. I would like to query a database and clean up any old procedures that haven't...

Susan

10-16-2004 07:06 AM
Carl Kayser

I have a datetime field. When I bcp out of it, I get data like this: Mar 4 1973 HH:MM:SS:MSSAM Where "MSS" is milliseconds. I'm trying to read...

Rembrandt Q Einstein

10-15-2004 01:10 PM
Sara Law