Doe anyone know how to locate Java classes stored in Sybase IQ? The
system procedure sp_helpjava only works in ASE.
Femi

I have (very) limited knowledge of Sybase.
I'm looking to find if there's a maximum number of databases that can
be run on SQLAnywhere 5.05.
I haven't a clue, and google for once seemed unable to answer.

Is there a 'maximum amount of text in a resultset' setting that can be
adjusted for sybase?
I have a large text field that I am trying to retrieve, manipulate and
update using Perl 5 on Solaris talking to ASE 12.0 on Solaris.  When I

Hi, I have a question about reverse engineering sprocs in PowerDesigner
(I already tried the PD newsgroup hosted by Sybase, but somehow my
posting didn't show up :-()
Here's my question - I inherited a bunch of sprocs and I reverse

can any user except "sa" call the sybase system procs for
password change?
Thanks,
Sunil

We've had auditing setup up on our ASE 12.5.0.3 ESD#3 production
servers for some time, but occasionally (maybe 3-4 times a year across
20 servers) we get a situation where the audit device fills up,
effectively stopping the server overnight.

I need to do the following tasks in sybase 12.0 and need your help
reg. the same.
1. command to change the password.
2. check to stop reusing of the last 4 passwords  during the password

At work we have some BCP format files for importing data into our
Sybase tables.
One of the lines in one of the format files looks like the following :
3       SYBCHAR 0       1       "\n"    0       trailing_spaces

Is there any tool that can take .sql files as input and output a
database diagram and vice-versa?

At the office the databases I work with are SYBASE databases.
I have a question about the datatype value of a column as displayed
by the "sp_help" stored procedure.
Given that the defintion of the "syscolumns" tables is :

is there support or equivalency for
INSERT INTO .... ON EXISTING UPDATE VALUES ...
in Sybase ASE.. ? I know its supported in ASA .. but can someone point
out the equivalent call in ASE... i'll be updating/inserting around

MySQL Syntax: (TRIM(LEADING '0' FROM SYMBOL)}.. is there any equivalent
function in Sybase ? e.g i want '0001' and '01' to be evaluated to the
same string..
<the string length is variable ...>

the Chained Mode was selected to be off during installation.. and the
db connection is made with AutoCommit = 1
when i swtiched from v1.04 to 1.05,now during transactions.. i come
across this error quite frequently...

Here is a query involving 3 tables with simple joins. The query fetches
data for 12 month period range. As seen in the query plan, indexes are
being used on each of the tables. Table CustomerForecastSourcing has
around 14 lakh records, table art has around 7 lakh records and table

I'm having ASE 11.5.2 on AIX. My network admin is planning to change
my server's IP address. Besides on the client, are there any changes
needed for my ASE setup?