Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [advantage]

Advantage Database Server: a relational database management system (RDBMS).

SAP Advantage Database Server, is a full-featured, easily embedded, client-server, relational database management system that provides you with Indexed Sequential Access Method (ISAM) table-based and SQL-based data access.

5 questions
4
votes
2 answers

Need help with null field values

I am having a problem with syntax. I have the following statement which updates a field in a table with a value from a field in a different table. I need the statement to update the field with the text in field 142 unless field 142 is null, then…
R. Beck
  • 43
  • 2
1
vote
0 answers

Transfer an Advantage Database's Schema/Data to a PostgreSQL Platform Using C# Program

I am currently in the process of writing a .NET program with C# to transfer a database on a Sybase/Advantage 9.1 platform to a PostgreSQL 9.3.4 platform. I am doing this transfer in two stages - transfer all the tables/schema without the data and…
AndrewC
  • 111
  • 2
0
votes
1 answer

SQL query using MAX with multiple table joins

I have a working SQL script to show results that join multiple tables. However, I want to limit the results of the join to show only one record per a given "Chart Number" value in one of the tables. Here is the original query: SELECT …
jengashare
  • 9
  • 3
-2
votes
1 answer

advantage database server current database name

How to get current database name in advantage database server? I don't know which query will answer this question. I have tried select top 10 * from system.logins but I got below error message: Error 7200: AQE Error: State = HY000; NativeError…
Arpit
  • 1
  • 1
-2
votes
1 answer

SQL select query that adds a new column name to output only (result values will be null)

For SQL SELECT queries, we often have requests to include a field name in the csv output which does not exist in the database. (to match the format of another system\database, for example) To handle this, I usually just edit the csv output file in…
jengashare
  • 9
  • 3