Hello

I am looking for a script that creates a database like this:

createdb -N -S -s 2000

to create a database of 2G

In the script, I will use this:

isql -U sa -P -S server_name
create database on =2000

how to search for a free device_name that has less than 2G
space?

Do you have any other script that automatically creates a
database?

thank you!

i am using pfc security scanner/admin to set the security
for my application. I encountered problem, after scan the
window, and columns object did not display for me to disable
it. What can i check for the above problem?
Please advice. Thank you.

Running ASE 15.0.2 ESD 5, the following "Warning" messages
appear in the errorlog on startup ... not affecting any
functionality as far as I know, but would like to know the
reasons.

kernel Warning: Cannot resolve LDAP function
ldap_search_ext_s.
..........
Warning: Cannot set console to nonblocking mode, switching
to blocking mode.

in sql, you can use "set quoted_identifier on", then double quoted
table name like "table 1"
but how to deal with bcp? this is OS level command not sql command.

like this:
$bcp "XTREME2003"."XTREME2003"."Account Class" in /data/
AccountClass.data -c -Usa -Psa -Ss15
got error:
Starting copy...
Server Message: s15 - Msg 102, Level 15, State 1:
Incorrect syntax near 'Class'.

CTLIB Message: - L1/O3/S0/N14/0/0:
blk_init(): blk layer: CT library error: Failed when CT_Lib routine
ct_results() called.
blk_init failed.
bcp copy in failed

On a database level we have the "select into" option on our
Sybase database disabled, because we have replication
enabled.
This means that we are unable to add new columns to a table
by using the "Alter table add column" statement.

As a work around we are create a temp table, import the
original data into the temp table, drop the original table,
recreate the original altered table and import the data back
in from the temp table.

This was working fine, until we switched from table locking
to row locking. When this statement was run as a script, we
lost 95%% percent of our data, because the original table was
dropped before the all the rows were imported to the temp
table.

My questions are:

1. Is it possible to have the "Select Into" option enabled
without affecting the replication?

How can one transform 1200200.12 to $1,200,200.12 or 12.12
to $12.12 or 1234.12 to $1,234.12?

Hi All,

I just found this error on the log:
Internal error occurred. Unable to write statistics for
table %% in dbid %%

And after a lot of search I did not find anything about
this. I thought this could be related to log segment full,
once the database that this error occur as the abort tran
option on.

But I have no messages on the error log about log segment
full, so I have no idea why this error is related to.

Thanks in advance for any suggestions,
Regards,
Sérgio Diogo

Hi

Im working on finding a way send an update notification to
all clients connected to an ASE when certain tables are
updated

The reason is that each client (ct-lib app) has a cached
copy of certain tables for performance reasons. So we need a
way to mark the cache as dirty.

I have been reading around a little and it seems that ct-lib
can, in a client, register a function as a callback for
server messages. The question is if we can send such a
message from say a trigger or an extended procedure?

/Magnus

Hi
I used Sybase 12.5 and need to find the space used for a non-accesible
database
I know that sp_spaceused can be used to get space used for any
database but I have a sybase ASE 12.5 server user who does not have
access to all databases under that server. For those non-accessible
databases when I try to do sp_spaceused I get the following error

Msg 10351, Level 14, State 1:
Server 'emcpp_fs', Line 1:
Server user id 3 is not a valid user in database 'model'

sp_spaceused runs under the context of the database. Is there any
other stored proc in sybase ASE from where we can get used size for
the database which is not accessible to a user?

Thanks,
Jayaram

Hi

I want to access a table on a db that is on a remote sybase
server.

on the remote server I did

sqsh -Usa -P -SQA36DB

sp_addserver 'lcl',ASEnterprise,'lcl'
sp_serveroption 'lcl',timeouts,'true'
sp_serveroption 'lcl','net password encryption','false'
sp_serveroption 'lcl','rpc security model B','false'
go

I also added an entry for lcl in the interfaces file of the
remote db.

what else is needed?

thanks