I'm converting a database from MySQL => Sybase and i run into a
problem.
In one stored procedure, we're using Inet_NtoA function.
Is there a similar funktion in Sybase ??

I had a question that I was hoping someone on this group may be able
to help me with. I have an unpartitioned table A that I join with
unpartitioned table B in a query.  When I look at the query plan, its
doing a full table scan on A and hitting the index on B. Table B has

I found something strange when using derived tables.
Maybe this is a case for Sybase.
version:
Adaptive Server Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/

If a column does not already exist on a table I want to add it. The
column already exists in the database I am testing this in.
Here is my problem:
  IF NOT EXISTS(SELECT 1

Can one specify the initial table size and the incremental table size
for SYBASE ASE 11/12/15 when running the create table script?  If so,
please teach me.  Thanks a lot in advance!
Tom

I am trying to bcp in data into a table owned by dbo and I am not
dbo.  The bcp fails because I am not the table owner nor am I sa.  If
I bcp the data in as dbo, the bcp works just fine but I don't want to
use the dbo id to perform the bcp.  I need to do it as a regular

    I'am stuck with a tricky task in sybase. I would like to know is
there any way to find out that whether a table is being used in stored
procedure or not across multiple databases.
E.g. If table tab1 is being used in stored procedure sp1(in database

I am building a data pumpt in SQL Server 2005 SSIS that gets data from
different Sybase servers via different dialup connnections. I noticed
one connection started hanging and did a coninuous ping test (ping
ipaddress -t) with a server that was working and one that wasn't. On

Is there a Windows GUI manager avalible for Sybase like the one for MS SQL
Server?  (Sorry, that's my background.)  We are developing queries for a
Sybase DB we don't have direct experience with and somthing that would let
us easily see view definitions, table/column lists, ect.. ...

I have the message: "1 task(s) are sleeping waiting for space to become
available in the log segment for database xxxxDB..."
I'm running sybase 15.0 under CentOS (RedHat), and the Sybase Central
locks up when I'm trying to change a column in one of my tables...

I've been at this problem all morning. Below you can see select sql
with included select in where statement. I have to use the max
function on the included select. The included select statement takes
only 10 seconds to execute and returns just under 4000 rows.

I notice in the Bloor report on the Sybase website (http://
www.sybase.com/detail?id=1039410) that Sybase is planning full grid
computing support in the future for ASE. Can someone give me the
timescales that this might be happening within and/or point me towards

http://libpipe.virtual-estates.com/
With this plugin the destination of your dump no longer has to be a named
file. It can now also be a stdin of an arbitrary command or a port on any
host on your network.

I have a stored proc SP2, which returns some data as the result.
Another stored proc SP1 needs to call SP2 inside it. How do I receive
the results from SP2? I cannot modify SP2 because its a common stored
proc. SP2 has no out params either.

How would I add sequence numbers to a set of numbers I am quierying
from a table?  For example:
I have a set of random numbers 2, 8, 9, 55 in table RANDOM.  I want my
select statement to give me the following results: