Reference data includes symbol files, rules written in Visual Basic, and Excel bulkload files used to create and populate SQL tables in the catalog database. The text string names in reference data are used by several applications such as SQL Server, Visual Basic, 2D Symbols, and Solid Edge. The text strings must conform to the character and key word restrictions of these applications.
If illegal characters or reserved keywords are used, database views in SQL are corrupted. This situation affects reports and drawing labels using the specific views. For example, a report that attempts to use a slot parameter with an illegal character will fail. The views are not used by the detailing rules, so this slot parameter would not cause a problem with detailing.
Restricted Text Strings
In 2D Symbols, restrictions apply to parameter names and symbol file names.
In Excel bulkload files, restrictions apply to the following text strings:
Worksheet |
Text String |
Comments |
---|---|---|
All |
Sheet Name |
Blank spaces in part class sheets are deleted by the bulkload software. Other illegal characters are not removed. We recommend that you treat the sheet name as restricted. |
CustomInterfaces |
InterfaceName |
|
Data Sheets |
PartClassType |
ProgIDs must follow Visual Basic ProgID naming rules (Project.Class). |
ClassNodeType |
ObjectName |
|
R-Hierarchy |
RelationSource |
|
R- ClassNodeDescribes |
RelationSource |
Text strings that provide description data, such as Part Description or Material Description, may contain blanks.
Allowed Characters
Restricted text strings should follow these rules for character usage:
Allowed Characters |
Not Allowed |
---|---|
The first character must be a letter or an underscore (_). |
The first character cannot be a number. |
Other characters: |
Other characters: |
A letter |
Blanks |
A number |
( |
$ |
) |
_(underscore) |
{ |
} |
Reserved Keywords in SQL Server and ODBC
Restricted text strings must not be any of the following keywords reserved by SQL Server 2000, SQL-92, and ODBC. For example, a restricted text string ADD is not allowed because ADD is a reserved keyword. However, the restricted text string ADD_Radius is allowed.
ARE |
FOREIGN |
PROCEDURE |
AS |
FORTRAN |
PUBLIC |
ASC |
FOUND |
RAISERROR |
ASSERTION |
FREETEXT |
READ |
AT |
FREETEXTTABLE |
READTEXT |
AUTHORIZATION |
FROM |
REAL |
AVG |
FULL |
RECONFIGURE |
BACKUP |
FUNCTION |
REFERENCES |
BEGIN |
GET |
RELATIVE |
BETWEEN |
GLOBAL |
REPLICATION |
BIT |
GO |
RESTORE |
BIT_LENGTH |
GOTO |
RESTRICT |
BOTH |
GRANT |
RETURN |
BREAK |
GROUP |
REVOKE |
BROWSE |
HAVING |
RIGHT |
BULK |
HOLDLOCK |
RIGHT |
BY |
HOUR |
ROLLBACK |
CASCADE |
IDENTITY |
ROWCOUNT |
CASCADED |
IDENTITY_INSERT |
ROWGUIDCOL |
CASE |
IDENTITYCOL |
ROWS |
CAST |
IF |
RULE |
CATALOG |
IMMEDIATE |
SAVE |
CHAR |
IN |
SCHEMA |
CHAR_LENGTH |
INCLUDE |
SCROLL |
CHARACTER |
INDEX |
SECOND |
CHARACTER_LENGTH |
INDICATOR |
SECTION |
CHECK |
INITIALLY |
SELECT |
CHECKPOINT |
INNER |
SESSION |
CLOSE |
INPUT |
SESSION_USER |
CLUSTERED |
INSENSITIVE |
SET |
COALESCE |
INSERT |
SETUSER |
COLLATE |
INT |
SHUTDOWN |
COLLATION |
INTEGER |
SIZE |
COLUMN |
INTERSECT |
SMALLINT |
COMMIT |
INTERVAL |
SOME |
COMPUTE |
INTO |
SPACE |
CONNECT |
IS |
SQL |
CONNECTION |
ISOLATION |
SQLCA |
CONSTRAINT |
JOIN |
SQLCODE |
CONSTRAINTS |
KEY |
SQLERROR |
CONTAINS |
KILL |
SQLSTATE |
CONTAINSTABLE |
LANGUAGE |
SQLWARNING |
CONTINUE |
LAST |
STATISTICS |
CONVERT |
LEADING |
SUBSTRING |
CORRESPONDING |
LEFT |
SUM |
COUNT |
LEVEL |
SYSTEM_USER |
CREATE |
LIKE |
TABLE |
CROSS |
LINENO |
TEMPORARY |
CROSS |
LOAD |
TEXTSIZE |
CURRENT |
LOCAL |
THEN |
CURRENT_DATE |
LOWER |
TIME |
CURRENT_TIME |
MATCH |
TIMESTAMP |
CURRENT_TIMESTAMP |
MAX |
TIMEZONE_HOUR |
CURRENT_USER |
MIN |
TIMEZONE_MINUTE |
CURSOR |
MINUTE |
TO |
DATABASE |
MODULE |
TOP |
DATE |
MONTH |
TRAILING |
DAY |
NAMES |
TRAN |
DBCC |
NATIONAL |
TRANSACTION |
DEALLOCATE |
NATURAL |
TRANSLATE |
DEC |
NCHAR |
TRANSLATION |
DECIMAL |
NEXT |
TRIGGER |
DECLARE |
NO |
TRIM |
DEFAULT |
NOCHECK |
TRUE |
DEFERRABLE |
NONCLUSTERED |
TRUNCATE |
DEFERRED |
NONE |
TSEQUAL |
DELETE |
NOT |
UNION |
DENY |
NULL |
UNIQUE |
DESC |
NULLIF |
UNKNOWN |
DESCRIBE |
NUMERIC |
UPDATE |
DESCRIPTOR |
OCTET_LENGTH |
UPDATETEXT |
DIAGNOSTICS |
OF |
UPPER |
DISCONNECT |
OFF |
USAGE |
DISK |
OFFSETS |
USE |
DISTINCT |
ON |
USER |
DISTRIBUTED |
ONLY |
USING |
DOMAIN |
OPEN |
VALUE |
DOUBLE |
OPENDATASOURCE |
VALUES |
DROP |
OPENQUERY |
VARCHAR |
DUMMY |
OPENROWSET |
VARYING |
DUMP |
OPENXML |
VIEW |
ELSE |
OPTION |
WAITFOR |
END |
OR |
WHEN |
END-EXEC |
ORDER |
WHENEVER |
ERRLVL |
OUTER |
WHERE |
ESCAPE |
OUTPUT |
WHILE |
EXCEPT |
OVER |
WITH |
EXCEPTION |
PAD |
WORK |
EXEC |
PARTIAL |
WRITE |
EXECUTE |
PASCAL |
WRITETEXT |
EXISTS |
PERCENT |
YEAR |
EXIT |
PLAN |
ZONE |
Future Keywords in SQL Server 2000
The following keywords may be reserved in future releases of SQL. Consider avoiding the use of these words in restricted text strings.
ADMIN |
EVERY |
READS |
AFTER |
EXCEPTION |
RECURSIVE |
AGGREGATE |
FREE |
REF |
ALIAS |
GENERAL |
REFERENCING |
ALLOCATE |
GROUPING |
RESULT |
ARE |
HOST |
RETURNS |
ARRAY |
IGNORE |
ROLE |
BEFORE |
INITIALIZE |
ROLLUP |
BINARY |
INOUT |
ROUTINE |
BLOB |
ITERATE |
ROW |
BOOLEAN |
LARGE |
SAVEPOINT |
BREADTH |
LATERAL |
SCOPE |
CALL |
LESS |
SEARCH |
CLASS |
LIMIT |
SEQUENCE |
CLOB |
LOCALTIME |
SETS |
COMPLETION |
LOCALTIMESTAMP |
SPECIFIC |
CONSTRUCTOR |
LOCATOR |
SQECIFICTYPE |
CUBE |
MAP |
SQLEXCEPTION |
CURRENT_PATH |
MODIFIES |
START |
CURRENT_ROLE |
MODIFY |
STATE |
CYCLE |
NCLOB |
STATEMENT |
DATA |
NEW |
STATIC |
DEPTH |
OBJECT |
STRUCTURE |
DEREF |
OLD |
TERMINATE |
DESTROY |
OPERATION |
THAN |
DESTRUCTOR |
ORDINALITY |
TREAT |
DETERMINISTIC |
OUT |
UNDER |
DIAGNOSTICS |
PARAMETER |
UNNEST |
DICTIONARY |
PARAMETERS |
USING |
DISCONNECT |
PATH |
VARIABLE |
DYNAMIC |
POSTFIX |
WITHOUT |
EACH |
PREFIX |
|
EQUALS |
PREORDER |