The following table lists default locations for SQL scripts:
Table 3-1 Default Locations for SQL Scripts
Platform |
Default Location |
---|---|
Windows* |
c:\novell\NDS\DirXMLUtilities\jdbc\sql\database-abbreviation |
UNIX* or Linux* |
/opt/novell/eDirectory/lib/dirxml/rules/jdbc/sql/database-abbreviation |
For example, when the scripts are installed on a SUSE Linux Enterprise Server with eDirectory, the DB2 scripts are found in opt/novell/eDirectory/lib/dirxml/rules/jdbc/db2/*.
All SQL scripts use the same conventions, regardless of the database.
The maximum size of a DB2 identifier is 18 characters. This least common denominator length defines the upper bound of database identifier length across all SQL scripts. Because of this restricted length, abbreviations are used. The following table summarizes identifier abbreviations and their meanings:
Table 3-2 Identifier Abbreviations and Meanings
Instead of proc_, the more common abbreviation is sp_. This prefix is reserved for system-stored procedures on Microsoft* SQL Server. Also, this prefix forces lookup of a procedure first in the master database before evaluating any qualifiers (for example, database or owner). To maximize procedure lookup efficiency, this prefix has been deliberately avoided.
The following table indicates identifier naming conventions for indexes, triggers, stored procedures, functions, and constraints:
Table 3-3 Identifier Naming Conventions
Other conventions:
All database identifiers are lowercase.
This is the most commonly used case convention between databases.
String field lengths are 64 characters.
Fields of this length can hold most eDirectory attribute values. You might want to refine field lengths to enhance storage efficiency.
For performance reasons, primary key columns use native, scalar numeric types whenever possible (such as BIGINT as opposed to NUMERIC).
The record_id column in event log tables has the maximum numeric precision permitted by each database to avoid overflow.
Identity columns and sequence objects do not cache values. Some databases throw away cached values when a rollback occurs. This action can cause large gaps in identity column or sequence values.