User Guide

SAP AG November 2002
You can make additional clients available using a script interface to Perl or Python.
Entering SQL Statements
You can use SQL Studio to enter SQL statements, such as data requests. You can use the
following clients:
• SQL Studio on Windows-based operating systems
• Web SQL
Unloading and Loading of Data
You can use the SAP DB Loader to unload and load data. You can use the following client:
• SAP DB Loader CLI (LOADERCLI)
You can make additional clients available using a script interface to Perl or Python.
Technical Specification of SAP DB Version 7.4
Restrictions
Maximum Value
Size of data area 32 TB (with 8 KB page size)
Number of data volumes per database Default value: 256
You can use the database parameter
DEVNO_BIT_COUNT to set a value
between 64 and 4096 when you install the
database system
Size of a data volume Default value: 128 GB
Depends on the number of data volumes
Size of the log area. 32 TB
SQL statement length >= 16 KB (Default value 64 KB, defined by
a database parameter)
Defined by a database parameter
Identifier length 32 characters
Numeric precision 38 places
unlimited
Number of columns per table (with KEY) 1024
Number of columns per table (without KEY) 1023
Number of primary key columns per table 512
Number of foreign key columns per table 16
Number of the columns in an ORDER or GROUP
clause
128
Number of columns in a SELECT statement 1023
Number of columns in an INSERT statement 1024
1023
SQL character string length
Number of tables
Number of columns in an index 16
Number of columns in a results table
User Manual: SAP DB 121