Questions tagged [sybase-ase15]
120 questions
0
votes
0 answers
ASP Classic Application having data issues after database was upgraded from Sybase 12.5 to 15
Over the weekend we migrated our Sybase ASE 12.5 instance to a 15 instance. A classic ASP application that is connected to the Sybase database is mostly working correctly except one page. On that page when one of the methods is called that sends a…
Courtney Saganski
- 15
- 7
0
votes
1 answer
Adding not null to a TEXT type column in Sybase ASE
I am not able to add a TEXT type column to a table in sybase ASE with not null constraint. I am able to add TEXT column, but "not null" constraint not able to add.
Or how to modify TEXT column to add "not null" constraint. When I try to modify a…
yogish
- 85
- 17
0
votes
1 answer
What are types finishing with "N" in Sybase ASE?
I'm working with a Sybase ASE 15.7 instance.
After querying the systypes table, I've seen many data types such as floatn, intn, datetimn, moneyn. They have the same length of their counterparts (float, int, datetime, ...) and seem to differ only in…
DiegoAlfonso
- 237
- 5
- 15
0
votes
1 answer
Row count using isql Syabse
I am trying to create a script for finding the row count for some tables in sybase ase.
I have used the below --
set nocount on
go
set proc_return_status off
go
select count(*) from schemaname.tablename1
select count(*) from…
0
votes
1 answer
PCI IN slow with cluster index
We are working with ASE SYBASE 15.7
We have a huge historical table: 700 millions of records and one CLUSTER INDEX: c1,c2,c3,c4 with ALLOW_DUP_ROWS
Every month we load 700,000 records en the table via BCP IN
These records had a lot of duplicate…
Rod
- 5
- 1
0
votes
1 answer
how to locate a partucular letter in a word in sybase(like we do instr in SQL)
I am working in Sybase environment and trying to figure out how to find the records that have particular letter in a word from a column
example i have a column name plan name it has records like 'MYMR001','SYMR0101',NYMR1111' ETC.. i need to…
gowtami
- 13
- 4
0
votes
0 answers
Return -1 if a procedure fails due to any error
How can I get the procedure to return -1 in sybase whenever there is an error? I want it to throw -1 irrespetcive of the type of error
0
votes
1 answer
Sybase query iteration
I have populated data in a temp table ( the table will always have 10 records max). The next step I am trying is to pick up records one by one and query the database to test some condition and assign a comment based on the outcome of the query. For…
Newbie
- 11
- 2
0
votes
2 answers
Whats the difference between table scanning a clustered table, vs index scanning
THE SITUATION
I Have a table with only one index, a Clustered index (two columns).
I do a 'SELECT * FROM TABLE' and the optimizer decides a Table scan.
I get the rows kinda sorted by clustered index. I say kinda because it doesn't look randomly…
Nelssen
- 1,023
- 1
- 17
- 42
0
votes
2 answers
Convert the Numeric data type to varchar without trailing Zeros in sybase
How to Convert the SQL data type Numerci(15,2) to string(varchar data type) without adding the trailing zeros in sybase.
Example- in column abc below values are present-
0.025
0.02
NULL
0.025589
5.289
on running the query-
select STR(column,10,4)…
RGoyal
- 165
- 3
- 16
0
votes
0 answers
How to increase performance of audit tables?
PROBLEM
Audit triggers are killing the performance of my bulk update query, by inserting an old row and a new row on every update.
In this trigger the insert of old rows, for some reason, takes much more time than inserting the new rows.
TABLE
The…
Nelssen
- 1,023
- 1
- 17
- 42
0
votes
2 answers
weird phenomena during deadlocks involving IMAGE or TEXT columns
This is something very disturbing I stumbled upon while stress-testing an application using Sybase ASE 15.7.
We have the following table:
CREATE TABLE foo
(
i INT NOT NULL,
blob IMAGE
);
ALTER TABLE foo ADD PRIMARY KEY (i);
The table…
Marcus Junius Brutus
- 26,087
- 41
- 189
- 331
0
votes
1 answer
Cannot allocate a worktable object id because all valid object id values are already in use
I'm trying to fetch list of id's from a table using java program and i'm checking if those id's are present in another two tables . If they are not present , i'm trying to delete those id's from the first table where i fetched .
I'm running into an…
Praveen
- 225
- 1
- 4
- 18
0
votes
0 answers
LS-00201: identifier 'SYB12ALLPLATFORM.STAGECAPTURE' error while migrating from oracle to sybase
I am trying to migrate from oracle to sybase ase 15.7 with oracle sql developer, and after minutes of migration loading appearing, I got this error:
LS-00201: identifier 'SYB12ALLPLATFORM.STAGECAPTURE' must be declared
Do you have any idea what is…
Moudiz
- 7,211
- 22
- 78
- 156
0
votes
1 answer
Sybase missing insert
we have a sybase ASE 15 DB and something weird happened last week, it looks like a select on a newly inserted row maybe missed right after the insert
our table uses start/end timestamp for milestoning; an example is
id number,
name…
CSBob
- 39
- 2