Stack Overflow
Stack Overflow

Questions tagged [sybase-asa]

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]

162 questions
0
votes
0 answers

Sybase remote server to oracle: "Data source name not found and no default driver specified"

I'm trying to setup a remote server on a sybase ASA 12 database (64bit) that connects to a oracle database (11g). Therefore I created an ODBC dataSource with the Orcale instantclient_11_2 driver. The connection test was successful. Name:…
Mossos
  • 11
  • 1
  • 4
0
votes
2 answers

Stored procedure to do a two-level pivot

I am trying to create a stored procedure in Sybase Adaptive Server Anywhere that will do a double pivot of table. I will first outline with some images what I am trying to accomplish. The problem Raw data Here is the raw data in the table; in the…
BruceHill
  • 6,954
  • 8
  • 62
  • 114
0
votes
0 answers

ASA database when moved/copied data dissapears

Good Day. I'm having a funny scenario when when I relocate a ASA database file then data goes missing. I run a PB9 application connecting to a ASA8 database via ODBC. The database contans approx 30 tables. Below are 2 actual scenario's: I create a…
Alex Szlanina
  • 49
  • 7
0
votes
2 answers

Save files to database record but NOT as blob - save in directory on PC

Has anyone ever saved files against database record but stores them in a directory on PC? So software which allows you to add files against database record but at the point of adding it, it creates a directory and takes a copy of the file and puts…
Sharpie
  • 373
  • 2
  • 15
  • 34
0
votes
1 answer

capture/store when fields in database records have been changed/edited

I have a multi user database system which stores records with various fields e.g. text, date time etc. Does anyone know of a way to capture when fields of a record have been changed/modified by a user. A bit like a audit history which displays all…
Sharpie
  • 373
  • 2
  • 15
  • 34
0
votes
1 answer

Column Ordering in SyBase Anywhere

I have a Sybase Anywhere database where in I have a table (say Table A). I need to check the ordering of columns within this table. Say if there are 3 columns in table A. Col_1, Col_2 and Col_3 How can I check whether Col_2 comes between Col_1 and…
WinSupp
  • 361
  • 2
  • 6
  • 20
0
votes
1 answer

Filter database records by Date range

I have a database system which allows users to create records. At the point of posting the record to the table it captures the current date and time. I have a form which allows users to filter/search for records. What is the best way to allow…
Sharpie
  • 373
  • 2
  • 15
  • 34
0
votes
1 answer

Filtering more than one record in database table throws up syntax error/access violation

Using Delphi XE2. I have a database software package which displays records from a table onto a cxgrid. I have implemented a filter button with at a click of it allows users to search for results using specific records. At the moment it only works…
Sharpie
  • 373
  • 2
  • 15
  • 34
0
votes
2 answers

database usernames and passwords in delphi

Using Delphi XE2. I have a database with a table in it called users. It has a user_id field, username field, a password field and an Active field in it. (the user_id is a unique number that identifies each user... 1,2,3 etc). I am writing a database…
Sharpie
  • 373
  • 2
  • 15
  • 34
0
votes
1 answer

incorrect data update on Sybase trigger execution

I have a table test_123 with the column as: int_1 (int), datetime_1 (datetime), tinyint_1 (tinyint), datetime_2 (datetime) So when column datetime_1 is updated and the value at column tinyint_1 = 1 that time i have to update my…
Arpan
  • 913
  • 2
  • 12
  • 19
0
votes
1 answer

SQL Correlation error using OVER & PARTITION in SELECT statement

I am getting the following error when I am trying to execute my SQL SELECT statement Could not execute statement. Correllation name 'contact' not found SQLCODE=-142, ODBC 3 State"42S02" Line 1, Column 1 My code is as follows Select forename,…
Jonathan Griffin
  • 148
  • 2
  • 17
0
votes
1 answer

Adding index to the column already having an index

there are indexes available for each columns. for ex: indx1 on col1 and indx2 on col2. is it possible to create again a composite index indx3 by combining col1 and col2? col1 and col2 are used in the where condition. will indx3 is in effect?
Sabarmathi Natarajan
  • 1
0
votes
1 answer

ASA 8 database.db file size doesn't increase

I'm running an app on a asa8 database. Since the beginning with a 'clean' database the size was 9776 kb. Now after a while and being populated with 30 tables with lots of data, the size is still 9776kb. My question is - is there a ceiling as to how…
Alex Szlanina
  • 49
  • 7
0
votes
0 answers

which one has better performance: patindex and like

in a query where condition clause. to check if string a contain b, I have a few options with T-SQL(Sybase): a like '%b%' charindex(b,a)>0 patindex('%b%', a)>0 which one has better performance?
KentZhou
  • 24,805
  • 41
  • 134
  • 200
0
votes
2 answers

Sybase SQLAnywhere jConnect routines?

I have a database which is part of a closed system and the end-user of the system would like me to write some reports using the data contains in a Sybase SQL Anywhere Database. The system doesn't provide the reports that they are looking for, but…
jr.
  • 4,503
  • 7
  • 44
  • 62
1 2 3
…
10 11