Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Create SQL Anywhere Database dialog box – PB Docs 2019 – PowerBuilder Library

Create SQL Anywhere Database dialog box – PB Docs 2019

Create SQL Anywhere Database dialog box

Description

Create a local SAP SQL Anywhere database.

Options

User ID

Enter the user ID. The default is DBA.

Password

Enter the password. The default is SQL.

Database Name

Enter the filename and path of the database you are creating.
Click Browse to browse the file system for existing database files.

Prompt for Password

Check during Connect if you want to be prompted to provide
your password when you connect to this database.

Use Transaction Log

Check to record all database activities. The transaction log
plays a key role in backup and recovery.

Log Name

Enter the filename and path of the transaction log that will
be used to record all database activities. If you do not specify
a path, the transaction log is placed in the same directory as the
database file.

Page Size

Specify the page size of your database. Large databases usually benefit
from a large page size.

Collation Sequence

Select a collating sequence, which is used for all string comparisons
in the database. By default, normal ASCII (binary) ordering will be
used for the lower 128 characters. For the upper 128 characters
(the extended characters), characters that are accented forms of
a letter in the lower 128 are sorted to the same position as the
unaccented form. The determination of whether or not an extended
character is a letter is based on code page 850 (multilingual code
page).

Encrypt database

Check to make it much more difficult for someone to decipher
the data using a disk utility to look at the file. File compression utilities
do not work well on encrypted database files.

Case Sensitive Values

Check if you want all names (tables, columns, and so on) to
be case-sensitive, so that, for example, the Empname column is not
the same as the EMPNAME column.

Java Enabled

Check if you use Java in your database. To use Java, you must install
entries for the runtime Java classes in the system tables.

Blank Padding

Check if you want trailing blank spaces to be ignored when making
comparisons. By default, trailing blank spaces are significant when making
comparisons

See also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x