|
|
|
ASNA DataGate® 8.1 for Microsoft® SQL Server™ 2000/2005
Installation Notes
Meet System Requirements
To run DataGate 8.1 for SQL Server and ASNA DataGate 8.1, you must have
certain hardware and software installed on your computer.
The system requirements include:
· Windows 2000 Professional SP4, Windows 2000 Server SP4, Windows Server 2003, Windows XP Professional SP2, or Windows Vista (Business Edition only)
· TCP/IP;
· You must be signed on with Administrative privileges in order to start the DataGate Service and to license both products;
· A CD-ROM disc drive.
· VGA or higher-resolution screen supported by Microsoft Windows.
· A minimum of 64 MB of RAM.
· A mouse or other suitable pointing device.
· At least 130 MB free disk space (includes a new installation of AVR, DataGate and DataGate for SQL Server).
SQL Server Express:
SQL Server Express is a version of SQL Server 2005, which requires the following minimal configuration:
1. TCP networking must be enabled via Surface configuration.
2. UDP port 1434 must be enabled in any firewall that may be running.
3. TCP port 1433 must be enabled in any firewall that may be running.
4. SQL Server Browser service must be enabled and started. It is installed disabled by Microsoft.
Recommendations:
· Run your mission critical Database running a backup Power Supply with NTFS (not FAT or FAT32) OR on an AS/400.
· Run your mission critical Applications with NTFS.
· Memory requirements should triple the minimum recommendation for the operating system.
·
Keep recent Data Backups.
Before installing ASNA DataGate 8.1 for SQL Server, consider the following:
· Read the following topic on Enabling SQL Server Instance(s) to ensure that the target instance(s) for Microsoft SQL Server 2005 will be properly detected and the installation process will complete successfully.
· Ensure that Microsoft for SQL Server has been installed, or install Microsoft for SQL Server. Refer to Microsoft SQL Server documentation for further information.
· Be sure the computer meets the system requirements for DataGate 8.1 for SQL Server. For more information, see System Requirements.
· Verify that the Microsoft SQL Server Service is started, and that the Auto-start service when OS starts is selected. See Starting, Pausing, and Stopping SQL Server below for more information.
· Review the Installation Instructions for installing DataGate 8.1 for SQL Server and be prepared to make the appropriate selections when running Setup.
· Read the Release Notes section in this document, or on the ASNA Developer Network site or DataGate for SQL Server for the latest on product issues, as well as known fixes, known bugs, etc.
Enabling SQL Server Instance(s)
Please complete the following steps prior to installing DataGate for SQL Server 8.1. These steps will ensure that the target instance(s) for Microsoft SQL Server will be properly detected and the installation process will complete successfully.
1. UDP port 1434 must be enabled for any firewall that may be running.
2. TCP port 1433 must be enabled for any firewall that may be running.
TCP/IP networking must be enabled for each target instance via the Service Configuration Manager.
3. Restart the SQL SERVER service for each target instance for the configuration changes to take effect.
4. Finally, SQL Server Browser service must be enabled and started. (It may have been installed as disabled by Windows)
The following includes the basic steps to install Microsoft
SQL Server. Please refer to the
Microsoft SQL Server documentation for further information.
To install Microsoft SQL Server 2000
1. Insert the Microsoft® SQL Server™ 2000 compact disc in your CD-ROM drive. If the compact disc does not automatically run, double-click Autorun.exe in the root directory of the compact disc.
2. Select SQL Server 2000 Components.
3. Select Install Database Server and setup prepares the SQL Server Installation Wizard. At the Welcome screen, click Next.
4. In the Computer Name dialog box, Local Computer is the default option and the local computer name appears in the edit box. Click Next.
For a remote installation, click Remote Computer. You can then type a computer name or click Browse to locate a remote computer.
If a cluster is detected, Virtual server is the default option.
5. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next.
6. Follow directions on the User Information, Software License Agreement and related screens.
7. In the Installation Definition dialog box, click Server and Client Tools, and then click Next.
8. In the Instance Name dialog box, if the Default check box is available, you can install either the default or a named instance. If the Default check box is not available, a default instance has already been installed, and you can install only a named instance.
· To install the default instance, select the Default check box, and click Next.
· To install a named instance, clear the Default check box, and type a new named instance in the Instance Name edit box. Click Next.
9. In the Setup Type dialog box, click Typical or Minimum, and then click Next.
If you want to select components and subcomponents, change character set, network libraries or other settings, click Custom, and then click Next.
10. In the Service Accounts dialog box, accept the default settings, enter your domain password, and then click Next.
11. In the Authentication Mode dialog box, accept the default setting, and click Next.
12. When you are finished specifying options, click Next in the Start Copying Files dialog box.
13. In the Choose Licensing Mode dialog box, make selections according to your license agreement, and click Continue to begin the installation.
Click Help for information about licensing or see your system administrator.
14. In
the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish.
SQL Server Service Manager is used to start, stop, and pause
the Microsoft® SQL Server™ 2000 components on the server. These components run as services on Microsoft Windows® 2000 and above.
SQL Server Service implements the SQL Server database engine. There is one SQL Server service for each instance of SQL Server running on the computer.
SQL Server Service Manager is a taskbar application and
follows the standard behavior of taskbar applications. The task bar icon will display whether the
Server is running 
,
paused, or stopped 
.
Important!!!! There is a field within the SQL Server Service Manager that you need to select, or ensure that it is enabled. It is called “Auto-start service when OS starts”. Please ensure this option is selected, especially when installing AVR as well, as the system will reboot after installing AVR. If this option is not selected, the SQL Server Service will be stopped, so when the installation process continues and tries to install DataGate for SQL Server, you will receive an error, and DataGate for SQL Server will not be installed.
Note that this option is not selected by default. You must select this option prior to installing DataGate for SQL Server (if installing AVR at the same time).
To Open, Start, Pause or Stop the SQL Server Manager
1.
After
Microsoft SQL Server is installed, the SQL Service Manager icon for the local
machine will display in the right hand corner of your taskbar. To open SQL Server Service Manager, either
double-click on the 
, or right-click on the icon to display a list of menu
options. The following dialog will
display.
Enter or select the following to SQL Server Service Manager:
Server:
The name of the local computer will display. Clicking on the arrow to the right will display all of the SQL Servers that you have access to.
Services:
The SQL Server service will display. Clicking on the arrow to the right will display the other SQL services you have access to, such as SQL Server Agent, and Distributed Transaction Coordinator.
Refresh services…
Select this button to refresh the services.
Start/Continue
Selecting this button starts the SQL Server Service. After it is started, the option will be dimmed, and the icon will display with a green start icon next to it, indicating the service is started. Select this option when the service is either currently paused, or stopped.
Pause
Select this button to temporarily pause the SQL Server Service. To continue service, select the Start/Continue button.
Stop
Select this button to stop the SQL Server Service. To start the service again, select the Start/Continue button.
Auto-start service when OS starts:
Select this option to ensure that the SQL Server Service automatically restarts after your system has been restarted.
Note that this option is not selected by default. You must select this option prior to installing DataGate for SQL Server (if installing AVR at the same time).
2.
To
close SQL Server Service Manager, right-click the SQL Server Service
Manager icon on the taskbar, and then select the Exit menu option.
DataGate for SQL Server is also installed with the AVR 8.1 and Windows Deployment installations. However, to install DSS on a system that does not have AVR, you can install from the CD or from the Developer Network Downloads page.
When installing DataGate for SQL Server, you should be signed on with Administrative Privileges to start the DataGate Service. If you are not signed on with Administrative Privileges, a Warning will display – stating that you need to have Administrative privileges to start the DataGate Service. Therefore, you may want to check with your Network Administrator prior to installing to ensure you have Administrative privileges.
To Install from ASNA Developer Network (DevNet)
1. Go to http://devnet.asna.com.
2. Click on Sign In link on the top right corner and sign in to your DevNet account, or select Create an Account on the left to create a new account.
3. Once you are signed in, click on the Downloads link at the top.
4. Scroll down and select the 8.1 product and version you wish to download.
5. On the next screen, the list of products in the product suite selected will display for you to select from.
6. 6. Select the product to install. The Release Notes for that product will display. In the right hand corner "Downloads" window, you will see the list of products available based on your sign in. Select the icon of the product to install. The installation exe will display for you to Run now, or Save to your system and install later.
To Install DataGate for SQL Server from CD
1. Insert the ASNA .NET Product Suite CD into your CD drive.
2. Click on ASNA DataGate 8.1 for Microsoft SQL Server 2000/2005.
3. Click on the Install… button to begin the installation.
Note that you can also View the Readme file by selecting the Read me button.
4. After the installation has installed for a few minutes, the stored procedures will install. A dialog will then display for you to respond to if you would like to select a SQL database name to be used as the special QTEMP library. The default is set as disabled. See Enabling SQL Database(s) to be used a QTEMP Library for further information.
5. Selecting Done or Install to the dialog below will complete the installation. A dialog will display indicating that the installation or update is complete.
Note that after DSS is installed, or if you already have AVR installed on your system, you can access Stored Procedures at any time from Start - Programs - ASNA .NET Product Suite - DataGate for SQL Server 8.1 - ASNA DataGate for SQL Server 8.1 Stored Procedures.
Enabling SQL Database(s) to be used as QTEMP Library
The DataGate for SQL Server dialog (Stored Procedures) displays during the installation of DataGate for SQL Server and when selecting the Stored Procedures option. It allows you to select a SQL Server instance and connect to SQL Server. You can set security information, as well as specify a SQL database to be used as a QTEMP library.
Note that after DSS is installed, you can access this dialog at any time from Start - Programs - ASNA .NET Product Suite - DataGate for SQL Server 8.1 - ASNA DataGate for SQL Server 8.1 Stored Procedures.
To Enable SQL Server Instance(s)
1. Enter or select the following to the SQL Server instance dialog.
SQL Server Instance:
This option displays the list of currently running and available named SQL Server instances specified on your system for DataGate setup.
-
Click on the arrow to the right to change or select another SQL Server Instance (if available).
Use Trusted Connection:
This option allows you to use integrated Login security to connect with SQL Server.
-
If checked (default), DataGate will use integrated Login security to connect with SQL Server.
-
If unchecked, you will need to enter a valid Login Name and Password to connect.
Login Name: -
This box is disabled if Use Trusted Connection is checked.
-
If enabled, specify a Login Name used to connect to SQL Server.
Password:
-
This box is disabled if Use Trusted Connection is checked.
-
If enabled, specify the Password for the Login Name used to connect to SQL Server.
QTEMP library support:
This option allows you to enable, or specify a SQL database name to be used as the special QTEMP library. By default, this option will be disabled.
-
To enable this support, click on the Enable button to enable the ability for a SQL database name to be used as the special QTEMP library. When the Enable button is selected, the "SQL Database to be used as QTEMP library" option will be enabled, for you to specify a SQL Database to be used as a QTEMP library.
-
To disable this support (if previously enabled), click on the Disable button. The "SQL Database to be used as QTEMP library" option will be disabled and appear 'dimmed'.
SQL Database to be used as QTEMP library:
This option will only be available if the Enable button has been clicked.
-
Specify the name of a SQL database to be used as the special QTEMP library. The name of the database does not have to be QTEMP, but it will be accessed by DataGate in response to requests for QTEMP library requests.
-
If the database does not exist, it will be created with default attributes.
Install Button:
Selecting Install will save the entries to the dialog and continue with the installation.
Please note that the Install button will only be enabled when the Enable button is selected.
Done Button:
Selecting Done indicates you are finished with the dialog, and that you will not specify a SQL Database to be used as a QTEMP library. The DSS installation will continue.
However, please note that selecting Done while accessing the Stored Procedures dialog from Start - Programs - ASNA .NET Product Suite - DataGate for SQL Server 8.1 - ASNA DataGate for SQL Server 8.1 Stored Procedures will display a dialog stating "DataGate For SQL Server was cancelled or was unable to install properly will display". Select the OK button to close the dialog box.
Help Button:
Select Help to display the help topic for additional
information.
ASNA DataGate 8.1 for SQL Server must be properly
licensed prior to using it. The steps to
license DataGate for SQL Server is exactly the same as licensing AVR
or DataGate Client.
Refer to the Registration Assistant help file (Regasist.chm)
in C:\Program Files\Common Files\ASNA Shared for more information!
After you have completed the installation procedure, you can
start any of the products included with DataGate at any time.
1. Start DataGate Database Manager by selecting Start – Programs - ASNA .NET Product Suite – DataGate – DataGate Database Manager.
2.
For
help on using any of the products, select Contents from the Help menu to
display the On-line help file.
To Remove ASNA DataGate for SQL Server
1. Select Start – Settings - Control Panel.
2. Select Add/Remove Programs.
3. Select ASNA DataGate 8.1 for SQL Server.
4. Click the Add/Remove… icon.
5. Click Yes to begin removing DataGate. Click No to return to the previous screen.
To remove Stored Procedures, you will need to also
select the ASNA DataGate for SQL Server 8.1 Stored Procedures option
separately.
SQL Server Service Manager is used to start, stop, and pause
the Microsoft® SQL Server™ 2000 components on the server. These components run as services on Microsoft Windows® 2000 and above.
SQL Server Service implements the SQL Server database engine. There is one SQL Server service for each instance of SQL Server running on the computer.
SQL Server Service Manager is a taskbar application and
follows the standard behavior of taskbar applications. The task bar icon will display whether the
Server is running ,
paused, or stopped .
Important!!!! There is a field within the SQL Server Service Manager that you need to select, or ensure that it is enabled. It is called “Auto-start service when OS starts”. Please ensure this option is selected, especially when installing AVR as well, as the system will reboot after installing AVR. If this option is not selected, the SQL Server Service will be stopped, so when the installation process continues and tries to install DataGate for SQL Server, you will receive an error, and DataGate for SQL Server will not be installed.
Note that this option is not selected by default. You must select this option prior to installing DataGate for SQL Server (if installing AVR at the same time).
To Open, Start, Pause or Stop the SQL Server Manager
1.
After
Microsoft SQL Server is installed, the SQL Service Manager icon for the local
machine will display in the right hand corner of your taskbar. To open SQL Server Service Manager, either
double-click on the , or right-click on the icon to display a list of menu options. The SQL Server Service Manager dialog will display.
Enter or select the following to SQL Server Service Manager:
Server:
The name of the local computer will display. Clicking on the arrow to the right will display all of the SQL Servers that you have access to.
Services:
The SQL Server service will display. Clicking on the arrow to the right will display the other SQL services you have access to, such as SQL Server Agent, and Distributed Transaction Coordinator.
Refresh services…
Select this button to refresh the services.
Start/Continue
Selecting this button starts the SQL Server Service. After it is started, the option will be dimmed, and the icon will display with a green start icon next to it, indicating the service is started. Select this option when the service is either currently paused, or stopped.
Pause
Select this button to temporarily pause the SQL Server Service. To continue service, select the Start/Continue button.
Stop
Select this button to stop the SQL Server Service. To start the service again, select the Start/Continue button.
Auto-start service when OS starts:
Select this option to ensure that the SQL Server Service automatically restarts after your system has been restarted.
Note that this option is not selected by default. You must select this option prior to installing DataGate for SQL Server (if installing AVR at the same time).
2.
To
close SQL Server Service Manager, right-click the SQL Server Service
Manager icon on the taskbar, and then select the Exit menu option.
Release Notes
ASNA DataGate 8.1 for
SQL Server also supports SQL Server 2005 and SQL Server 2005 Express.
Licensing Changes
DataGate 8.1 for SQL Server employs a new
License Manager that eliminates the duplicate user counts that were encountered
in previous versions.
Installing Microsoft's XP Pro Service Pack 2, by default, enables the built-in Windows firewall settings which interfere with SQL Server connectivity. These settings, unless changed, won't let you connect to SQL Server 2000 (with either SQL Server's own Enterprise Manager or with ASNA's DataGate for SQL Server (DSS).
The Windows Firewall closes ports such as 445 that are used for file and printer sharing to prevent Internet computers from connecting to file and print shares on your computer or to other resources. When SQL Server is configured to listen for incoming client connections by using named pipes over a NetBIOS session, SQL Server communicates over TCP ports and these ports must be open. SQL Server clients that are trying to connect to SQL Server will be not be able to connect until SQL Server is set as an exception in Windows Firewall. To set SQL Server as an exception in Windows Firewall, use the steps that are listed here.
As part of the basic strategy to give SQL Server the semantics of
DB2/400, DataGate for SQL Server (DSS) was built to permit as much manipulation
as possible of the underlying objects directly, via native SQL commands. As a
consequence of such strategy, it was decided that there would be no artificial
structure imposed on the tables and views used to implement the concept of
physical and logical files. Files were then implemented as follows:
·
A
Physical file is implemented as a Table.
An Indexed Physical file requires an Index with the same name as the
Table.
·
A
Simple Logical file is implemented
as a View. An Indexed Simple Logical file requires an
Index with the same name as the View.
·
A
Join Logical file is implemented as
a View. An Indexed Join Logical file requires an
Index with the same name as the View.
This index marks which table is considered the ‘primary file’.
When a simple logical file is
created, it is possible to establish the underlying ‘Select’ in two ways:
·
Select
individual columns from the table.
·
Select
all columns via a ‘Select * from TableX’ by checking the ‘Clone base file
fields in new format’ check box.
In either case, the SCHEMABINDING option is not used; this permits the
table to be altered, thus new columns can be added to an existing table without
having to drop the views first. However,
SQL Server does not reflect the new columns in the corresponding views (those
with the ‘Select * ’ command) until such views are recreated.
This is a natural behavior of SQL Server views and DSS does not alter it. Notice also that DSS does not provide a way to add new fields to a file, so the procedure aforementioned has to be done using SQL Server’s Enterprise Manager.
Contents
Native SQL Server Field Interpretation
Calling
Programs/Procedures Considerations
|
Item |
DG/400 |
DSS for .NET |
DataGate |
|
Library & file name length |
10 characters |
31 characters |
31 |
|
Members per file |
0 ® *NoMax |
Exactly
1 |
0 ®
*NoMax |
|
File types |
Physical Simple logical Join logical Multiformat logical Print |
Physical SqlLogical Simple logical Join logical Print |
Physical Simple logical Join logical Multiformat logical Print |
|
Max record length |
32,000
bytes |
8,060
bytes (Not counting Text and Image fields which are not accessible yet by DSS
.NET). |
32,000 bytes |
|
Max number of records per member |
|
2,147,483,646 |
2,147,483,646* |
|
Library implemented as: |
Library |
Database |
Illusion |
|
Object text (description) |
49 characters |
49 characters |
49 characters |
|
Stored Procedures |
Any AS/400 language |
Programmed in SQL-Transact |
None |
|
Triggers |
Any AS/400 language |
Programmed in SQL-Transact |
None |
|
Field Reference File (FRF) |
A physical file can refer to any number of
FRF, which are any physical file in any library. However, DG/400 will report
only those coming from the file stated in the DDS REF keyword. |
Refers to the collection of ‘User Defined
Data Types’, which is one per Database (i.e.: Library). This collection is surfaced via the special
file ‘*FieldRef’
which is the ONLY file usable as a FRF. |
A physical file can refer to only ONE
FRF, which can be any physical file in any library. |
* NOTE:
For Max number of records per member, DataGate for Windows and
Desktop Servers Release 8.1, Version 8.155 and higher support member/file sizes
limit is 16 exabytes ( 2^4 * 2^60).
|
Item |
DG/400 |
DSS
.NET |
DataGate |
|
Indexed logical
files per physical file |
|
249 |
*NoMax |
|
Logical field
used as a key field must be based on a physical field with the same name |
No |
Yes.
Notice that this eliminates the possibility of using Renamed,
Concatenated and Substringed fields as keys. |
No |
|
Maximum number
of key fields per key |
|
16 |
250 |
|
Maximum length
of key in bytes |
2,000 |
900 |
250 |
Data Access Considerations
|
Item |
DG/400 |
DSS
.NET |
DataGate |
|
Arrival Access |
Relative Record
Number is used for Sequential and Random access. |
Only Consecutive access is supported, but
there is no guaranteed order of retrieval unless the file is indexed. The only random operation allowed is SetLL
and this is only when used with *Start and *End. No other kind of seeking
(SetGT,CHAIN) is allowed. |
Relative Record
Number is used for Sequential and Random access. |
|
Format Name |
Given by file
creator. |
Always
‘R’ followed by File Name. Note to AVR Users: The Format can be renamed
in the DclDiskFile, using the RNMFMT keyword by providing a new name, is not
necessary to provide the existing Name in the RNMFMT. This allows the
creation of single-source apps that can compile against DG/400 and DSS .NET. |
Given by File creator. |
|
Open Query File |
Implemented
with OpenQry. |
Select expression is used as the WHERE
clause of a SELECT. The key field list
is used as the ORDER BY clause. The select expression is passed directly to
the SQL analyzer with no interpretation. The expression must follow
valid SQL Server syntax. Pay special
attention to uses of logical operators. Use ‘and’ and ‘or’ not ‘&’
and ‘|’. |
A temporary
logical file is created using the select expression as a select/omit
expression and the key field list to define the new key. |
Record Locking
DG/400
DB2/400 determines the type and duration of
records locks depending on how the file was opened.
For read-only files, when a record is read, there is no lock requested on it, and if some other application has the record lock, the reading application does not block on the lock, that is, the record gets read in-spite of being locked by somebody else.
For files open for update, every time a record is read it is write-locked so that other updating applications can’t read it. The write lock is held until the record is updated or explicitly unlock by the application or when another record is read or positioned to.
DSS .NET
DSS for .NET (using server cursors) also
determines the locking characteristics bases on how the file is opened.
For read-only files DSS for .NET behaves like DG/400, that is, there are no locks neither placed nor considered on records being read.
The behavior of DSS for .NET when the file is opened for update is similar to DG/400 but with two significant differences: updating a record does not release the lock on the record and explicitly unlocking a record causes the ‘current record position’ to be lost. These differences bear the following considerations.
|
Item |
DG/400 |
DSS .NET |
|
|
Unlock
Record |
Cursor
position is unchanged. |
The
file has no ‘current’ position after the Unlock. |
|
|
Update
Record |
The
record just updated is released. |
The record just updated is kept locked. |
|
|
*NoLock
option on Read operations |
Supported but deprecated. |
Unsupported. The better way to achieve this is to open the file twice, once for input only and the other for update. Where the read appears with the *NoLock option, the file should be substituted with the one open for input only. By doing this, the application can take advantage of network blocking - yielding better performance. |
|
|
Range
operations |
When the end of the range is reached, the file has no ‘current’ position. |
When the end of the range is reached, the file has no ‘current’ position. |
|
|
Hit
EOF on a ReadE (P) |
Lose Record position. |
Lose Record position. |
|
|
Other
Operations like SetLL |
Unlock Record. |
Unlock Record. |
|
Loops involving SetLL/SetGT and
Read/ReadE/ReadPE should be recoded to use the Range operations.
The most demanding change is the one requiring segments of code involving CHAIN-UPDATE. Combinations have to be studied and possibly modified.
·
If
the CHAIN-UPDATE happens in a tight loop, then at the end of the loop an UNLOCK
should be issued to release the last record updated. Notice however that the
record position will be lost after the UNLOCK.
·
If
the CHAIN-UPDATE is sprinkled throughout the code, then each case has to be
closely studied.
Object Locking
Not
implemented on DSS .NET.
|
Item |
DG/400 |
DSS
.NET |
DataGate |
|
Field name
length |
10 characters |
31 characters |
31 |
|
Types supported |
Char ®
*CHAR Packed ®
*PACKED Zoned ® *ZONED Binary ® *BINARY Float ® *FLOAT Integer ® *INTEGER Date ® *DATE Time ® *TIME Timestamp ® *TIMESTAMP Hex ® *HEX DBCS ® *DBCS Unicode ® *DBCS Boolean ® *CHAR(1) |
Char ®
char Packed ®
decimal Zoned ® numeric Binary ® numeric Float(4) ® float Float(8) ® real Integer(2) ® smallint Integer(4) ® int Date ® *ASNA_DSS .NET_DATE datetime= Time ® *ASNA_DSS .NET_TIME datetime=1899/12/30 Timestamp ® datetime Hex ® binary DBCS ® nchar Unicode ® nchar Boolean ®
Bit |
Char ®
*CHAR Packed ®
*PACKED Zoned ® *ZONED Binary ® *BINARY Float ® *FLOAT Integer ® *INTEGER Date ® *DATE Time ® *TIME Timestamp ® *TIMESTAMP Hex ® *HEX DBCS ® *DBCS Unicode ® *DBCS Boolean ®
*CHAR(1) |
|
Allow Nulls |
Yes |
Yes |
No |
|
Variable Length
Fields |
Char Hex DBCS |
Char ®
varchar Hex ®
varbinary DBCS ® varnchar |
No |
|
Date value
range |
|
Datetime
(ASNA_DSS .NET_DATE): 1753-01-01 ®
9999-12-31 Smalldatetime: 1900-01-01 ® 2079-06-06 |
|
|
Decimal Number
Storage |
Packed (1 nibble per digit) |