When you work with an ASA table in the Database or DataWindow painter, the default behavior is to treat any column named timestamp as an ASA Transact-SQL special timestamp column.
You can create a Transact-SQL special timestamp column in an ASA table.
To create a Transact-SQL special timestamp column
in an ASA table in PocketBuilder:
Give the name timestamp to any column having a timestamp datatype that you want treated as a Transact-SQL special timestamp column. Do this in one of the following ways:
In the painter – select timestamp as the column name. (For instructions, see the User’s Guide.)
In a SQL CREATE TABLE statement – follow the “CREATE TABLE example”.
Specify timestamp as
the default value for the column. Do this in one of the following
ways:
In the painter – select timestamp as
the default value for the column. (For instructions, see the User’s
Guide.)
In a SQL CREATE TABLE statement – follow the “CREATE TABLE example”.
The following CREATE TABLE statement defines an ASA table named timesheet containing three columns: employee_ID (integer datatype), hours (decimal datatype), and timestamp (timestamp datatype and timestamp default value):
CREATE TABLE timesheet (
employee_ID INTEGER,
hours DECIMAL,
timestamp TIMESTAMP default timestamp )
If you want to change the default behavior, you can specify that PocketBuilder not treat ASA columns named timestamp as Transact-SQL special timestamp columns.
To specify that PocketBuilder not treat
columns named timestamp as a Transact-SQL special
timestamp column:
Edit the Sybase ASA section of the PKODB20 initialization
file to change the value of SQLSrvrTSName from 'Yes' to 'No'.
After making changes in the initialization file, you must reconnect to the database to have them take effect. See “Adding functions to the PKODB20 initialization file”.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
