Sybase Database(SQL Anywhere 11) Binaries Description

Sybase Database(SQL Anywhere 11) Binaries:

 
dbsrv.exe => Sybase Network Database Server

dbeng.exe => Sybase Personal Database Server

dbmlsync.exe => Use the dbmlsync utility to synchronize SQL Anywhere remote databases with a consolidated database.

dblib.dll => Sybase C library(Interface library)

ctlib.dll => Sybase C library(Interface library)

Details: The Client Library(CTlib) syntax has been unified and simplified compared to DBlibrary, and the number of API calls has been greatly reduced: the Sybase::DBlib module implements 93 calls, the Sybase::CTlib module fewer than 20, with similar functionality. In addition, native handling of Dates and other special data types can make things a lot easier when writing scripts.Missing features in the current version of the Sybase::CTlib module includes access to the bulk copy library (it is available in the Sybase::DBlib version), asynchronous programming and dynamic SQL. The bulk copy library will certainly be added in the near future.

dbextclr11.exe => Allow Sybase database server make calls into the CLR

Details: The dbextclr11.exe has two versions, a 32-bit version and a 64-bit version - one is provided in \bin32 and one in \bin64. These are to allow 32-bit/64-bit database servers make calls into the CLR, but both dbextclr11 processes will launch the "same" system CLR underneath the covers. This is where the "Any CPU" setting of the .NET assembly is used (as the CLR then picks itself to run in '64-bit' mode, even if it was launched from a 32-bit version of dbextclr11).

sqlpp.exe => The Sybase IQ SQL preprocessor utility translates the SQL statements in an input file (.sqc) into C language source that is put into an output file (.c).

Details: Embedded SQL is a database programming interface for the C and C++ programming languages. Embedded SQL consists of SQL statements intermixed with (embedded in) C or C++ source code. These SQL statements are translated by a SQL preprocessor into C or C++ source code, which you then compile.

dbisqlc.exe => Executes SQL commands against a database

Miscellaneous Sybase database Info:

List of Sybase global variables =>

@@error => Commonly used to check the error status (succeeded or failed) of the most recently executed statement. Contains 0 if the previous transaction succeeded; otherwise, contains the last error number generated by the system. A statement such as if @@error != 0 return causes an exit if an error occurs. Every SQL statement resets @@error, so the status check must immediately follow the statement whose success is in question.

@@fetch_status => Contains status information resulting from the last fetch statement. @@fetch_status may contain the following values

0 The fetch statement completed successfully.

-1 The fetch statement resulted in an error.

-2 There is no more data in the result set.

This feature is the same as @@sqlstatus, except that it returns different values. It is for Microsoft SQL Server compatibility.

@@identity => The last value inserted into an Identity/Autoincrement column by an insert, load or update statement. @@identity is reset each time a row is inserted into a table. If a statement inserts multiple rows, @@identity reflects the Identity/Autoincrement value for the last row inserted. If the affected table does not contain an Identity/Autoincrement column, @@identity is set to 0. The value of @@identity is not affected by the failure of an insert, load, or update statement, or the rollback of the transaction that contained the failed statement. @@identity retains the last value inserted into an Identity/Autoincrement column, even if the statement that inserted that value fails to commit.

@@isolation => Current isolation level. @@isolation takes the value of the active level.

@@procid =. Stored procedure ID of the currently executing procedure.

@@servername =. Name of the current database server.

@@sqlstatus => Contains status information resulting from the last FETCH statement.

@@version => Version number of the current version of Sybase IQ.

ref:

Sybase documentation - http://infocenter.sybase.com/help/index.jsp, http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc37774_1150/html/apptech/BGBCBACD.htm

SQL Anywhere 11 -  http://dcx.sybase.com/index.html#1100/en/saintro_en11/saintro_en11.html

Sybase Transactions - http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@ebt-link;pt=19681?target=%25N%15_52735_START_RESTART_N%25

Sybase SQL Variables - http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/CACGCGBI.htm