tableA - 500k rows
A1 numeric (PK, clustered)
tableB - 10k rows
B2 numeric (PK, clustered)
tableC - 600k rows
C1 numeric (PK, clustered)
C2 numeric (PK, clustered) and (index, n...
Hi all,
I am new on sybase, I forgot isql sa password,
how can I connect isql ?
any way to change unknown password? any files? any
methods?
is there any equivalent of svrmgrl Oracle for...
Hi friends,
I need a bunch of sybase interview questions. Questions are from basic level to intermediate level.
If you have a good material then please share it with me. That will be ver...
I am running Intellisync Mobile Sync Server on the same Windows 3002 box as Symantec Endpoint Manager 11.04. Both programs come with their own, and are setup to use Adaptive Server Anywhe...
I would like to check wethere 2 columns which are of type dateime have the same date.When I test ,I see that
table1.dateT1 = table2.date2 does not work,even though they have the same date tim...
Hi, we've just upgraded to Sybase SQL Anywhere v10 from v5.5 (long story, we had a 16 bit app that could not be ported past v5.5 and it kept us on v5.5 but we're finally now moving to v10)
...
Hi,
I was wondering what the escape charater for a single quote is in Sybase. i'm trying to do the below update statemwnt and one of the strings contains a persons name with a single quote!...
I have to execute many updates on a table using java batch updates, but i when i try to execute my code on 22,000 records, it just hangs.
How can i optimize the updates to not use NOARCHIVE...
I am having trouble getting a csv file in via bcp what is the command line I should use?
Here is the file, I have the table as the first field varchar(30) all the rest are numeric (7,4), I'...
Don't ask me why, but a colleague has a need for the equivalent of MS SQL Server's ISNUMERIC() function in Transact SQL. Is there a stored proc somewhere already that can accomplish the feat p...
Hi all....
I'm working on Sybase 11.9.2.4 on HP-UX.
Now we've had this situation where, in an applicationlog an error 'Out of locks' is shown but when I look in the Sybase-errorlog I do no...
Hi I have query on Sybase DBA ....
Basically I need to create list of tables on sybase database with having permissions from each user group...
i.e.
columns
- table name
- user group ...
I want to bcp out the table called doc from a file and put it in the database.
file name: scanning1..docs.bak
table name: docs
database name : scanning.
Can someone please help me out.
...
I need to retrieve the number of rows from syscolumns table
which wd give me the faster result?
select count(*) from syscolumns where object_name(id) = 'employee'
or
select count(1) from s...
I'm calling a Sybase stored procedure from a Java program using the executeQuery() method. I'm using the stored proc to see whether a record exists given a key (passed into the proc). I proces...
Hi,
Could you please share your experiences about typical performance problems faced after upgrading from Sybase 12.5.X to Sybase ASE 15.0 (not linked to Infrastrcture like host, storage, e...
I'm having some trouble mixing query hints. Seems that I can choose parallelism, or I can choose the index I want, but I can't have both. The query plans shown below illustrate my problem. I'v...
Hi
I am currently developing a budgeting tool in Excel and as part of the project I have been asked to research whether it possible to have some link between the budget spreadsheet and our ...
Hi,
this is a sort of reposting. I have a datefield in a txt-file I want to bcp-in. (SYB 11.0.2, AIX).
The format of the datefield is dd-mm-yyyy . Up until now I import the datefield as char i...
Wondering whether anyone could help out with a portion of a stored procedure I am having trouble with ?
This is an example of a stored procedure I am trying to execute (this one works...
How can I do reorg rebuild all indexes in all databases? Can some one help me with script?
Trying to import file using bcp and get the error:
Server Message: - Msg 2402, Level 16, State 0:
Error converting characters into server's character set. Some character(s) could
not be...
Hi ,
Our database filesystem on unix got an I/O error .We were not able to work with the databases.
I restarted the Sybase server. Got the following error:
0:00000:00016:2006/12/19 0...
I have read on many websites that the update/insert/delete trigger fires only once per transaction. Thus if I have a statement
that updates multiple rows, only the trigger will fire only on ...
In Sybase, what is the maximum number of characters that a table name can have? Also, what is the maximum for column names?
thanks!
