Hi here are some other newbie question about translating SQLserver
intructions in ASE.
If anyone could point out the necessary correction I will be grateful.
Thanks

How can I view a particular row from dbcc page?
Below is the full dbcc page output. I was told that the row on this page is
#19 (from nextrno which is 20).
Now, how can I select this row #19 from the table? (I already know the table

We noticed a file in the bin directory called setsslreg.exe.  What does
this do exactly?  It is not mentioned in the documentation at all.
Using Regmon it seems to read a bunch of keys (I wish I had used regmon
the first time I ran it, I will do it on a clean load today).  My guess

I am supposed to have 100,000 rows in a table loaded automatically.  I
have 999,993.  7 rows are missing and I need to find out which ones?
Any suggestions?  I am using sybase.
To simplify, assume table structure Name (id int,fName varchar(50))

We are currently working on getting SSL set up on our ASE server.  From
a client connectivity respect, what needs to be done for Open Client?
I have search far enough to know that the sql.ini entry replaces the
port with the text "ssl".  Is there a way to specify what port to

I don't understand how to detect from sysprocesses the unix user who
opened the connections.
I need to discovery from every actualy connection in sysprocesses table
the unix user.

As a software company we're creating solutions for the libraries
based on ASE 12.5.x for Linux and SunOS...
For FreeBSD there is described in the Sybase pages the existence
of an older version of ASE 11.0.3.3:

I am trying to adapt my knowledge of SQL server to Sybase.
I have some newbie questions.
Is it possible to include spaces in table or field names?
If yes which is the delimiter to be used?

I need a script to provide automatic start/stop of Sybase 12.5.3
during startup/shutdown of my Red Hat EL 4 server. (the script that is
located in /etc/init.d)
Anyone who can help me with a sample script?

As per our project requirement, we need the following issues to be
solved using Transact-SQL in Sybase:
1. Can we read or write a text file using Transact-SQL in Sybase
database?if yes, need the syntax of the same.

I am working with a client that is making an interface from a Sybase DB
to my Oracle backend and I am curious what he equivalent of a Oracle
Stored Procedure is in Sybase?
Any comments are greatly appreciated.

I have a table of this format..
id, value1, value2, rate
1    1       2M     2
2    1       3M     33

Can anyone tell me the meaning of the following query and the results :
select * from A, B, C
where A.id1 *= C.id1 and B.id2 *= C.id2
Contents of A,B,C are :

I can successfully use the following command to BCP export data to a
text file using the following, which export in "fixed column width
format"
D:\Program Files\Sybase.12\OCS-12_0\bin\bcp tempdb.dbo.tempTable out

I'm looking at a project to upgrade an ASE 11.9.* environment to ASE
15.  Question is, what versions of Open Client have been verified for
use with ASE 15?
Regards