Sybase Adaptive Server Anywhere, is an RDBMS by SAP, that runs as an embedded database. Since version 10, ASA is developed under the name [SQLAnywhere]
Questions tagged [sybase-asa]
162 questions
0
votes
1 answer
Sybase Adaptive Server Anywhere 6 Trigger - Trying to detect if im INSERTING or UPDATING
In v10 of the Sybase Adaptive Server Anywhere inside a trigger i can check what event executed the trigged by using:
IF UPDATING THEN
-- Do Stuff
END IF;
IF INSERTING THEN
-- Do Stuff
END IF;
However in v6 this is not recognised. Any idea how i…
CathalMF
- 9,705
- 6
- 70
- 106
0
votes
2 answers
Sybase ASA 9 Stored procedure, use default parameter
I have a stored procedure'test' in Sybase ASA with for example 4 parameters.
par1 INT = 0,
par2 VARCHAR(50) = NULL,
par3 VARCHAR(100) = NULL,
par4 VARCHAR(10) = ''
Now I want to execute this stored procedure with par1 as its default value.
call…
jwdehaan
- 1,445
- 3
- 13
- 25
0
votes
1 answer
Is it possible to recoverDB File in sybase? i have lost my db file
I have lost my "Trak.db" there is log file is available is it possible to recover this one through log file? use of Log files?
Ambat bhath
- 1,425
- 1
- 12
- 23
0
votes
1 answer
Calling a Sybase SP, error "SP not found"
I am connecting to a Sybase 9 database to retrieve data. I can query the database without issue using ODBC connections but I am having an issue calling stored procedures. The procedure was written probably 6-7 years ago. This is what I have to…
Chase
- 564
- 7
- 22
0
votes
2 answers
Prepared statement with "partition by" doesn't work against Sybase IQ?
I'm seeing a problem when querying Sybase IQ with a prepared statement. The query works fine when I type the entire query as text and then call PrepareStatement on it with no parameters. But when I stick in one parameter, then I get back errors,…
tavistmorph
- 979
- 3
- 9
- 8
-1
votes
1 answer
sybase escape character
I have an update query that updates a column that holds another application SQL query.
Putting SQL inside has been problematic I wanted to resolve it with escape characters.
update
my_table
set
sql_column = 'UPDATE inner_table SET…
Ali Saberi
- 864
- 1
- 10
- 33
-1
votes
3 answers
change and merge multiple values on column if there is duplicate value in other columns
Sorry, I'm new to SQL..I'm using Sybase Central
I need help, I'm currently stuck on data table from select statement (stored procedure) like this :
select case when product like 'A%' then 'Product A' when product like 'B%'
then 'Product B' else…
Untung Tanujaya
- 1
- 1
-1
votes
1 answer
How to get unique pairs in SQL when there is many to many relationship in data
I have following data. I need to make unique pairs.
element1 element2
E1 C1
E1 C2
E2 C1
E2 C2
E3 C1
E3 C2
How can I use SQL to get pairs as follows:
E1,C1 …
user3376169
- 405
- 1
- 5
- 17
-1
votes
2 answers
SQL Issue - Does not read NULL value
I have an issue when I try to run the code, everything runs well when I set my PASSWORD= '' as the code below.
public int ClearEmployeePasswordById(Employee p)
{
int result = -1;
try
{
string sql = "UPDATE…
Muhammad Saifullah
- 87
- 1
- 3
- 15
-1
votes
1 answer
Export / import database tables sql script
I run a powerbuilder app on a asa8 database.
I want to export data from tables to a sql txt file and import into another database db file.
I thought of creating a sql insert script but after much research and trial and error not getting…
Alex Szlanina
- 49
- 7
-1
votes
1 answer
"Out of Memory" error when using store procedures
I wrote some services for creating dbs, copying some records among dbs or tables etc, so many db operations. But im dealing with memory problems. One of them:
Im getting records with store procedures and filling in entity lists;
public…
htcdmrl
- 194
- 1
- 10
-2
votes
1 answer
Open Sybase Sql Anywhere 9 .db file without DBA PASSWORD of 3rd party
I'm Beginner in Sybase Sql Anywhere.
I have a "coop_db.db" file from the 2nd Party.
I want to open this file but i dont have a UserID and Password from the 3rd Party. I already tried the default authentication
UserID:"dba" and Password:"sql"
but…
Dandrave Ababa
- 1
- 1