SQL Anywhere 10 on Windows 32
I need a query that will return a string which is a list of comma seperated industry names.
The industry names are held in a table called industry, which has ...
Hi, I have following doubts, when I ran sp_freedisk it show me few devices below, but when I ran df-h it returned me other than what I have in sp_freedisk, how this disk configuration works in...
Hello!
We are in the process of planning a migration from an older version of SQL Anywhere to a newer, more robust DB. Specifically, we have a 54 million record db, 100 users (150 connectio...
Hi,
Wondering if anyone can explain why Sybase keeps generating new .CFG files? I simply manually delete them every now and again, though wondering if there is a way to stop this from occur...
Hi,
How do I use isql in Unix sybase to execute the t-sql directly and output the result somewhere in Unix partition ?
wher will parameter to put it ?
isql -Usa -P333333 -?select db_name...
I have a .db file made in "File Finder" software. This is a database used in executive recruitment. I no longer have the "file finder" software, but want to open the .db file to be able to rea...
Hello Guys!
I am using .NET to connect to a SYBASE database (15) using the Sybase ODBC driver.
My question(a) are:
If ODBC is set to disable within the ODBC Administrator, can I enable ...
Hi, I have a doubt in replicating data between tables in sybase replicaion system.
I have 2 repservers REP_TEST1 and REP_TEST1HA. I have 2 ASE, TEST1 and TEST1HA
Now i created a table t1 w...
Hi, I need general information about Sybase ASA 10. Let's say that we have around 100 users and 7 databases. Largest database is 20 GB. Databases are used for custom ERP solutions.
What would...
Hi Experts,
Please suggest and equivalent for sp_msForEach in sybase?
Best regards,
Aman
How do I know wherehr sybase has installed with replication server? how do I gest access there and what should the server name I use to logon via isql ?
I have a rather big table and the text search function in text fields is problematic. In order to speed up the search, we evaluate to use CONTAINS search condition and I wonder if this approac...
Currently we have an old Alpha server running Sybase as a data warehouse. The database currently gets dropped once a week so that a dump can be performed for backup purposes. Is there a way to...
Hi,
I have read the manuals of replication server ....not fully but to good extent. I have following questions/doubts related to queues and threads :
what all threads are created when we a...
Hi,
I have a Batch of Select statements and I would like to know which one is currently being executed by sql server...
Like
Select * from A
Select * from B
Select * from C
Select * f...
I am getting the following message when I try to exedcute a statement
ODBC Call failed
[Sybase] [ODBC Driver] [Adaptive Server Anywhere] Resourse Governor for 'prepared statements' excee...
bcp error file not generated in the path given for -e.
I am running this from unix
/opt/sybase/bin/bcp PRODUCTION..TEST_TABLE in /home/user/bcp/TEST_TABLE.txt -e"/home/user/bcp/error_file.tx...
Hi,
Is there any way I can read sybase sql error logs by using isql or any T-sql command ?
Hi,
I have been assigned to work on replication on Sybase, I'm quite new on sybase and now wanted to do some testing in my development box, so how do I begin and install with sybase replication?
what is wrong here ?? got an error...setting up warm standby
1> create connection to SYB_UTS1HA.test7_ws
2> set error class to rs_sqlserver_error_class
3> set function string class to r...
Hi,
In sybase how do I know whether Sybase has been configure either witj 2KB 4KB or KB of cache
