Reserved words for V2R3

[jhall]

Does anyone know the new reserved words for V2R3?

 

[stuartmac]

So who's a lucky person using V2R3 - from what I've read it would fulfil a lot of 'wants' from my users.<br>
NCR aren't always forward in providing hard copy manuals or examples but they do provide copious documentation on their site

http://www.info.ncr.com/<br>

It can be foudn right at the bottom of their home page under 'support link'<br>
Downloads can take time unless you have a nice quick ISDN line (at work?)<br>
Anyway, in the SQL quick reference this is teh list of ALL the keywords. To find teh new ones you coudl always import the V2R2 keywords and compare.<br>
Have fun,<br>
StuartMac<br>
<br>
<br>
SQL Keywords<br>
-1 Teradata RDBMS SQL/Data Dictionary Quick Reference A<br>
Teradata SQL Keywords<br>
A<br>
SQL Keywords<br>
1<br>
The Teradata SQL keywords, which are reserved for use<br>
in SQL statements, are listed below. For abbreviations,<br>
the full spelling follows the abbreviation, in<br>
parentheses).<br>
ABORT<br>
ABORTSESSION<br>
ABS<br>
ACCESS_LOCK<br>
ACCOUNT<br>
ADD<br>
ADD_MONTHS<br>
AFTER<br>
ALIAS<br>
ALL<br>
ALTER<br>
AMP<br>
AND<br>
ANSIDATE<br>
ANY<br>
AS<br>
ASC<br>
ASCII<br>
AT<br>
ATOMIC<br>
AUTHORIZATION<br>
AVE (AVERAGE)<br>
AVERAGE<br>
AVG (AVERAGE)<br>
BACKUP<br>
BEFORE<br>
BEGIN<br>
BETWEEN<br>
BOTH<br>
BT (BEGIN TRANSACTION)<br>
BUT<br>
BY<br>
BYTE<br>
BYTEINT<br>
BYTES <br>
CASE<br>
CASESPECIFIC<br>
CAST<br>
CD (CREATE DATABASE)<br>
CHAR (CHARACTERS)<br>
CHAR_LENGTH<br>
CHARACTER_LENGTH<br>
CHARACTER (CHARACTERS)<br>
CHAR2HEXINT<br>
CHARACTERS<br>
CHARS (CHARACTERS)<br>
CHECK<br>
CHECKPOINT<br>
CHECKSUM<br>
CLUSTER<br>
CM (CREATE MACRO)<br>
COALESCE<br>
COLLATION<br>
COLLECT<br>
COLUMN<br>
COMMENT<br>
COMMIT<br>
COMPRESS<br>
CONSTRAINT<br>
CONVERT<br>
CONVERT_TABLE_HEADER<br>
COUNT<br>
CREATE<br>
CROSS<br>
CS (CASESPECIFIC)<br>
CSUM<br>
CT (CREATE TABLE)<br>
CURRENT<br>
CURRENT_DATE<br>
CURRENT_TIME<br>
CURRENT_TIMESTAMP<br>
CURSOR<br>
CV (CREATE VIEW)<br>
DATABLOCKSIZE<br>
DATABASE<br>
DATE<br>
DATEFORM<br>
DAY<br>
DEC (DECIMAL)<br>
DECIMAL<br>
DEFAULT<br>
DEL (DELETE)<br>
DELETE<br>
DESC<br>
DESCRIPTOR<br>
DIAGNOSTIC<br>
DISABLED<br>
DISTINCT<br>
DOUBLE<br>
DROP<br>
DUAL<br>
DUMP<br>
EACH<br>
EBCDIC<br>
ECHO<br>
ELSE<br>
ENABLED<br>
END<br>
EQ ( = )<br>
ERROR<br>
ERRORFILES<br>
ERRORTABLES<br>
ESCAPE<br>
ET (END TRANSACTION)<br>
EXCEPT<br>
EXCL (EXCLUSIVE)<br>
EXCLUSIVE<br>
EXEC (EXECUTE)<br>
EXECUTE<br>
EXISTS<br>
EXP<br>
EXPLAIN<br>
EXTRACT<br>
FALLBACK<br>
FASTEXPORT<br>
FIRST<br>
FLOAT<br>
FOR<br>
FOREIGN<br>
FORMAT<br>
FREESPACE<br>
FROM<br>
FULL<br>
GE ( &gt;= )<br>
GIVE<br>
GLOBAL<br>
GO<br>
GOTO<br>
GRANT<br>
GRAPHIC<br>
GROUP<br>
GT ( &gt; )<br>
HASH<br>
HASHAMP<br>
HASHBAKAMP<br>
HASHBUCKET<br>
HASHROW<br>
HAVING<br>
HELP<br>
HOUR<br>
IMMEDIATE<br>
IN<br>
INCONSISTENT<br>
INDEX<br>
INDICATOR<br>
INITIATE<br>
INNER<br>
INS (INSERT)<br>
INSERT<br>
INSTEAD<br>
INT (INTEGER)<br>
INTEGER<br>
INTEGERDATE<br>
INTERSECT<br>
INTERVAL<br>
INTO<br>
IS<br>
JOIN<br>
JOURNAL<br>
KBYTES<br>
KEY<br>
KILOBYTES<br>
LAST<br>
LE ( &lt;= )<br>
LEADING<br>
LEFT<br>
LEVEL<br>
LIKE<br>
LN<br>
LOADING<br>
LOCAL<br>
LOCK (LOCKING)<br>
LOCKING<br>
LOG<br>
LOGGING<br>
LOGON<br>
LONG<br>
LOWER<br>
LT ( &lt; )<br>
MACRO<br>
MAVG<br>
MAX (MAXIMUM)<br>
MAXIMUM<br>
MCHARACTERS<br>
MDIFF<br>
MIN (MINIMUM)<br>
MINDEX<br>
MINIMUM<br>
MINUS<br>
MINUTE<br>
MLINREG<br>
MLOAD<br>
MOD<br>
MODE<br>
MODIFY<br>
MONITOR<br>
MONRESOURCE<br>
MONSESSION<br>
MONTH<br>
MSUBSTR<br>
MSUM<br>
MULTISET<br>
NAMED<br>
NATURAL<br>
NE<br>
NEW<br>
NEW_TABLE<br>
NO<br>
NOT<br>
NOWAIT<br>
NULL<br>
NULLIF<br>
NULLIFZERO<br>
NUMERIC<br>
OCTET_LENGTH<br>
OF<br>
OFF<br>
OLD<br>
OLD_TABLE<br>
ON<br>
OPTION<br>
OR<br>
ORDER<br>
OUTER<br>
OVERLAP<br>
OVERLAPS<br>
OVERRIDE<br>
PASSWORD<br>
PERCENT<br>
PERM (PERMANENT)<br>
PERMANENT<br>
PN<br>
POSITION<br>
PRECISION<br>
PRESERVE<br>
PRIMARY<br>
PRIVATE<br>
PRIVILEGES<br>
PROTECTION<br>
PUBLIC<br>
QUALIFY<br>
QUANTILE<br>
RANK<br>
READ<br>
REAL<br>
REFERENCES<br>
REFERENCING<br>
RELEASE<br>
RENAME<br>
REPLACE<br>
REPLICATION<br>
REPOVERRIDE<br>
REQUEST<br>
RESTART<br>
RESTORE<br>
RESUME<br>
RET (RETRIEVE)<br>
RETRIEVE<br>
REVALIDATE<br>
REVOKE<br>
RIGHT<br>
RIGHTS<br>
ROLE<br>
ROLLBACK<br>
ROLLFORWARD<br>
ROW<br>
ROWID<br>
SAMPLE<br>
SAMPLEID<br>
SECOND<br>
SEL (SELECT)<br>
SELECT<br>
SESSION<br>
SET<br>
SETSESSRATE<br>
SETRESRATE<br>
SHARE<br>
SHOW<br>
SMALLINT<br>
SOME<br>
SPOOL<br>
SQRT<br>
SS (SET SESSION)<br>
STARTUP<br>
STATEMENT<br>
STATISTICS<br>
STRING_CHK<br>
STRING_CS<br>
SUBSCRIBER<br>
SUBSTR<br>
SUBSTRING<br>
SUM<br>
SUSPEND<br>
SYS_CALENDAR<br>
TABLE<br>
TBL_CS<br>
TEMPORARY<br>
TERMINATE<br>
THEN<br>
TIME<br>
TIMESTAMP<br>
TIMEZONE_HOUR<br>
TIMEZONE_MINUTE<br>
TITLE<br>
TO<br>
TRAILING<br>
TRANSACTION<br>
TRANSLATE<br>
TRANSLATE_CHK<br>
TRIGGER<br>
TRIM<br>
TYPE<br>
UC (UPPERCASE)<br>
UNDEFINED<br>
UNION<br>
UNIQUE<br>
UPD (UPDATE)<br>
UPDATE<br>
UPPER<br>
UPPERCASE<br>
USER<br>
USING<br>
VALUES<br>
VARBYTE<br>
VARCHAR<br>
VARGRAPHIC<br>
VARYING<br>
VIEW<br>
VOLATILE<br>
WAIT<br>
WHEN<br>
WHERE<br>
WITH<br>
WORK<br>
WRITE<br>
YEAR<br>
ZEROIFNULL<br>
ZONE

 

[jhall]

Thanks for your response. I don't have V2R3 in hand yet, but I'm hoping to have access to it in the near future. I can be reached privately at john.hall@detroitmi.ncr.com - feel free to drop me a note.

 

[teradude]

An exhaustive list of TDAT and ANSI keywords can be found in <br>
Language: English ID#: SA100080D86 on Support Link. If you want it on email, contact me at kroloson@att.com. This is very important for the DBA to review long before going to V2R3. It is a red jeopardy if not done proactively.

 

[Netstat]

Do you know if there is a data dictionary tabel that contains these keywords?

 

[teradude]

I would not think so! It is listed in NCR's Support Link as I noted in previous msg. These keywords, if already in use, would be found in misc. customer tables, and therefore in conflict with NCR's underlying support structure.
Check out the online doc that I refer to in July 18,1999 message.

teradude