다음에 나오는 단어들은 SQL문장 등 DB2 에서 사용하는 고유한(예약된) 단어들입니다. 테이블의 컬럼명이나 프로그램에서의 변수 선언시 아래의 단어들은 사용안하시는것이 좋습니다.
SQL reserved words
ADD
AFTER
ALL
ALLOCATE
ALLOW
ALTER
AND
ANY
APPLICATION
AS
ASSOCIATE
ASUTIME
AUDIT
AUX
AUXILIARY
BEFORE
BEGIN
BETWEEN BUFFERPOOL
BY
CALL
CAPTURE
CASCADED
CASE
CAST
CCSID
CHAR
CHARACTER
CHECK
CLOSE
CLUSTER
COLLECTION
COLLID
COLUMN
COMMENT
COMMIT
CONCAT
CONDITION
CONNECT
CONNECTION
CONSTRAINT
CONTAINS
CONTINUE
CREATE
CURRENT
CURRENT_DATE
CURRENT_LC_CTYPE
CURRENT_PATH
CURRENT_TIME CURRENT_TIMESTAMP
CURSOR
DATA
DATABASE
DAY
DAYS
DBINFO
DB2SQL
DECLARE
DEFAULT
DELETE
DESCRIPTOR
DETERMINISTIC
DISALLOW
DISTINCT
DO
DOUBLE
DROP
DSNHATTR
DSSIZE
DYNAMIC
EDITPROC
ELSE
ELSEIF
ENCODING
END
END-EXEC(1)
ERASE
ESCAPE
EXCEPT
EXECUTE
EXISTS
EXIT
EXTERNAL
FENCED
FETCH
FIELDPROC
FINAL
FOR
FROM
FULL
FUNCTION
GENERAL
GENERATED
GET
GLOBAL
GO
GOTO
GRANT
GROUP
HANDLER
HAVING
HOUR
HOURS
IF
IMMEDIATE
IN
INDEX
INHERIT
INNER
INOUT
INSENSITIVE
INSERT
INTO
IS
ISOBID
JAR
JAVA
JOIN
KEY
LABEL
LANGUAGE
LC_CTYPE
LEAVE
LEFT
LIKE
LOCAL
LOCALE
LOCATOR
LOCATORS
LOCK
LOCKMAX
LOCKSIZE
LONG
LOOP
MICROSECOND
MICROSECONDS
MINUTE
MINUTES
MODIFIES
MONTH
MONTHS
NO
NOT
NULL
NULLS
NUMPARTS
OBID
OF
ON
OPEN
OPTIMIZATION
OPTIMIZE
OR
ORDER
OUT
OUTER
PACKAGE
PARAMETER
PART
PATH
PIECESIZE
PLAN
PRECISION
PREPARE
PRIQTY
PRIVILEGES
PROCEDURE
PROGRAM
PSID
QUERYNO
READS
REFERENCES
RELEASE
RENAME
REPEAT
RESTRICT
RESULT
RESULT_SET_LOCATOR
RETURN
RETURNS
REVOKE
RIGHT
ROLLBACK
RUN
SAVEPOINT
SCHEMA
SCRATCHPAD
SECOND
SECONDS
SECQTY
SECURITY
SELECT
SENSITIVE
SET
SIMPLE
SOME
SOURCE
SPECIFIC
STANDARD
STATIC
STAY
STOGROUP
STORES
STYLE
SUBPAGES
SYNONYM
SYSFUN
SYSIBM
SYSPROC
SYSTEM
TABLE
TABLESPACE
THEN
TO
TRIGGER
UNDO
UNION
UNIQUE
UNTIL
UPDATE
USER
USING
VALIDPROC
VALUES
VARIANT
VCAT
VIEW
VOLUMES
WHEN
WHERE
WHILE
WITH
WLM
YEAR
YEARS
Note: (1)COBOL only
|