Chapter 9 SQL Statements
429
Page size limit
The page size cannot be larger than the page size used by the current
server. The server page size is taken from the first set of databases started
or is set on the server command line using the -gp command-line option.
COLLATION clause The collation sequence used for all string
comparisons in the database.
$ For more information on collation sequences, see "International
Languages and Character Sets" on page 287 of the book ASA User’s Guide.
ENCRYPTED clause Encryption makes it more difficult for someone to
decipher the data in your database by using a disk utility to look at the file.
Using this clause creates the database as an encrypted file.
BLANK PADDING clause If you specify BLANK PADDING ON,
trailing blanks are ignored in comparisons. For example, the two strings
’Smith’
’Smith ’
would be treated as equal in a database created with BLANK PADDING
ON.
This option is provided for compatibility with the ISO/ANSI SQL standard,
which is to ignore trailing blanks in comparisons. The default is that blanks
are significant for comparisons (BLANK PADDING OFF).
ASE COMPATIBLE clause Do not create the SYS.SYSCOLUMNS and
SYS.SYSINDEXES views. By default, these views are created for
compatibility with system tables available in Watcom SQL (versions 4 and
earlier of this software). These views conflict with the Sybase Adaptive
Server Enterprise compatibility views
dbo.syscolumns
and
dbo.sysindexes
.
JCONNECT clause If you wish to use the Sybase jConnect JDBC driver
to access system catalog information, you need to install jConnect support.
Specify JCONNECT OFF if you wish to exclude the jConnect system
objects. You can still use JDBC, as long as you do not access system
information.
JAVA clause If you wish to use Java in your database, you must install
entries for the Sybase runtime Java classes into the system tables. By default,
these entries are installed. You can specify JAVA OFF if you are sure you
will not be using Java, to avoid installing these entries.
♦
SQL/92 Vendor extension.
Standards and
compatibility
To Next Page
Loading...