Parameter for Sybase Sql Anywhere 12 Serverport

sybase

If SQL Server Anywhere is started via "dbsrv12.exe -z -x tcpip " it opens a Serverport.

Default is 2638.

If more then one database is opened, the other ones are getting "some" serverports.

How could I say: open the server on "this" port

In help of SQL anywhere I find:
TCP/IP: Broadcast, BroadcastListener, DoBroadcast, Host, LDAP, LocalOnly, MyIP, ReceiveBufferSize, SendBufferSize, ServerPort, TDS, Timeout

Using dbsrv12.exe -z -x tcpip ServerPort 54382 gives 2 errors, that ServerPort and 54382 are not a file.

http://dcx.sybase.com/1200/en/dbadmin/serverport-network-conparm.html states that:

You can specify a single port number, or a combination of individual
port numbers and ranges of port numbers. When you specify a list
and/or range of port numbers, the database server attempts to bind to
all specified port numbers. For example: (port=1234)

Default TCP/IP 2638

Therfore i tried dbsrv12.exe -z -x tcpip (port=54382) and dbsrv12.exe -z -x tcpip 54382, both giving the same error as above.

In which way do I misunderstand the help?

Best Answer

The proper syntax is:

dbsrv12.exe -z -x tcpip(ServerPort=54382)

No space between tcpip and the (. You can use "Port=" instead of "ServerPort=" if you want.

Related Solutions

Sybase internal tables for ORM generation

Those tables are still in ASE 15.5

Query for COLUMN_NAME LIKE “X” in sybase(Transact SQL)

First: This isn't easy to implement and it's going to break very easily (by which I mean performance is going to be horrible, and it's a nice little route for SQL injection attacks if you're not very very careful). I strongly advise you to re-think what you're doing because there has to be a better way.

Second: The question as it stands doesn't actually make sense - what condition are you checking on the columns? NOT NULL? Also, do you want to AND or OR the conditions together?

To actually answer the question, though, to do this you'll need to write some dynamic SQL:

Link sysobjects to syscolumns, filter by the table name and the fields you're interested in.
Build a executable SQL statement using a cursor, then execute it.

Example below is, for each column in the Users table that starts with either 'A' or 'B', return all rows in the Users table that have a non-null value in any of those columns.

Note: I don't have a Sybase install handy to test this. Chances of it actually working are very low, but it should hopefully be enough to make you realise what a bad idea this is.

DECLARE @colname nvarchar(255),
        @sql nvarchar(4000)

SET @sql = 'SELECT * FROM Users WHERE '

DECLARE colcur CURSOR FOR
    SELECT sc.name 
    FROM syscolumns sc 
            INNER JOIN 
         sysobjects so ON so.id = sc.id
    WHERE so.name = 'Users'
        AND so.type = 'U'
        AND (sc.name LIKE 'A%' OR sc.name LIKE 'B%')
    ORDER BY sc.name
OPEN colcur

WHILE 1=1
BEGIN
    FETCH colcur INTO @colname 
    SET @sql = @sql + @colname + ' IS NOT NULL OR '
END

DEALLOCATE colcur

SET @sql = LEFT(@sql, LEN(@sql) - 3) -- need to trim off the trailing 'OR'

EXEC @sql

Related Question