Tagged Questions
2
votes
0answers
129 views
Sybase SQL - Truncation error occurred. Command has been aborted
Need help with below code, as it fails with truncation error
Truncation error occurred.
Command has been aborted.
create table monCacheQuality (
ServerName sysname
...
1
vote
2answers
92 views
Search every column in every table in Sybase Database
I'm been taxed with the task of creating an application that pulls data from our Micros Point of Sales system. The POS is using a Sybase database running on one of our servers. The database schema is ...
1
vote
1answer
296 views
Sybase SQL Anywhere 12 - Get all indexes which are unique -> ambigious sysindexes error
we are using a Sybase SQL Anywhere 12 db.
In the db there are indices, which are unique, but shouldn't be unique.
Therefore I search for a quick way to list all tables with unique primary keys.
I ...
0
votes
0answers
37 views
“optimizer was unable to construct a valid access plan” after Update ASA9 to SA12
After an update from ASA9 to SA12, there seems to be a problem with several procedures.
This occurs only if the user does not have DBA authority. In ASA9 everything worked fine.
SELECT * FROM ...
0
votes
3answers
1k views
How to import Sybase .db file into SQL Server database?
I've been given a Sybase .db file by a client and I need to import that into a new SQL Server database so that I may see the data as well as the tables and their relationships, any ideas on how that ...
2
votes
3answers
188 views
Refactoring Series of UNIONs in single table (SQL/SYBASE)
I am trying to query a database and reformat the rows/columns that I am interested in. Each row in the current table (EQ) represents a field in a form. In reality, there are several hundred FieldNum ...
2
votes
1answer
388 views
Tracing/Logging of Sybase ASA
Trying to get logging/tracing of Sybase 9.0.2.3396 (Adaptive Server Anywhere). I wish to log all the SQL executed against the database.
I tried RIBO and while I got it "working," I never saw anything ...
4
votes
2answers
540 views
When is a result returned deterministic and when not?
if you execute a statement like this:
select first field1, field2 from exampleTable where field1 = '1';
then you get a warning like this:
The result returned is non deterministic SQLCode=122
...
2
votes
2answers
234 views
SQL Joins Order of Operations
I'm new to SQL but happen to be dealing with a couple of rather larger table (on the order of a billion rows each).
I want to do an inner join like the following:
SELECT *
FROM XTABLE X
INNER ...
4
votes
1answer
2k views
How to find the date a login password was last changed in SQL Server 2008?
I'm porting stored procedures from Sybase 15 to SQL Server 2008.
In Sybase this statement calcs an expiration date by adding a number of days to syslogins.pwdate (Date the password was last changed) ...
44
votes
4answers
4k views
Why use both TRUNCATE and DROP?
In the system I work on there are a lot of stored procedures and SQL scripts that make use of temporary tables. After using these tables it's good practice to drop them.
Many of my colleagues (almost ...
13
votes
1answer
534 views
Sql Anywhere 11: Restoring incremental backup failure
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible ...
