I've received a database file (.db) file from a customer and must view
the table structure for analysis.  I've installed SQL Anywhere 10 to
connect and view the objects but when I attempts to connect I receive
an error message indicating that the file was created with a different

Quick question about naming conventions in sybase.
Can you name a column starting with _
say for example Could you name a  column
_CREATED

DBMS is Sybase 11. Some users have inserted CR[/LF] in text fields,
which needs to be removed.
I'd like to use something like "where notes like '%[char(13)]%' " but
cannot find a construct that will work.

Hi forum members, I have problems with my ASE 12.5 , because it
doesn`t release all the scans descriptors after executing querys,
until the moment i dont have enought scans descriptors to run my
query,  the solution that I have found , is upgrate to ASE 12.5.4, but

I found out that in our application the first data rows of some data
files have been cut off when the data files are uploaded into sybase
(v 12.5 on solaris).
I use the -F 2 option to skip the header row.  However the 2nd row,

I have a query that does an "insert into... select from", both the
source and target table have multiple indexes, it is taking too long
to execute this query but when i've deleted the indexes on target
table, insert took very little time.

A customer has asked me how Sybase allocates ports for client connections to
Sybase SQL Server 11.0 on OpenVMS.  I know that the server listens on a
specific port for connection requests, in this case port 5010.  I can see
using 'netstat -a' on the client PC that both application ...

Hello Sybase Experts,
I need to know infomration regd Sybase server logs/metadata.
I have a sybase server and some unwanted activity has carried out on
this server by running a stored procedure.

Hello, I am having a problem with RPC calls from an ASE12.5.3 EBF
12461 ESD#2 server on Windows 2003 to 11.92 servers on NT.  Oddly, I
have four 12.5.3 servers, and only 1 of them is having problems.  The
sql.ini file if fine, all the remote servers and remote logins are set

So you think your database is secure!?
Think again.
Scuba by Imperva Database Vulnerability Scanner is a FREE, lightweight
Java utility that safely scans Oracle, DB2, MS-SQL, and Sybase

I want to check if the default exists and then create if it does not
exist
i've used the following in a query batch
if exists (select name from sysobjects where name='sample_dflt' and

SELECT * FROM location_stock LEFT JOIN stock USING (stock_num)
Why, when I run that, do I get this error back?:
Sybase: Server message: Incorrect syntax near the keyword 'USING'.
(severity 15, procedure N/A)

I'm trying to perform a two-table SELECT where each table has a column
named 'stock_num'.  One of the tables, however, isn't necessarily
going to have row's for a given stock_num (it might or might not).  To
get around this, I do a LEFT JOIN.  Or atleast I'm trying to do one.

Give me, please, a links to the most popular real-world client apps
for ASE server? Not a SQL Advantage and isql please
Thanks,
Vlad

what are the top 10 sybase ase admin and sybase rep server commands
you use every day?