Character and Keyword Restrictions - Intergraph Smart 3D - Reference Data - Hexagon PPM

Intergraph Smart 3D 2D Symbols

Language
English
Product
Intergraph Smart 3D
Subproduct
2D Symbols
Search by Category
Reference Data
Smart 3D Version
13
SmartSketch Version
11

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
AttributeName
Type
SymbolParameter

Data Sheets

PartClassType
Parameters
Item Names
ProgIDs

ProgIDs must follow Visual Basic ProgID naming rules (Project.Class).

ClassNodeType

ObjectName

R-Hierarchy

RelationSource
RelationDestination

R- ClassNodeDescribes

RelationSource
RelationDestination

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

See Also

Symbol Naming Conventions